Hi! I am trying to create a data set from an excel file. I created the excel file to match one being used in a free online pre-recorded SAS course. The course is using an older version of SAS - SAS 3.4 and I have 3.8, so I am not sure what I am doing wrong.
Read that error carefully. Is that where you created the Excel file?
It is a best practice to include a complete path when using external references. Otherwise SAS will assume the file is likely in the location SAS executes from. If you are using the SAS University edition you are restricted to locations that the virtual machine sees and if set up with defaults properly means that the paths start with /folders/myfolders/<your specific folders and file names follow here>
Honestly, I don't understand the error message. I uploaded the excel file from my desktop not knowing if I needed to or could create the file in SAS or if SAS would accept the upload. I can download the excel file from SAS so I assume that means its there. My experience using SAS in this detail is below beginner level.
I can barely read the screenshot. Can we see the full import code you're running? Insert it in the reply using the Insert SAS Code button in the edit toolbar.
From what I can read, I think you need to change the datafile= line to:
PROC IMPORT datafile="/folders/myfolders/myprj1/emps_sales.xlsx"
Thank you. That helped fix the problem. The course skipped how to assign / define a physical location and I was able find a help doc that covered that step. Thank you again for your help!
Please do not post screenshots of logs, especially such hard-to-read ones. Unless it is funny for you to annoy us.
Copy/paste the log text into a window opened with this button:
From what my old eyes can make out, it seems you did not use an absolute path to your file. Pathnames to the shared folder in SAS University Edition MUST start with
/folders/myfolders
if you set it up correctly.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.