topic Re: sas programming in SAS Programming

sas programming

nayab_shaik — Tue, 25 Jun 2019 06:38:50 GMT

Hi Team,

i need one help

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

Advance Thanks

Re: sas programming

Ivan555 — Tue, 25 Jun 2019 06:52:10 GMT

Hello!

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

Re: sas programming

nayab_shaik — Tue, 25 Jun 2019 06:54:18 GMT

in text format

Re: sas programming

Ivan555 — Tue, 25 Jun 2019 07:05:46 GMT

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.

Re: sas programming

nayab_shaik — Tue, 25 Jun 2019 07:20:44 GMT

by using data step file name statment

Re: sas programming

Kurt_Bremser — Tue, 25 Jun 2019 08:04:17 GMT

So you want to export multiple datasets to external files?

Do the datasets have identical structure?

Re: sas programming

Ksharp — Tue, 25 Jun 2019 13:20:00 GMT

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;