library does not exist

[s_m]

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.

[Yavuz]

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

[s_m]

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

[Reeza · Accepted solution]

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

[Reeza]

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. 

[s_m]

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.

.

[Reeza]

Did the solution suggested not work?

[s_m]

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

[kaverisonu1]

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.

[s_m]

thanks a lot Kaverisonu for your help.