topic Iteratively Generate a variable in SAS Programming

Iteratively Generate a variable

liyongkai800 — Tue, 19 Jun 2018 14:47:18 GMT

Hello,

If I have two variables called xvar and yvar, how can I generate the yvar by adding 1 if xvar is even and staying the same if xvar is odd? The yvar is initialized to be 1.

xvar yvar

2 1

Output wanted:

xvar yvar

2 1

3 1

5 1

6 2

7 2

8 3

I tried the retain statement for yvar but can't get the expected result. Thanks.

Re: Iteratively Generate a variable

Ksharp — Tue, 19 Jun 2018 14:53:59 GMT

data have;
input xvar; 
retain yvar 0;
if mod(xvar,2)=0 then yvar+1;   
cards;
2           
3
5
6
7
8
;
run;

Re: Iteratively Generate a variable

liyongkai800 — Tue, 19 Jun 2018 15:00:08 GMT

Thank you, that's exactly what I expect.