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!
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;
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;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.