Proc Import Error

[kaushik_pawar15]

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;

72

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

77

78 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

91

[Jagadishkatam]

Could you please make sure the path mentioned is correct

[Reeza]

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.

[kaushik_pawar15]

Hi,


I am using SAS on Demand.


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

[Reeza]

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.

[kaushik_pawar15]

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.

[Tom]

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.