New user attempt to take an online SAS cert course

[AJ_9]

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.

[ballardw]

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>

[AJ_9]

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. 

[ketpt42]

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"

[AJ_9]

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!

[Cynthia_sas]

Hi:
In SAS Studio, if you can find the file in the Server Files and Folders pane, you can ALWAYS get the correct path by doing a right-click on the file name and choosing Properties. The Location field in the Properties window will ALWAYS show you the correct path to use for a file like this.
Cynthia

[Kurt_Bremser]

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.