topic Re: Export multiple data-sets to multiple excel files in SAS Programming

Export multiple data-sets to multiple excel files

Ella2525 — Fri, 08 Jun 2018 17:01:05 GMT

Hello,

I have a large data-set that I had to split into 360 smaller sets by value (byval), I need to export the smaller sets into individuals excel files .csv and im having trouble coming up with the proc export. Here is what i'm doing:

Proc sort data = HQ.private; by hospital_system; run;

%macro break(byval);

data &byval;

set HQ.private(where=(hospital_system="&byval"));

run;

%mend;

Data _Null_;

set HQ.private;

by hospital_system;

if first.hospital_system then

call execute(%nrstr('%break('||trim(hospital_system)||')'));

run;

proc export

DATA=work.pih

DBMS=EXCEL

outfile="C:\Users\ekala1\Documents\HQAF\pih.xls"

replace;

run;

When I run my proc export, it does not execute. Any help or advice would be greatly appreciated.

Thank you,

Ella

Re: Export multiple data-sets to multiple excel files

Reeza — Fri, 08 Jun 2018 17:08:38 GMT

You say Excel CSV and then use DBMS=Excel and xls. Can you confirm exactly what is your desired file type? Is there any error messaged in your log? What does 'not execute' mean?

Re: Export multiple data-sets to multiple excel files

pau13rown — Fri, 08 Jun 2018 17:14:05 GMT

myabe im stupid but i dont see where the temp data set pih is created. Why not:

%macro break(byval);

data &byval;

set HQ.private(where=(hospital_system="&byval"));

run;

proc export

DATA=&byvar

DBMS=EXCEL

outfile="C:\Users\ekala1\Documents\HQAF\&byvar.xls"

replace;

run;

%mend;

Re: Export multiple data-sets to multiple excel files

Ella2525 — Fri, 08 Jun 2018 19:08:00 GMT

Hello Reeza, either will work xls or csv; also I am not getting any error messages my log. When i look in the designated folder the files are not there.