topic Re: import and export sas dataset in SAS Programming

import and export sas dataset

tparvaiz — Wed, 10 May 2017 22:52:18 GMT

How to save SAS Dataset in a c drive and acess it.

A) save dataset

here is something I've used to save excel file. how will it work for sas dataset

%let YYYYMM = 201703;

data _null_;
file cmds;
put "[save.as(%bquote("C:\Program Files\output\DataSet &YYYYMM..xlsx"))]";
put '[CLOSE()]';
run;

B) import dataset

can you please advise how to import dataset in a sas program

Thanks

Re: import and export sas dataset

Kurt_Bremser — Thu, 11 May 2017 07:23:22 GMT

A SAS dataset is stored in a library; a library definition (libname statement) connects a logical SAS library name with a physical path to an existing directory.

You do not "import" a SAS dataset into SAS. Datasets are read with proc sql ("from") or with the set or merge statements in a data step, or by naming them in the data= option in a procedure statement.

There are several ways to move SAS data to other applications; which one should be used has to be determined according to the external application and what exactly (just data, or whole reports) needs to be exported.