topic Re: Export multiple file in SAS Procedures

Export multiple file

SRohit — Tue, 22 Sep 2015 09:58:44 GMT

Hi,

i have some project where i have to export multiple files in my system,

but i am not able to understand the resolution which are available on community.

Please help me to provide simple Proc to export multiple file which are there in work lib.

Thnks

Rohit Saxena

Re: Export multiple file

RW9 — Tue, 22 Sep 2015 10:09:32 GMT

Your post is not clear. What have you tried? What file format do you want the output to be in? At a rough guess:

data _null_;

set sashelp.vtable (where=(libname="WORK"));

call execute('proc export data=work.'||strip(memname)|| outfile="c:\temp\'||strip(memname)||'.xls replace; run;');

run;

Re: Export multiple file

Reeza — Tue, 22 Sep 2015 16:14:29 GMT

Your question is unclear. What format are you exporting to?
What files are you exporting, is it a single file to multiple files or multiple files to a single file or multiple files to multiple files? Are they all in the same library? Does that library contain any other files that don't need to be exported?