01-03-2017 05:02 PM - last edited on 01-03-2017 05:05 PM by Reeza
I am using sas studio online. i am not able to import or use excel file that save on my c drive. i typed:
Libname test1 excel ‘C:\Users\homa6_000\Documents\SAS\test\test1.excel’;
01-03-2017 05:09 PM
See the instructions here
In general, move the file to the shared folder you set up during installation and reference using the Unix notation, as this is running off a Unix server. If you're using AWS or Academics on Demand then you need to upload the file to their server. Note that the path/directory is case sensitive.
Then reference as
libname myfile xlsx '/folders/myfolders/myexcel.xlsx';
I've moved your question to the Analytics U forum. I suggest searching here for further information and help.
01-03-2017 05:10 PM
If you are working on a remote server, the SAS process can only access files that are located in the server's filesystem.
Use the import functions of SAS Studio, as they provide the only connection between both computers.
Or, if you have SSH access to the server, use a tool like WinSCP to upload the file.
Also always provide the log if you need help with SAS code.