Hello, I need to do a program for an assignment and I keep on getting the same error every time
ERROR: Output SAS data set must be provided.
I do not know exactly what they want me to fix. I just started all of this this week and I honestly have no idea what I am doing. Here is what I have so far
LIBNAME EXT "\USERS\NTORRES3\DOWNLOADS";
RUN;
PROC IMPORT DATAFILE="c:\USERS\NTORRES3\DOWNLOADS\EXT.H188A.CSV";
DBMS=SSP
OUT=EXT.H188A.SSP_IMPORT;
GETNAMES=YES;
GUESSINGROWS=MAX;
REPLACE;
run;
If anyone could help me and actually explain what is wrong I would appreciate it.
You have a erroneous semicolon in the proc import line that ends the statement prematurely.
Now it says
ERROR: Invalid data set name EXT.H188A.SSP_IMPORT.
PROC IMPORT DATAFILE="c:\USERS\NTORRES3\DOWNLOADS\EXT.H188A.ssp"
DBMS=SSP
OUT=EXT.H188A.SSP_IMPORT;
GETNAMES=YES;
GUESSINGROWS=MAX;
REPLACE;
run;
I just want to be able to read the files so I can start my project but I cannot get past this.
A dataset name has at maximum 2 levels (library and membername). Yours has three (EXT, H188A and SSP_IMPORT).
Now it says this
ERROR: Physical file does not exist, c:\USERS\NTORRES3\DOWNLOADS\EXT.H188A.ssp.
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.03 seconds
cpu time 0.03 seconds
When SAS tells you a file is not there, then it's not there. If your SAS does not run on your desktop, but on a remote server, it does not have access to your C drive.
PROC IMPORT DATAFILE="c:\USERS\NTORRES3\DOWNLOADS\EXT.H188A.CSV"
DBMS=CSV
OUT=mydata replace;
GETNAMES=YES;
GUESSINGROWS=500;
run;
Try this and post the exact log.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
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.
Ready to level-up your skills? Choose your own adventure.