topic Export to Excel in SAS Enterprise Guide

Export to Excel

Lopes — Fri, 14 Feb 2014 18:42:36 GMT

Good afternoon,

I need to export from SAS to Excel.

I tried with the proc export but it changed the format and it did not show the column names.

proc export

data=WORK.xxx

dbms=xls

outfile="xxx.xls"

replace;

run;

How can I export?

Thanks!

Re: Export to Excel

Doc_Duke — Fri, 14 Feb 2014 19:56:50 GMT

since you are in the EGuide GUI, you can just export using file --> export.

Re: Export to Excel

overmar — Sat, 15 Feb 2014 15:42:14 GMT

Insert "label" into the code before replace, this will export the labelled column names from SAS into excel. Mind you if you put labels onto the columns in SAS ie rather than UID you have the label "Unique ID variable", "Unique ID variable" is what will appear in Excel.

proc export

data=WORK.xxx

dbms=xls

outfile="xxx.xls"

label

replace;

run;

If you have variable labels and wanted the SAS variable name to actually be output you could put this before your proc export statement

proc datasets lib=work memtype=data;

modify xxx;

attrib _all_ label=' ';

run;

Hope this helps.

Re: Export to Excel

NK — Sun, 16 Feb 2014 04:19:38 GMT

export it as in cvs format and then to excel