topic How to export sas output to physical file from WORK library in SAS Programming

How to export sas output to physical file from WORK library

Phil_NZ — Mon, 15 Feb 2021 22:44:09 GMT

Hi everyone,

After running code, I have a library WORK with 64 outputs like the picture below:

And normally I export to physical file for one file is as below:

libname myfolder 'C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\2Cfiltering';
proc copy in=work out=myfolder;
select argentina_merge2;
run;
quit;

Could you please help me to generate code to export all files from library work to physical files as above? I appreciate any other alternative way in doing so as well.

I want to "export" because I do not want to write a so-called "long" code because it is really a mess for me to debug afterward.

Warm regards.

P/S: I also added the output of content of library "WORK"

And when running PROC CONTENTS, I saw some strange memname that I do not know where they come from, so be careful about them

Re: How to export sas output to physical file from WORK library

ChrisNZ — Mon, 15 Feb 2021 23:19:39 GMT

> Could you please help me to generate code to export all files from library work to physical files as above?

The work files are physical files, so this question is oddly worded.

Look at the proc copy statements, especially exclude and select.

Or maybe copy all, and delete the unneeded ones, like _PRODSAVAIL.

Re: How to export sas output to physical file from WORK library

Phil_NZ — Mon, 15 Feb 2021 23:23:38 GMT

Hi @ChrisNZ

I mean, how to macronize or generalize the code

libname myfolder 'C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\2Cfiltering';
proc copy in=work out=myfolder;
select argentina_merge2;
run;
quit;

For all files in the library work (the code above just for only one output file in the library work)

Warm regards.

Re: How to export sas output to physical file from WORK library

ChrisNZ — Mon, 15 Feb 2021 23:26:15 GMT

R e a d t h e d o c u m e n t a t i o n.

In this case, remove the select statement.