topic Re: New user attempt to take an online SAS cert course in SAS Studio

New user attempt to take an online SAS cert course

AJ_9 — Mon, 13 Jul 2020 21:32:26 GMT

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.

Re: New user attempt to take an online SAS cert course

ballardw — Mon, 13 Jul 2020 21:38:13 GMT

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>

Re: New user attempt to take an online SAS cert course

AJ_9 — Mon, 13 Jul 2020 21:52:13 GMT

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.

Re: New user attempt to take an online SAS cert course

ketpt42 — Mon, 13 Jul 2020 22:07:31 GMT

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"

Re: New user attempt to take an online SAS cert course

AJ_9 — Mon, 13 Jul 2020 22:22:54 GMT

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!

Re: New user attempt to take an online SAS cert course

Cynthia_sas — Tue, 14 Jul 2020 01:52:33 GMT

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

Re: New user attempt to take an online SAS cert course

Kurt_Bremser — Tue, 14 Jul 2020 09:04:01 GMT

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.