DATA Step, Macro, Functions and more

Export multiple data-sets to multiple excel files

Reply
New Contributor
Posts: 2

Export multiple data-sets to multiple excel files

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

Super User
Posts: 23,296

Re: Export multiple data-sets to multiple excel files

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?
New Contributor
Posts: 2

Re: Export multiple data-sets to multiple excel files

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. 

Frequent Contributor
Posts: 84

Re: Export multiple data-sets to multiple excel files

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;

 

 

--------------
blog: papersandprograms.com
Ask a Question
Discussion stats
  • 3 replies
  • 109 views
  • 3 likes
  • 3 in conversation