BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Deepak13
Obsidian | Level 7
proc import datafile= "/folders/myshortcuts/Myfolders/Proc transpose/Sales_Data_1.csv" dbms=csv replace out= sales;
getnames= Yes;
run;
proc print data= sales;
run;

LOG:
 1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 72         
 73         libname sales "/folders/newfolder";
 NOTE: Library SALES does not exist.
 74         data sales;
 
 NOTE: The data set WORK.SALES has 1 observations and 0 variables.
 NOTE: DATA statement used (Total process time):
       real time           0.00 seconds
       cpu time            0.02 seconds
       
 
 75         proc import datafile= "/folders/myshortcuts/Myfolders/Proc transpose/Sales_Data_1.csv" dbms=csv out= sales replace;
 76         getnames= Yes;
 77         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: Physical file does not exist, /folders/myshortcuts/Myfolders/Proc transpose/Sales_Data_1.csv. 
 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           0.06 seconds
       cpu time            0.04 seconds
       
 
 
 78         proc print data= sales;
 ERROR: File WORK.SALES.DATA does not exist.
 79         run;
 
 NOTE: The SAS System stopped processing this step because of errors.
 NOTE: PROCEDURE PRINT used (Total process time):
       real time           0.00 seconds
       cpu time            0.00 seconds
       
 80         
 81         OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 94         
1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User
Post your code as is, and we can help you fix it. I don't want to remove log lines and such.

You have an issue with your libname statement - note the error there. You didn't create the myfolders folder correctly, looks like you used upper case letters and it exactly needs to be 'myfolders'.

Fix the libname as your first step.

View solution in original post

1 REPLY 1
Reeza
Super User
Post your code as is, and we can help you fix it. I don't want to remove log lines and such.

You have an issue with your libname statement - note the error there. You didn't create the myfolders folder correctly, looks like you used upper case letters and it exactly needs to be 'myfolders'.

Fix the libname as your first step.

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 527 views
  • 0 likes
  • 2 in conversation