I am just coming back to SAS after a few years away. My first project is somewhat complex to write, it seems. Any tips will be appreciated. I want to take a complete data set (key) and save it as many small data sets (depid#) based on one variable's (depid) value. I think the only way to do this is like this (yet exactly this doesn't work - I think it's getting stuck with the array in the proc export file name). data temp; set key; array id[2] (2 4); do i=1 to 2; if depid=id; call execute ('proc export data=temp outfile="C:\My Dept\Research Studies\depid(id" DBMS=CSV REPLACE;PUTNAMES=YES'); end;run;quit; If there are recommendations for different steps (do I need a proc export to get .csv/.xls output files?, is there a procedure already written that does exactly what I need?) please let me know. Regards, Kim
... View more