Monday, December 18, 2006

Exporting a SAS dataset to Microsoft Excel

There are atleast two ways to export a SAS dataset to Microsoft Excel.

Proc Export



PROC EXPORT DATA=datasetname
OUTFILE="/usr2/users/student/mkaushik/ names9900.csv"
DBMS=csv
REPLACE;
delimiter=','; */
RUN;

The program (say atlantis) that includes this, should be submitted with the -noterminal option to i.e.:

sas atlantis -noterminal


ODS
ODS html FILE='/usr2/users/student/mkaushik/AIIMS/becker/try2.xls';
PROC PRINT DATA =&dataset NOOBS;
RUN;
ODS html CLOSE;


Use it when a few observations need to be extracted and sent it for review, additional data entry, data confirmation.

56 comments:

Anonymous said...

Do anybody know how can we export a dataset to a perticular sheet in excel if we are running SAS on unix?

Anonymous said...

Genial brief and this mail helped me alot in my college assignement. Thanks you for your information.

Anonymous said...

Hey. I don't normally leave comments, but I just wanted to say thanks for the great information. I have a blog too, though
I don't write as good as you do, but if you want to check it out here it is. Thanks again and have a great day!

Druid Leveling Guide

Anonymous said...

Easily I agree but I dream the brief should have more info then it has.

Alex said...

For me excel files are very important,because every day I work with its. Yesterday something must have happened and some of them were lost. I caught sight of on my PC was an interesting tool,and I decided to use it - repair xlsx. And it didn't fail me. The tool solved all my issues quite fast and without money,I didn't pay anything as far as I remember.

Anonymous said...

Hello, I think your site might be having browser compatibility issues.
When I look at your blog site in Chrome, it looks fine but when
opening in Internet Explorer, it has some overlapping.
I just wanted to give you a quick heads up!
Other then that, excellent blog!

Also visit my site :: office recycling Century City

Anonymous said...

I think that is among the so much important info for me.
And i'm satisfied studying your article. But wanna statement on few basic issues, The site style is great, the articles is really nice : D. Just right job, cheers

My weblog; furniture removals Cape Town

Anonymous said...

Amazing! Its in fact amazing paragraph, I have got much clear idea on
the topic of from this piece of writing.

Check out my site :: Visit here

Anonymous said...

It's appropriate time to make a few plans for the longer term and it's time to be happy.
I've learn this publish and if I could I desire to recommend you few interesting things or suggestions. Maybe you could write next articles referring to this article. I want to read even more issues approximately it!

Feel free to visit my blog post :: birthday cakes and novelty cakes Johannesburg

Anonymous said...

That is a very good tip especially to those fresh to the blogosphere.
Brief but very accurate info… Appreciate your sharing this one.
A must read article!

Feel free to visit my weblog: hotel management systems Gauteng

Anonymous said...

My brother suggested I might like this website. He was
entirely right. This post actually made my day. You cann't imagine simply how much time I had spent for this info! Thanks!

Also visit my weblog :: herbalife food supplements Johannesburg

Anonymous said...

I've read several excellent stuff here. Certainly worth bookmarking for revisiting. I wonder how a lot effort you set to make any such excellent informative website.

Also visit my web-site :: click url

Anonymous said...

Greetings from Carolina! I'm bored to tears at work so I decided to browse your website on my iphone during lunch break. I love the information you provide here and can't wait to take a
look when I get home. I'm shocked at how fast your blog loaded on my mobile .. I'm not even using WIFI, just 3G .
. Anyways, good site!

Anonymous said...

This is a very good tip especially to those new to the blogosphere.
Simple but very precise information… Thank you for sharing this
one. A must read article!

Feel free to surf to my webpage ... Visit website

Anonymous said...

Awesome blog! Is your theme custom made or did you download
it from somewhere? A theme like yours with a few simple adjustements would
really make my blog stand out. Please let me know where you got your
theme. Bless you

Review my webpage ... Website Link

Anonymous said...

I have been exploring for a little for any high-quality
articles or weblog posts in this sort of space
. Exploring in Yahoo I eventually stumbled upon this web site.
Reading this information So i am glad to exhibit that I
have an incredibly just right uncanny feeling I found out exactly what I needed.
I such a lot certainly will make sure to do not fail to remember this site and provides it a look on a continuing basis.



Also visit my web site; corporate branding Gauteng

Anonymous said...

What's up i am kavin, its my first occasion to commenting anyplace, when i read this article i thought i could also create comment due to this brilliant piece of writing.

Take a look at my webpage Visit website

Anonymous said...

Pretty! This was a really wonderful post. Thank you for providing this information.


Also visit my website :: website

Anonymous said...

You're so interesting! I don't think I've truly read through something like this before. So nice to find someone with a few original thoughts on this subject. Really.. thank you for starting this up. This web site is something that's
needed on the web, someone with a little originality!


Stop by my site: cms website design Cape Town

Anonymous said...

I really like your blog.. very nice colors & theme.
Did you create this website yourself or did you hire someone to do
it for you? Plz reply as I'm looking to construct my own blog and would like to know where u got this from. many thanks

Feel free to surf to my page ... party hire Western Cape

Anonymous said...

Magnificent beat ! I wish to apprentice while you amend your site, how could i subscribe for a blog site?
The account aided me a acceptable deal. I had been a little bit acquainted of this your broadcast provided
bright clear concept

Also visit my web blog: business coach Johannesburg personal coaching Johannesburg

Anonymous said...

Pretty section of content. I just stumbled upon your site
and in accession capital to assert that I get in fact enjoyed account your blog posts.
Any way I'll be subscribing to your feeds and even I achievement you access consistently fast.

Visit my homepage: Plumbing Sandton

Anonymous said...

Hey there, You've done an excellent job. I will definitely digg it and personally suggest to my friends. I'm sure they'll be benefited from this website.

Also visit my web-site :: fresh flowers Gauteng

Anonymous said...

Greetings! Quick question that's totally off topic. Do you know how to make your site mobile friendly? My weblog looks weird when viewing from my iphone. I'm trying to find a template or plugin
that might be able to correct this problem.

If you have any recommendations, please share.
With thanks!

My blog: technology support Gauteng

Anonymous said...

Hurrah! At last I got a website from where I be able to actually take valuable data
regarding my study and knowledge.

Feel free to visit my blog post :: visit url

Anonymous said...

Thanks to my father who informed me on the topic of this website, this website is genuinely awesome.


Feel free to surf to my blog post - Infromtion site

Anonymous said...

If some one wishes expert view about running a blog afterward i suggest him/her to go to see this blog, Keep up the nice job.



my homepage portable massage beds Johannesburg suppliers of gym equipment Johannesburg

Anonymous said...

Its like you read my mind! You appear to know so much about this,
like you wrote the book in it or something.
I think that you can do with some pics to drive the message home a bit, but instead of that, this is
fantastic blog. A fantastic read. I will definitely be back.


Look at my page - Visit website

Anonymous said...

Right here is the right blog for anyone who hopes to
understand this topic. You understand a whole lot its almost tough to argue
with you (not that I actually will need to…HaHa).

You certainly put a brand new spin on a subject that's been discussed for decades. Wonderful stuff, just excellent!

My web site ... visit url

Anonymous said...

Howdy! I could have sworn I've been to this blog before but after browsing through some of the post I realized it's new to me.

Nonetheless, I'm definitely happy I found it and I'll be book-marking and checking back often!


Here is my homepage - outdoor patio konkas Gauteng Outdoor patio konkas Gauteng

Anonymous said...

Ridiculous story there. What happened after? Good luck!


Here is my web-site; cosmetic jewelry KwaZulu Natal professional hair care KwaZulu Natal

Anonymous said...

It's awesome in support of me to have a web site, which is useful for my know-how. thanks admin

Feel free to surf to my web page - corporate gifts South Africa

Anonymous said...

I absolutely love your blog and find most of your post's to be exactly I'm looking for.
Would you offer guest writers to write content for you
personally? I wouldn't mind writing a post or elaborating on many of the subjects you write about here. Again, awesome site!

Feel free to surf to my blog post; digital printing south africa

Anonymous said...

Hey there would you mind stating which blog platform you're using? I'm
looking to start my own blog soon but I'm having a tough time selecting between BlogEngine/Wordpress/B2evolution and Drupal. The reason I ask is because your layout seems different then most blogs and I'm looking for something unique.

P.S My apologies for being off-topic but I had to ask!


Feel free to surf to my web-site :: scrap My car leeds

Anonymous said...

I know this if off topic but I'm looking into starting my own blog and was curious what all is required to get set up? I'm assuming having a blog like yours would cost a pretty penny?

I'm not very internet smart so I'm not 100% sure. Any recommendations or advice would be greatly appreciated. Cheers

Feel free to visit my blog post - vertical gardens Cape Town

Anonymous said...

I think the admin of this site is really working hard in favor of his web site, because here every material is quality based material.


Look into my homepage Mattresses Mpumalanga

Anonymous said...

Howdy! Someone in my Myspace group shared this website with us so I came to check it
out. I'm definitely loving the information. I'm bookmarking and will be tweeting this to my
followers! Wonderful blog and amazing design.

My web site :: carbon fibre furniture London

Anonymous said...

Saved as a favorite, I really like your website!

Feel free to surf to my website - Infromtion Site

Anonymous said...

I have been surfing online more than three hours these days,
yet I by no means discovered any fascinating article like yours.
It's pretty worth sufficient for me. Personally, if all webmasters and bloggers made excellent content as you did, the internet will likely be a lot more helpful than ever before.

Look into my blog post - website

Anonymous said...

I was recommended this blog by my cousin. I am now not positive whether this post is
written by way of him as no one else recognize such targeted about my problem.
You are incredible! Thanks!

My web page IT support Johannesburg

Anonymous said...

Thank you for every other great post. The place else may anybody get that kind
of info in such an ideal manner of writing? I've a presentation next week, and I'm
on the search for such information.

Also visit my homepage - photography in Cape Town

Anonymous said...

I visited various blogs however the audio quality for audio songs present at this
web site is genuinely superb.

Also visit my web page ... hd pvr decoder

Anonymous said...

I do not even understand how I ended up right
here, however I believed this put up was good. I do not recognize who
you are but definitely you are going to a well-known blogger should you aren't already. Cheers!

My homepage - financial Advisory services

Anonymous said...

Good day! I could have sworn I've visited this web site before but after browsing through some of the posts I realized it's
new to me. Regardless, I'm certainly pleased I discovered it and I'll be bookmarking it and checking back frequently!


Stop by my blog ... web site designer

Anonymous said...

Greetings! Very useful advice within this post! It is the little changes which will make the largest changes.
Many thanks for sharing!

Here is my web site - first aid kits Johannesburg

Anonymous said...

Ι am regular гeadeг, how aге уou еverybody?
This pieсe оf writing ρostеd аt this ωеbsіte is
genuinelу fastiԁious. pure garcinia cambogia extract capsules - garcinia cambogia
- garcinia max weight-loss supplement jlc-web.osslabs.biz
- garcinia cambogia - full spectrum garcinia cambogia reviews

Ѕtop by mу ωеbpage garcinia cambogia gold amazon

Anonymous said...

Ηi, I dеѕіre to subscribe fοr
thіs blog to obtaіn latest updаtеѕ, therefore where сan
i do it pleаsе assist.

Hеrе iѕ my homepage green coffee extract

Anonymous said...

Ηello aгe using Woгdрress foг уour
blog platfoгm? I'm new to the blog world but I'm
trying to gеt stагtеԁ and creаte my οwn.
Do yоu need anу coding еxpertise to make your own blog?

Any hеlp wοuld be reallу appгeciated!
rippln reviews -
rippln - http://teeurl.com/imiurob547

My weblog ... snipurl.com

Anonymous said...

I think this is one of the most important info for me.
And i am glad reading your article. But should remark
on few general things, The website style is wonderful, the articles is really excellent :
D. Good job, cheers

Feel free to visit my web site: more info

Anonymous said...

Hi there! Quick question that's entirely off topic. Do you know how to make your site mobile friendly? My website looks weird when browsing from my iphone4. I'm trying to find a theme
or plugin that might be able to fix this problem.
If you have any recommendations, please share.
Cheers!

my homepage :: garcinia cambogia review

Anonymous said...

boοkmarked!!, I really like your blog!

Сheсk out my web blog - home based business

Anonymous said...

Τhat is verу attentiοn-grаbbing, Yоu аге an exceѕsiѵelу skillеd blogger.

I've joined your feed and look forward to seeking extra of your fantastic post. Also, I've shаred yοur website in my sоcial networks

Feel free to vіѕit my blog post ... ѕpoгtsbet []

Anonymous said...

Everything is ѵеrу opеn with a precise explаnation οf
the issues. It was definitely infoгmatiѵe.

Your site is useful. Thаnk you fоr shаring!



Look at my page: sportsbet

Anonymous said...

I read this post fully on the topic of the comparison of latest and previous technologies,
it's awesome article.

Feel free to surf to my site :: Garcinia Cambogia Diet

Anonymous said...

That is a goοd tіp esρeсially tο thosе new to the
blogosρhere. Ѕimple but ѵeгу precise information… Τhankѕ for sharing thіs onе.
A must rеad аrtiсle!

Heгe is my web site: cheap car insurance quotes

Unknown said...

cheap replica handbags replica wholesale handbags replica wholesale handbags