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
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'.
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!