CSV files are trivial to write with a SAS datastep. If you ignore the header record you just need:
data _null_;
set MYDATA ;
file MYFILE dsd dlm=',' lrecl=32000 ;
put (_all_) (:) ;
run;
To make multiple files you can use the FILEVAR option on the FILE statement to control the name of the target file with data step logic.
You can build macro variables with the list of variable names from the metadata (SASHELP.VCOLUMN or use PROC CONTENTS) to drive the put statement. You can also build a macro variable with valid code to put the variable names (or labels) as the header.
You can use a double DOW loop to count how many records you have per by group before you start the group so that you can decide if you should start a new file before the current BY value.
So something like this: (UNTESTED)
%let varlist=A B C;
%let titles="A" ',' "B" ',' "C" ;
%let maxobs=10000 ;
data _null_;
do nobs=1 by 1 until (last.group);
set mydata ;
by group ;
end;
do until (last.group) ;
set mydata ;
by group ;
if nrecs=0 or (nrecs + nobs > &maxobs) then do;
filenumber+1;
nrecs=0;
filename = cats('myfile',filenumber,'.csv');
end;
file dummy filevar=filename dsd dlm=',' lrecl=32000 ;
nrecs+1;
if nrecs=1 then put &titles;
put &varlist ;
end;
run;
Click image to register for webinar
