I want to mark the first row after a dummy variable is 1

SasStatistics — Mon, 03 Oct 2022 14:06:03 GMT

Assume I have the following table:

row	ID	dummy_variable	my_new_dummy
1	1	0
2	1	1
3	1	0	1
4	2	0
5	2	0
6	2	0
7	2	0
8	2	1
9	2	0	1

so, as you can see we have two unique ID (1 and 2), for each of the unique id we have a column "dummy_variable" which has a 1 in it. The first row AFTER dummy_variable = 1 I want to "mark" by creating a new column: "my_new_dummy_variable" which should have the value 1 on the first row after dummy_variable = 1.

Any ideas on how to do this?

Thanks.

Re: I want to mark the first row after a dummy variable is 1

PaigeMiller — Mon, 03 Oct 2022 14:22:13 GMT

/* UNTESTED CODE */

data want;
    set have;
    prev_dummy_variable=lag(dummy_variable);
    if prev_dummy_variable=1 then my_new_dummy=1;
    else my_new_dummy=.;
    drop prev_dummy_variable;
run;

topic I want to mark the first row after a dummy variable is 1 in SAS Programming

I want to mark the first row after a dummy variable is 1

Re: I want to mark the first row after a dummy variable is 1