Import excel using SAS on demand (cloud) and snippets

[Noleen0]

Hello. I am new to using SAS in this way. I have watched the video for the university version. SAS on demand (SAS studio) does not have the file-import option. I am trying to use the snippets. This gives me a few lines of code. I am battling with the syntax for the code, specifically the path for the import statement and the specs for the out statement. I have created a folder on the left panel. I have also created a shared folder on my laptop. I was discussing this online with support, but cannot even find that chat box now.

Here is a sample of my latest:

71 /** Import an XLSX file. **/

72

73 PROC IMPORT DATAFILE="/folders/home/noleenwork0/mydata/Edwinsas.xlsx"

74 OUT=mydata.edwinsas

75 DBMS=XLSX

76 REPLACE;

77 RUN;

ERROR: Physical file does not exist, /pbr/biconfig/940/Lev1/SASApp//folders/home/noleenwork0/mydata//Edwinsas.

NOTE: The SAS System stopped processing this step because of errors.

I have called my data file mydata and have also called the library mydata. My student's spreadsheet is Edwinsas. This particular run was done with (here) and without the /folders at the beginning

Thanks!

[Kurt_Bremser]

Please re-post the log, using the {i} button. I suspect you have a hidden character in your DATAFILE string that prevents the path from being recognized as absolute.

Also include the log of the libname statement you use for library mydata.

[Noleen0]

Thank you. I came right with the help chat eventually, and a lot of
fidgeting! Something may well have been hidden because I reloaded and reran
everything.