Move the dataset from default WORK library to another library

[SASnovice23]

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";

or

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?

[SASKiwi · Accepted solution]

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";