BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
SASnovice23
Calcite | Level 5

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?

Snap11.png

1 ACCEPTED SOLUTION

Accepted Solutions
SASKiwi
PROC Star
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";

View solution in original post

1 REPLY 1
SASKiwi
PROC Star
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";

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 820 views
  • 0 likes
  • 2 in conversation