topic Re: Proc export to Excel in SAS Programming

Proc export to Excel

NJGIRL — Wed, 31 May 2017 20:27:46 GMT

Dear All,

Can anyone provide basic code to transfer a SAS dataset in to an Excel spreadsheet?

Thank! Jill1

Re: Proc export to Excel

PaigeMiller — Wed, 31 May 2017 20:30:28 GMT

The SAS documentation ought to be your first stop

http://documentation.sas.com/?cdcId=pgmmvacdc&cdcVersion=9.4&docsetId=acpcref&docsetTarget=n0msy4hy1so0ren1acm90iijxn8j.htm&locale=en#n0ddvwsc0s7jqdn1p4yccufpgq66

Re: Proc export to Excel

Reeza — Wed, 31 May 2017 21:34:35 GMT

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/

Re: Proc export to Excel

Sven111 — Wed, 31 May 2017 22:13:15 GMT

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;

Re: Proc export to Excel

NJGIRL — Thu, 01 Jun 2017 14:23:16 GMT

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

Re: Proc export to Excel

NJGIRL — Thu, 01 Jun 2017 14:31:51 GMT

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

Re: Proc export to Excel

PaigeMiller — Fri, 02 Jun 2017 13:25:38 GMT

@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.

Re: Proc export to Excel

Reeza — Fri, 02 Jun 2017 13:49:17 GMT

@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.