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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.