Hi Everyone,
I have a data with variable nameID as below.
I want to create separate file for each name.
Then export each file into CSV.
There are thousand names and I haven't found a way to do it yet.
Any help is very much appreciated.
HHC
data have;
input name_ID var1 var2;
datalines;
1111 2
111 3 6
111 6 9
555 2 2
555 4 5
555 5 4
563 2 2
563 1 1
;
data have; input name_ID var1 var2; datalines; 1111 2 111 3 6 111 6 9 555 2 2 555 4 5 555 5 4 563 2 2 563 1 1 ; proc sort data=have;by name_ID; run; data _null_; set have; fname=cats('c:\temp\File_',name_ID,'.csv'); file dummy filevar=fname dsd; put (_all_) (:); run;
Xia Keshan
Message was edited by: xia keshan
Write the code manually for one file, or use proc import and get the code.
Then change it to use the FILEVAR option in a data _null_ step.
data have; input name_ID var1 var2; datalines; 1111 2 111 3 6 111 6 9 555 2 2 555 4 5 555 5 4 563 2 2 563 1 1 ; proc sort data=have;by name_ID; run; data _null_; set have; fname=cats('c:\temp\File_',name_ID,'.csv'); file dummy filevar=fname dsd; put (_all_) (:); run;
Xia Keshan
Message was edited by: xia keshan
Thank you Xia and Reeza for helping me.
HHC
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.