sas 9.4 SAS DATA SET Saving to Windows Desktop

[miz]

Hello. i have merged three data sets, each of which were imported from a windows desktop C:location using the INFILE statement. How do i export this new (merged) single data set back to the desktop? Thank you!

[Reeza · Accepted solution]

1. Assign a library to the location you'd like the data set to be stored. To assign a library, use the LIBNAME statement to map a libname alias to the desired path on your local PC.

2. Use PROC datasets to move the data set. Or another data step. 

Libname outloc '/folders/myfolders/samples/';
 
proc datasets library=work;
 copy in=work out=outloc;
 select dataset_save;
run;quit;

/* Or this, to copy WORK data to a permanent folder */
data outloc.dataset_save;
 set work.dataset_save;
run;

[miz]

Hello Grand Advisor Reeza.



Would you please provide me further insight for the first step:



1. Assign a library to the location you'd like the data set to be stored.

Is this step to be completed in Windows? If yes, then how?



Still learning, miz

[Cynthia_sas]

Hi:
LIBNAME myperm 'c:\temp\sasdata';

data myperm.class;
set sashelp.class;
run;

This will write a SAS dataset to the folder location: C:\temp\sasdata\class.sas7bdat (which is the Windows file extension for a SAS dataset). Do note that c:\temp\sasdata folder must be already created and you will need to have write access to that folder for the program to work.

cynthia