03-31-2017 01:07 AM
libname libsas "folders/myshortcuts/s2/";
account_id = 00001;
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.
03-31-2017 01:19 AM
03-31-2017 01:45 AM
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
03-31-2017 01:40 AM
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.
03-31-2017 01:58 AM - edited 03-31-2017 02:22 AM
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/";
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.
03-31-2017 03:34 AM
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>" ;
post this you acn use your dataset.
Another way would be using DDE in sas.
Need further help from the community? Please ask a new question.