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;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.