topic Re: Proc Import Error in SAS Programming

Proc Import Error

kaushik_pawar15 — Sat, 27 Oct 2018 08:31:29 GMT

Hi,

I am trying import a .csv file using proc import in SAS Studio but getting an error message.

This is the code i am using:

proc import datafile='/home/kaushik/Documents/Kaushik/Data Science/Jigsaw/Credit Card - SAS Functions.csv'
out= Credit_card
dbms= csv;
run;

Following is the error message:

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

73 proc import datafile='/home/kaushik/Documents/Kaushik/Data Science/Jigsaw/Credit Card - SAS Functions.csv'

74 out= Credit_card

75 dbms= csv;

76 run;

NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to

WORK.PARMS.PARMS.SLIST.

ERROR: The path /home/kaushik/Documents/Kaushik/Data Science/Jigsaw/Credit Card - SAS Functions.csv is not in the list of

accessible paths when SAS is in the lockdown state.

ERROR: Import unsuccessful. See SAS Log for details.

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

NOTE: PROCEDURE IMPORT used (Total process time):

real time 1.71 seconds

cpu time 0.31 seconds

78 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

Re: Proc Import Error

Jagadishkatam — Sat, 27 Oct 2018 09:33:39 GMT

Could you please make sure the path mentioned is correct

Re: Proc Import Error

Reeza — Sat, 27 Oct 2018 15:03:40 GMT

Are you using SAS UE or SAS Academics on Demand. The easiest method to find the correct file path is to navigate to the path using Servers Files & Folders, find the file, right click and select properties and copy the path from there.

Re: Proc Import Error

kaushik_pawar15 — Sun, 28 Oct 2018 13:22:15 GMT

Hi,

I am using SAS on Demand.

The file path is correct. i have checked it several times.

Re: Proc Import Error

Reeza — Sun, 28 Oct 2018 20:06:34 GMT

Can you please show a screenshot from SAS AoD with the file, from Server Files and Folders?
Note that the path can also be case sensitive since its Unix though I thought they’d removed that issue.

Re: Proc Import Error

Tom — Mon, 29 Oct 2018 02:30:40 GMT

The error message is pretty clear.

SAS is limiting which directories you are allowed to read from and the one you tried to use is not on the list.

Re: Proc Import Error

kaushik_pawar15 — Mon, 29 Oct 2018 05:47:15 GMT

Hi Reeza,

I have identified the error. Since I am using SAS on demand, I have to upload the files in sas first and then use the path from there.

Thank you for ur help.