topic How to manage the output data well in SAS EG in SAS Programming

How to manage the output data well in SAS EG

ResoluteCarbon — Fri, 29 Jan 2021 05:55:27 GMT

Hi everyone,

I am new to SAS.

I mainly use SAS EG for my work because I am a novice to SAS. I am wondering where SAS stores the output after you ran code?

Apart from that, normally when running SAS, I want to export the output and afterwards, I will import such output to other SAS code to make sure that my code is not too long.

Traditionally, I use the export button and it leads me to save the file under sas7bdat or csv, or mdb, or txt format.

So, I am not sure how to write the code to export this file under sas7bdat format and the code to import again rather than just export and import manually by using buttons

Or, I really appreciate if you can share any other solution from your experience by importing and exporting SAS output.

Cheers.

Re: How to manage the output data well in SAS EG

Phil_NZ — Fri, 29 Jan 2021 07:16:19 GMT

Export

libname myfolder 'path to folder';
proc copy in=work out=myfolder;
select export_dataset;
run;
quit;

Check export dataset

proc print data=myfolder.export_dataset;
run;

Import the export_dataset

Libname input 'path to folder';

data want;

set input.export_dataset;

run;

Re: How to manage the output data well in SAS EG

Kurt_Bremser — Fri, 29 Jan 2021 08:24:10 GMT

SAS datasets are already stored in files with a .sas7bdat extension, so there is no need to export. Just copy the files to the location where you want them.

Exporting is necessary when you want to create "external files", like csv or spreadsheets.

Text files (like csv) are written with a data step, Excel files can be created with PROC EXPORT or LIBNAME XLSX.

Since your SAS session most probably runs on a remote server, you need to download the exported files, this is done with the Copy Files task in EG.