topic Re: ERROR: Output SAS data set must be provided. in SAS Programming

ERROR: Output SAS data set must be provided.

98ighcfdvxcghjk — Fri, 13 Dec 2019 15:28:07 GMT

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.

Re: ERROR: Output SAS data set must be provided.

Kurt_Bremser — Fri, 13 Dec 2019 15:32:48 GMT

You have a erroneous semicolon in the proc import line that ends the statement prematurely.

Re: ERROR: Output SAS data set must be provided.

98ighcfdvxcghjk — Fri, 13 Dec 2019 15:35:35 GMT

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.

Re: ERROR: Output SAS data set must be provided.

Kurt_Bremser — Fri, 13 Dec 2019 15:37:49 GMT

A dataset name has at maximum 2 levels (library and membername). Yours has three (EXT, H188A and SSP_IMPORT).

Re: ERROR: Output SAS data set must be provided.

98ighcfdvxcghjk — Fri, 13 Dec 2019 15:51:44 GMT

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

Re: ERROR: Output SAS data set must be provided.

Kurt_Bremser — Fri, 13 Dec 2019 15:56:22 GMT

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.

Re: ERROR: Output SAS data set must be provided.

Reeza — Fri, 13 Dec 2019 16:35:41 GMT


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.