topic Re: export dataset rows into multiples files .txt in SAS Programming

export dataset rows into multiples files .txt

RZB — Tue, 03 Sep 2019 11:01:48 GMT

hello

i have a dataset for example

PROGRAM DATA

A 21780

A 21781

B 21782

C 21782

C 21783

I need to export the data set into multiple txt files with the variable names from the rows like this:

A_21780.txt

A_21781.txt

B_21782.txt

Only the txt file name, and file can be empty. How i do it?

Thank you.

Re: export dataset rows into multiples files .txt

PeterClemmensen — Tue, 03 Sep 2019 11:03:37 GMT

I don't understand this. Do you want the TXT files to be empty? If not, what exactly do you want in them?

Re: export dataset rows into multiples files .txt

Kurt_Bremser — Tue, 03 Sep 2019 11:16:23 GMT

If data is present, the respective output file will not be empty, if no data for a given program/number combination is present, then that file won't be created.

Re: export dataset rows into multiples files .txt

Ksharp — Tue, 03 Sep 2019 12:10:20 GMT

data have;
input PROGRAM  $  DATA;
cards;
 A                   21780
A                    21781
B                    21782
C                    21782
C                     21783
;

data _null_;
 set have;
 filename=cats('c:\temp\',catx('_',program,data),'.txt');
 file dummy filevar=filename;
 put (_all_) (:);
run;

Re: export dataset rows into multiples files .txt

RZB — Tue, 03 Sep 2019 13:03:32 GMT

thank you, that works!

Re: export dataset rows into multiples files .txt

RZB — Tue, 03 Sep 2019 13:07:16 GMT

many thanks,

Yes , data if present but with

put (_all_) (:); instruction then , the files are exported empty.

Re: export dataset rows into multiples files .txt

RZB — Tue, 03 Sep 2019 13:11:14 GMT

Hello,

Yes, i only wants the files empty because after splitting them like user Ksharp says , i posteriorly read them in the path for using it in a step of a SAS program that requires this.

thanks.