topic Re: Create seperate file for each Name (ID) in SAS Programming

Create seperate file for each Name (ID)

hhchenfx — Sun, 07 Sep 2014 21:16:54 GMT

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

;

Re: Create seperate file for each Name (ID)

Reeza — Sun, 07 Sep 2014 21:55:41 GMT

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.

http://www.lexjansen.com/mwsug/1999/paper03.pdf

Re: Create seperate file for each Name (ID)

Ksharp — Mon, 08 Sep 2014 13:18:53 GMT

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

Re: Create seperate file for each Name (ID)

hhchenfx — Mon, 08 Sep 2014 17:05:29 GMT

Thank you Xia and Reeza for helping me.

HHC