topic Re: how to get the first high values in a row by group in SAS Data Management

how to get the first high values in a row by group

shasank — Thu, 28 Jun 2018 21:52:37 GMT

Hello SAS community,

I would like your help in the following problem.

raw data:-

ID	seq	Idnum
1	00	01
1	02	05
1	03	04
1	04	05
2	00	01
2	03	01
3	00	01

I would like to recode 00 as 01 when the subsequent code under same ID are >00 and keep the 00 when there are no subsequent codes.

The output can look like this.

ID	seq	Idnum
1	01	01
1	02	05
1	03	04
1	04	05
2	01	01
2	03	01
3	00	01

Thank you for your help.

Re: how to get the first high values in a row by group

novinosrin — Thu, 28 Jun 2018 21:59:40 GMT

data have;
input ID	(seq	Idnum) ($);
cards;
1	00	01
1	02	05
1	03	04
1	04	05
2	00	01
2	03	01
3	00	01
;

data want;
set have;
by id;
if first.id and not last.id then seq='01';
run;

Re: how to get the first high values in a row by group

shasank — Thu, 28 Jun 2018 22:08:46 GMT

Thank you so much for the help.

Re: how to get the first high values in a row by group

novinosrin — Thu, 28 Jun 2018 22:09:22 GMT

You are welcome 🙂 Have a good one!