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
... View more