Dear All,
Can anyone provide basic code to transfer a SAS dataset in to an Excel spreadsheet?
Thank! Jill1
The SAS documentation ought to be your first stop
@jill1 wrote:
I guess I sorta say 'thanks for your help' . I guess I was more looking for the actual code, not a path leading to sas documentation. not ungrateful, just for sake of time.. I only had 1/2 hour to do this for very demanding boss and was looking for quick help.
but thanks anyway. Jill 1
And if you had clicked on the link and scroll up or down (not an unreasonable expectation), you'd see example code right there on your screen.
@jill1 wrote:
I guess I sorta say 'thanks for your help' . I guess I was more looking for the actual code, not a path leading to sas documentation. not ungrateful, just for sake of time.. I only had 1/2 hour to do this for very demanding boss and was looking for quick help.
but thanks anyway. Jill 1
@NJGIRL I guess sorta your welcome. Those aren't documentation they're blog posts designed to exactly answer your question. Should we type out the exact same thing every time someone asks a basic question that google can answer? Directing you to high quality answers also takes time - in fact more than it would have taken to type out the answer. You'll note there's not one way - and given what you'd stated we don't know anything about your set up and which may have been the best solution.
Google works 😉
http://blogs.sas.com/content/sasdummy/2012/02/11/export-excel-methods/
Specifically in your case most likely:
http://blogs.sas.com/content/sasdummy/2012/01/25/export-to-excel-got-easier/
I usually use this, although there are lots of ways to do this, each with its own pros and cons, some of the links provided by @Reeza and @PaigeMiller should help with understanding them.
PROC EXPORT DATA=lib_Out.DataPull
outfile = "/home/username/output_file.xlsx"
dbms = xlsx;
sheet = "DataPull";
RUN;
Thank you. I appreciate you sending the actual code my way! makes it alot easier/quicker than following the links people send. plus, I had 15 minutes to do it so this was VERY HELPFUL.
thanks! Jill1
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.