topic How to code for the consecutive values in SAS Programming

How to code for the consecutive values

ursula — Sat, 26 Sep 2015 01:39:06 GMT

Hi there,

I wonder if someone can help me to figure it out of how to write code for filling the consecutive values, as following:

for example:

ID A at visit 3, the value = 1, I want to fill the consecutive visits with the value as 1.

Please let me know if my question is not clear enough.

Thanks you very much in advance.

PGStats — Mon, 28 Sep 2015 18:37:12 GMT

BY-processing is perfect for this type of problem:

data want;
retain WANTS;
set have; by ID;
if first.ID then WANTS = 0;
if value then WANTS = 1;
run;

Edited, thanks to ballardw!

ballardw — Mon, 28 Sep 2015 16:29:05 GMT

If Value then Wants=1;

I think.

ursula — Tue, 29 Sep 2015 17:17:00 GMT

wow, it works!!

Thanks so much!!

ursula — Tue, 29 Sep 2015 17:19:38 GMT

Thanks, ballardw for updating the code.

I appreciate your help!