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
Opal | Level 21
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
Opal | Level 21
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";

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

From SAS Users blog
Want more? Visit our blog for more articles like these.
5 Steps to Your First Analytics Project Using SAS

For SAS newbies, this video is a great way to get started. James Harroun walks through the process using SAS Studio for SAS OnDemand for Academics, but the same steps apply to any analytics project.

Find more tutorials on the SAS Users YouTube channel.

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