Learning SAS? Welcome to the exclusive online community for all SAS learners.

Problems Importing CSV File into SAS University Edition

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 5
Accepted Solution

Problems Importing CSV File into SAS University Edition

my code and the error are:

 

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
61
62 PROC IMPORT OUT= work.powerball
63 DATAFILE= "/home/davidhmcd/SASUniversityEdition/myfolders/powerball/powerball.csv"
64 DBMS=CSV REPLACE;
65 GETNAMES=YES;
66 DATAROW=2;
67 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/davidhmcd/SASUniversityEdition/myfolders/powerball/powerball.csv is not in the list of accessible paths when
SAS is in the lockdown state.
ERROR: Import unsuccessful. See SAS Log for details.

Accepted Solutions
Solution
‎03-13-2017 03:03 PM
PROC Star
Posts: 7,363

Re: Problems Importing CSV File into SAS University Edition

Your problem is likely how you are specifying your datafile. You used:

63 DATAFILE= "/home/davidhmcd/SASUniversityEdition/myfolders/powerball/powerball.csv"
 
I think you want/need to use: DATAFILE= "/folders/myfolders/powerball/powerball.csv"
 
Art, CEO, AnalystFinder.com

View solution in original post


All Replies
Solution
‎03-13-2017 03:03 PM
PROC Star
Posts: 7,363

Re: Problems Importing CSV File into SAS University Edition

Your problem is likely how you are specifying your datafile. You used:

63 DATAFILE= "/home/davidhmcd/SASUniversityEdition/myfolders/powerball/powerball.csv"
 
I think you want/need to use: DATAFILE= "/folders/myfolders/powerball/powerball.csv"
 
Art, CEO, AnalystFinder.com
Occasional Contributor
Posts: 5

Re: Problems Importing CSV File into SAS University Edition

Thanks, that solved my problem!!!

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 286 views
  • 0 likes
  • 2 in conversation