I have access to SAS studio (university edition).
Please direct me of how to access an excel file in the c drive of my computer using libname statement and proc import so that I can see all the sheets in the excel file. I used libname xyz xlsx 'path \ excelfilename.xls'; and the proc import syntax as well but couldnt succeed. I want to attempt the certification test and am keen on knowing this .
Hi @Uma_Devi I don't think so you can access local files directly into SAS Studio. But you can manually upload files in your SAS Studio HOME directory "FILE (HOME)"
I have created a folder ("Files") under "Files(Home)" and from there right click to see the "Upload Files.." option.
Once you have files in your home directly, it can easily accessed or used in the proc import procedure.
For example to access Country.xlsx file I can use this path "/home/u61950255/Files/Country.xlsx" in proc import or something..
SAS Studio runs on a server, it cannot access the files on your computer's C: drive. The files must be uploaded to a folder on the SAS Studio server, and then accessed via the server folder name and file name.
See: https://libguides.library.kent.edu/SAS/OnDemandImportData
Hi @Uma_Devi I don't think so you can access local files directly into SAS Studio. But you can manually upload files in your SAS Studio HOME directory "FILE (HOME)"
I have created a folder ("Files") under "Files(Home)" and from there right click to see the "Upload Files.." option.
Once you have files in your home directly, it can easily accessed or used in the proc import procedure.
For example to access Country.xlsx file I can use this path "/home/u61950255/Files/Country.xlsx" in proc import or something..
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.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.