06-26-2014 03:40 PM
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;
43 proc import datafile= '/folders/myshortcuts/MyFolders/Scores.csv' out= class dbms= csv replace;
43 ! getnames= yes
43 ! ;
NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to
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
47 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
Any help appreciated :smileyconfused:
06-27-2014 10:34 AM
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. :/
06-26-2014 03:45 PM
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.