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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.