topic No valid observations are found in New SAS User

No valid observations are found

kngu022 — Tue, 28 Jan 2020 05:26:45 GMT

Hi everyone;

I tried to make a prediction on data file. and the errors turns up like below. Can you please tell me what wrong is?

DATA add;
	INPUT LogSalary YrMajor @@;YrMajor2=YrMajor*YrMajor;
CARDS;
. 10 
. 20 
;
RUN;
PROC PRINT DATA = add;
RUN;
DATA BOTH;
	SET A2(WHERE=(name^="ROSE,PETE")) add;
RUN;
PROC REG DATA=BOTH;
	MODEL LogSalary = YrMajor YrMajor2/CLB;
	OUTPUT OUT=resid R=resid P=pred LCL=lcl UCL=ucl;
RUN;
QUIT;
PROC PRINT DATA=resid; 
	Var Salary YrMajor YrMajor2 pred lcl ucl;
	WHERE Salary = .;
RUN;
 
 86         PROC REG DATA=BOTH;
 87         MODEL LogSalary = YrMajor YrMajor2/CLB;
 88         OUTPUT OUT=resid R=resid P=pred LCL=lcl UCL=ucl;
 89         RUN;
 
 ERROR: No valid observations are found.
 90         QUIT;

Re: No valid observations are found

mkeintz — Tue, 28 Jan 2020 06:16:45 GMT

@kngu022 wrote:

Hi everyone;

I tried to make a prediction on data file. and the errors turns up like below. Can you please tell me what wrong is?

DATA add;
	INPUT LogSalary YrMajor @@;YrMajor2=YrMajor*YrMajor;
CARDS;
. 10 
. 20 
;
RUN;
PROC PRINT DATA = add;
RUN;
DATA BOTH;
	SET A2(WHERE=(name^="ROSE,PETE")) add;
RUN;
PROC REG DATA=BOTH;
	MODEL LogSalary = YrMajor YrMajor2/CLB;
	OUTPUT OUT=resid R=resid P=pred LCL=lcl UCL=ucl;
RUN;
QUIT;
PROC PRINT DATA=resid; 
	Var Salary YrMajor YrMajor2 pred lcl ucl;
	WHERE Salary = .;
RUN;
 
 86         PROC REG DATA=BOTH;
 87         MODEL LogSalary = YrMajor YrMajor2/CLB;
 88         OUTPUT OUT=resid R=resid P=pred LCL=lcl UCL=ucl;
 89         RUN;
 
 ERROR: No valid observations are found.
 90         QUIT;

The DATA BOTH step tells SAS to read in all the qualifying observations from A2, followed by the two observations from ADD, resulting in N(A2) + N(ADD) observations. We can see in your program that ADD only has missing values for LOGSALARY. Apparently the observations originating in A2 have the same problem, since the PROC REG reports "No valid observations.", i.e. LOGSALARY is missing for every observation.

Re: No valid observations are found

kngu022 — Tue, 28 Jan 2020 07:18:04 GMT

Do you mean that on my data file"add" missing the LogSalary value? How can I fix it when it is what I want to predict with value of YrMajor be 10 and 20?

DATA add;
	INPUT LogSalary YrMajor @@;YrMajor2=YrMajor*YrMajor;
CARDS;
. 10 
. 20 
;
RUN;

Re: No valid observations are found

Rick_SAS — Tue, 28 Jan 2020 16:44:21 GMT

Check the size of the BOTH data set. If your WHERE clause is incorrect, then it will only have the two scoring observations from the ADD data.

For example, perhaps the correct WHERE clause needs a space after the comma:

SET A2(WHERE=(name^="ROSE, PETE")) add;