I am new to SAS. I have been trying to import a CSV file but I have been unable to do so. This is what it had in the log on my last attempt:
1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
42 ;
43 proc import datafile= '/folders/myshortcuts/MyFolders/Scores.csv' out= class dbms= csv replace;
43 ! getnames= yes
43 ! ;
44 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 /folders/myshortcuts/MyFolders/Scores.csv is invalid because it 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.39 seconds
cpu time 0.22 seconds
45
46 ;
47 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
57 ;
Any help appreciated :smileyconfused:
Are you using SAS University Edition?
If so, did you add the path to the Shared VM as specified in the instructions?
Yes I am using the University Edition. I do not believe I did that. Could you direct me to which instructions you are referring to? Thank you.
So I have the csv file in the work folder now but it says that it cannot be opened because the table does not contain any columns. I have tried every code people have tried in the posts and nothing seems to work. 😕
Post your code and error
This sounds like you are using a server version of SAS and the SERVER can't see the path as given, or the address is relative and the base execution location of SAS doesn't find a /folders within that scope. Datafiles option really should use a fully qualified path in most cases.
Yes I am using the server version. I am very confused as to where my csv file should be.
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!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.