BookmarkSubscribeRSS Feed
98ighcfdvxcghjk
Calcite | Level 5

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. 

6 REPLIES 6
98ighcfdvxcghjk
Calcite | Level 5

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. 

98ighcfdvxcghjk
Calcite | Level 5

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

Kurt_Bremser
Super User

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.

Reeza
Super User

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. 

sas-innovate-wordmark-2025-midnight.png

Register Today!

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.


Register now!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 6 replies
  • 2049 views
  • 0 likes
  • 3 in conversation