topic Re: Second value assigned to a variable returns a dot instead of the value requested in the code in SAS Programming

Second value assigned to a variable returns a dot instead of the value requested in the code

newtriks — Thu, 18 May 2023 15:54:00 GMT

Code is below. I'm trying to subset a file and assign a binary variable to an ordinal value in another variable. Problem is that the first value, YesTot=0, gets assigned but the second one, YesTot=1, returns only a dot instead of a 1

DATA SLOWN;
SET SLOWNA;
IF MAT_1 = 'No' OR MAT_2 = 'No' OR MAT_3 = 'No' THEN OUTPUT;
IF YesTot = 0 THEN Lower3Amt = 0; ELSE Lower3Amt = 1;
KEEP Record Reapp Matched YesTot Lower3Amt;
RUN;

Any and all help is appreciated. Thanks!

Re: Second value assigned to a variable returns a dot instead of the value requested in the code

Tom — Thu, 18 May 2023 19:07:44 GMT

You have written the observation before you gave Lower3Amt any value. So its value is missing.

Move the creation of Lower3Amt to BEFORE the OUTPUT statement.

Re: Second value assigned to a variable returns a dot instead of the value requested in the code

newtriks — Thu, 18 May 2023 16:11:20 GMT

That did the trick. THANK YOU!