topic sas 9.4 SAS DATA SET Saving to Windows Desktop in SAS Programming

sas 9.4 SAS DATA SET Saving to Windows Desktop

miz — Tue, 27 Dec 2016 19:24:01 GMT

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!

Re: sas 9.4 SAS DATA SET Saving to Windows Desktop

Reeza — Thu, 10 Mar 2022 18:18:17 GMT

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;

Re: sas 9.4 SAS DATA SET Saving to Windows Desktop

miz — Wed, 28 Dec 2016 19:57:19 GMT

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

Re: sas 9.4 SAS DATA SET Saving to Windows Desktop

Cynthia_sas — Wed, 28 Dec 2016 21:32:35 GMT

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