topic Re: Importing excel file into SAS studio(university edition) in SAS Programming

Importing excel file into SAS studio(university edition)

Uma_Devi — Wed, 10 May 2023 14:27:23 GMT

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 .

Re: Importing excel file into SAS studio(university edition)

PaigeMiller — Wed, 10 May 2023 14:33:16 GMT

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

Re: Importing excel file into SAS studio(university edition)

MayurJadhav — Wed, 10 May 2023 14:41:06 GMT

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

Re: Importing excel file into SAS studio(university edition)

Uma_Devi — Wed, 10 May 2023 16:21:09 GMT

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