topic Re: library does not exist in SAS Programming

library does not exist

s_m — Fri, 31 Mar 2017 05:07:32 GMT

libname libsas "folders/myshortcuts/s2/";
data libsas.account;
account_id = 00001;
firtname ='John';
lastname ='Liu';
run;

ERROR: Library LIBSAS does not exist.

Please help me with code,I am a beginner and this library thing is becoming a trouble for me.

I have attached the sceenshot of log as well.

Re: library does not exist

Yavuz — Fri, 31 Mar 2017 05:19:45 GMT

1.) Please write full path. Like
Libname mylib "D:\mydata";

2.) If account_id is string it must be like "00001"

3.) Are you working on Sas base or sas EG,
If sas Eg server maybe you have an authorization problem

Re: library does not exist

Reeza — Fri, 31 Mar 2017 05:40:01 GMT

Are you using an English browser?

I think something may be wrong earlier and carrying over.

Can you start a new session, restart your VM and run only the code shown.

Re: library does not exist

s_m — Fri, 31 Mar 2017 05:45:00 GMT

thanks for your help

but actually i have defined s2 in shared folder so it is coming under my shortcuts in sas studio so i can refer it as /folders/myshortcuts/s2.So please help me out what went wrong

Re: library does not exist

Reeza — Fri, 31 Mar 2017 05:51:24 GMT

The path is incorrect, the / in front of folders is missing.

Re: library does not exist

s_m — Fri, 31 Mar 2017 06:22:54 GMT

I am using SAS Studio (SAS University Edition)

I started the new session but error is still the same.

I am unable to assign a libref through libname statement.

libname libsas "/folders/myshortcuts/s2/";
data work.out;
set libsas.abc;

run;

ERROR:

File LIBSAS.ABC.DATA does not exist

abc.xlsx data is physical present under S2 and is visible in myshorts in sas studio.Please refe the screenshot attached.

Please help me ith this.

Re: library does not exist

Reeza — Fri, 31 Mar 2017 06:08:25 GMT

Did the solution suggested not work?

Re: library does not exist

s_m — Fri, 31 Mar 2017 06:25:12 GMT

Thanks Reeza it worked but I am facing another issue which I have already described in previous reply.Please help me on that.

Thanks in advance

Re: library does not exist

kaverisonu1 — Fri, 31 Mar 2017 07:34:55 GMT

You cannot use excel file directly as a dataset. You need to first import teh excel file using proc import as below.

proc import datafile= "<path>" out=<dataset name in sas>

sheet ="<sheetname if specific sheet needs to be imported>" ;

run;

post this you acn use your dataset.

Another way would be using DDE in sas.

Re: library does not exist

s_m — Fri, 31 Mar 2017 18:32:25 GMT

thanks a lot Kaverisonu for your help.