sas programming

[nayab_shaik]

Hi Team,

i need one help

How to export multiple files in sas by using file name statement

Advance Thanks 

[Ivan555]

Hello!

In which format do you want to export data from SAS? In .xlsx, in .sas7bdat, in .csv, others?

[nayab_shaik]

in text format

[Ivan555]

Have a look, thats not what you need?

proc sql; create table t1 as select * from sashelp.air; quit;

%let path ="/home/sasserver/sasuser/files/test.txt";  /*input your path*/

proc export data=t1
outfile=&path.
label dmbs=tab replace;
putnames=yes;
%run;

If you need other formats it is also possible.

[nayab_shaik]

by using data step file name statment

[Kurt_Bremser]

So you want to export multiple datasets to external files?

Do the datasets have identical structure?

[Ksharp]

proc sort data=sashelp.class out=have;
by sex;
run;


data _null_;
 set have;
 fvar=cats('c:\temp\',sex,'.txt');
 file dummy filevar=fvar dsd mod;
 put (_all_) (:);
run;