topic Re: Move the dataset from default WORK library to another library in New SAS User

Move the dataset from default WORK library to another library

SASnovice23 — Mon, 27 Mar 2023 23:13:28 GMT

I'm having trouble moving a dataset I generated called 'hholdincome' assigned in a default WORK library to another library in the SAS main server (SECTION). When I type the following codes:

libname SECTION "work.hholdincome";

proc copy in=work out=section;
select HHoldIncome;
run;

I get the error that the library SECTION does not exist, which is strange because it does exist. Is there another way where I can possibly relocate the dataset?

Re: Move the dataset from default WORK library to another library

SASKiwi — Mon, 27 Mar 2023 23:37:54 GMT

libname SECTION "work.hholdincome";

The above LIBNAME is incorrect. What does your SAS log report when you submit it? This is what I get:

28         libname SECTION "work.hholdincome";
NOTE: Library SECTION does not exist.

Your LIBNAME should point to a folder, not to a dataset name - here is an example for SAS on Windows:

libname SECTION "c:\MyFolder";