topic Re: libname statement issue in SAS Programming

libname statement issue

MeghnaRoy9 — Thu, 22 Aug 2019 06:34:45 GMT

Hey! New SAS user here! I would like to know where I'm going wrong with the following code.

So, I ran the code given below and the result was saved in My Libraries:

LIBNAME CLS "/folders/myshortcuts/study1";
RUN;

Post this, when I'm trying to run the given code, a message prompts stating -

ERROR: File WORK.CLUSTER_DATA.DATA does not exist.

ODS HTML FILE = "/folders/myshortcuts/study1/CLUSTER_DATA.XLS";
PROC MEANS DATA = CLUSTER_DATA Nmiss;
RUN;
ODS HTML CLOSE;

Please help me understand where I'm wrong and what should be done.
The data has been attached below.
Thank You!

Re: libname statement issue

Shmuel — Thu, 22 Aug 2019 06:58:38 GMT

You are probably using SAS University Edition.

The path "/folders/myshortcuts/..." was changed in last version to "/folders/myfolders/... ".

Re: libname statement issue

MeghnaRoy9 — Thu, 22 Aug 2019 07:02:11 GMT

Thank you for the reply.

when I tried to use the path with "my folders" it says that the library does not exist. the path works when I use "my shortcuts".

the problem arises when I try to export my data as an excel file.

Re: libname statement issue

andreas_lds — Thu, 22 Aug 2019 07:11:57 GMT

You haven't specified the libref in proc means, so sas tries to find cluster_data in work. Using cls.cluster_date in proc means should solve the problem.

Two things to note: you don't need run after libname and you should not write code in upcase letters, using lower case letters increases readability.

Re: libname statement issue

MeghnaRoy9 — Thu, 22 Aug 2019 07:37:19 GMT

Thank you so much! it works now 🙂