if then

[R_A_G_]

Hello,

I need help in changing the first and 8th observation of my data, while leaving the rest unchanged.
using a simple
if obs=1 then s=1 s2=1 s3=1;
run;
does not work

[RickM]

It should be :


if _N_=1 or _N_=8 then s=1 s2=1 s3=1;
run;

Good luck!

[R_A_G_]

thanks but it gives me the following error:

NOTE: Line generated by the invoked macro "MISQMATRIX".
1 data QMatrix; set Q_MATRIX_WR; IF _N_=1 or _N_=8 THEN skills1=1 skills2=1 skills3=1; run;

-------
-------

22
22

ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, ;, <, <=,
<>, =, >, ><, >=, AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL, NOTIN, OR, ^=,
|, ||, ~=.

NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.QMATRIX may be incomplete. When this step was stopped there were 0
observations and 4 variables.
WARNING: Data set WORK.QMATRIX was not replaced because this step was stopped.

[RickM]

Sorry about that, you also need to use do;

data QMatrix;
set Q_MATRIX_WR;
IF _N_=1 or _N_=8 THEN do;
skills1=1;
skills2=1;
skills3=1;
end;
run;

[Tim_SAS]

[pre]
if _N_ = 1 or _N_ = 8 then do;
skills1=1;
skills2=1;
skills3=1;
end;
[/pre]

[R_A_G_]

Thank you Rick and Tim it WORKED!
R.A.G.

[advoss]

Or
if _N_ in (1,8) then do;
skills1=1;
skills2=1;
skills3=1;
end;