topic how to export sas data to excel in SAS Procedures

how to export sas data to excel

R_A_G_ — Fri, 18 Nov 2011 17:31:10 GMT

Hello,

I need to export sas datasets to excel for multiple times.

what is the easiest code to use to do so

Thank you

how to export sas data to excel

iusing — Fri, 18 Nov 2011 17:41:01 GMT

File --> Export Data --> Choose your data set --> Choose your data location and format

how to export sas data to excel

iusing — Fri, 18 Nov 2011 17:42:02 GMT

Another method is to use Proc Export

PROC EXPORT Data=(you database)

OUTFILE='(file location)'

REPLACE;

RUN;

Re: how to export sas data to excel

MikeZdeb — Fri, 18 Nov 2011 17:46:07 GMT

hi ... some ideas (requires SAS/Access to PC file formats) ...

* excel file;

libname x 'z:\test.xls';

* file.name of spreadsheet;

data x.class;

set sashelp.class;

run;

libname x clear;

multiple times ...

%macro d2e (file,sheet,dset);

libname x "&file..xls";

data x.&sheet;

set &dset;

run;

libname x clear;

%mend;

* one spreadsheet, one file;

%d2e(z:\class,sheet1,sashelp.class);

* multiple spreadsheets, same file;

%d2e(z:\sashelp,air,sashelp.air);

%d2e(z:\sashelp,heart,sashelp.heart);

how to export sas data to excel

R_A_G_ — Fri, 18 Nov 2011 17:55:07 GMT

When I do this it saves all variables in one column. how can I chnage that?

thanks

how to export sas data to excel

R_A_G_ — Fri, 18 Nov 2011 18:03:14 GMT

when I use this I get this error any idea why?

17 libname it2 'C:\CDM1\4K\MISspecified OUT\1000.xls';

ERROR: The EXCEL engine cannot be found.

ERROR: Error in the LIBNAME statement.

18 data it2.criterion;

19 set sashelp.criterion;

ERROR: File SASHELP.CRITERION.DATA does not exist.

20 run;

ERROR: Libname IT2 is not assigned.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.01 seconds

thanks

how to export sas data to excel

FriedEgg — Fri, 18 Nov 2011 18:18:57 GMT

What OS are you running the SAS jobs on?

how to export sas data to excel

R_A_G_ — Fri, 18 Nov 2011 18:32:57 GMT

It's Windows 7 home premium, it's a 64 bit dual core processor.

I hope this helps

how to export sas data to excel

Tom — Fri, 18 Nov 2011 18:49:27 GMT

If you cannot get SAS to write to excel you could try creating CSV files instead.

Easiest way is a simple data step, but it will not output the variable names.

data _null_;

set have ;

file "want.csv" dsd lrecl=3000;

put (_all_) (:);

run;

how to export sas data to excel

Linlin — Fri, 18 Nov 2011 19:44:20 GMT

do you have excel on your computer?

how to export sas data to excel

R_A_G_ — Sat, 19 Nov 2011 02:05:50 GMT

thanks that did work