topic Re: Count child by parent in SAS Procedures

Count child by parent

MCB — Tue, 04 Sep 2012 14:29:26 GMT

Hi,

I have this data set: 1 parent with 2 children, both children appears on each case. case nr 2 repeat itself three tims for child nr 465. I need to create a variable (counter) which counts the children by the parent-ID. The expected results are dispayed on the right column "wanted counter". Can anyone sujest how to solve it? thanks.

obs	CASE	ID-parent	ID-child	Wanted counter
1	1	10	111	1
2	1	10	455	2
3	2	10	111	1
4	2	10	455	2
5	2	10	455	2
6	2	10	455	2

Re: Count child by parent

Haikuo — Tue, 04 Sep 2012 14:43:43 GMT

Give the data as is, and with the assumption that the data is sorted or at least clustered:

data have;

input CASE ID_parent ID_child ;

cards;

1 10 111

1 10 455

2 10 111

2 10 455

;

data want;

set have;

by case id_parent Id_child notsorted;

if first.case then call missing (count);

count+first.id_child;

run;

proc print;run;

Haikuo

Re: Count child by parent

DanielSantos — Tue, 04 Sep 2012 15:03:50 GMT

Using lag, and deriving from Mike's simplified code here: https://communities.sas.com/message/137090#137090

data WANT;

set HAVE;

retain WANTED;

WANTED=sum(WANTED*(lag(CASE) = CASE),(lag(ID_child) ^= ID_child));

run;

Re: Count child by parent

MCB — Wed, 05 Sep 2012 05:49:54 GMT

Thanks! I will try it!