topic Re: if then in SAS Procedures

if then

R_A_G_ — Tue, 19 Apr 2011 16:56:24 GMT

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

Re: if then

RickM — Tue, 19 Apr 2011 16:58:59 GMT

It should be :

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

Good luck!

Re: if then

R_A_G_ — Tue, 19 Apr 2011 17:09:09 GMT

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.

Re: if then

RickM — Tue, 19 Apr 2011 17:11:20 GMT

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;

Re: if then

Tim_SAS — Tue, 19 Apr 2011 17:12:16 GMT

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

Re: if then

R_A_G_ — Tue, 19 Apr 2011 17:15:07 GMT

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

Re: if then

advoss — Wed, 20 Apr 2011 16:14:16 GMT

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