Importing excel file into SAS studio(university edition)

[Uma_Devi]

 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 .

[PaigeMiller]

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

[MayurJadhav · Accepted solution]

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..

[Uma_Devi]

Thanks a lot. Yes I am now able to do what you mentioned after following
the steps.