Import excel using SAS on demand (cloud) and snippets

Noleen0 — Tue, 05 Mar 2019 07:55:36 GMT

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

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!

Re: Import excel using SAS on demand (cloud) and snippets

Kurt_Bremser — Tue, 05 Mar 2019 08:57:52 GMT

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.

Re: Import excel using SAS on demand (cloud) and snippets

Noleen0 — Tue, 05 Mar 2019 13:52:00 GMT

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.

topic Import excel using SAS on demand (cloud) and snippets in SAS Studio

Import excel using SAS on demand (cloud) and snippets

Re: Import excel using SAS on demand (cloud) and snippets

Re: Import excel using SAS on demand (cloud) and snippets