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-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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