Enumerating Variable

twildone — Wed, 17 Aug 2016 19:39:21 GMT

Hi...I am having problems with incrementing a count. For each ID, starting at 1 and increment by 1 when their is a change in the Program type and retain the count and increment by 1 when there is another change in the Program type. Thanks.

DATA GROUP58B;

SET GROUP58A;

COUNT+1;

RETAIN COUNT;

BY ID;

IF FIRST.ID THEN COUNT=1;

IF ID = LAG(ID) AND PROGRAM = LAG(PROGRAM) THEN COUNT = 1;

RUN;

Have:

DATE	ID	PROGRAM	COUNT
20130219	130439	HCP	1
20140121	130439	HCP	1
20140403	130439	HCP	1
20160314	130439	PCP	2
20160314	130439	PCP	1
20160415	130439	PCP	1

Want:

DATE	ID	PROGRAM	COUNT
20130219	130439	HCP	1
20140121	130439	HCP	1
20140403	130439	HCP	1
20160314	130439	PCP	2
20160314	130439	PCP	2
20160415	130439	PCP	2

Re: Enumerating Variable

Reeza — Wed, 17 Aug 2016 19:42:07 GMT


DATA GROUP58B;
     SET GROUP58A;
     COUNT+1;  *wrong position, this would be the first step, move it later in the program;
     RETAIN COUNT;
           BY ID;
                IF FIRST.ID THEN COUNT=1;
                IF ID = LAG(ID) AND PROGRAM = LAG(PROGRAM) THEN COUNT = 1; *This doesn't make sense, its what you use first for to avoid checking previous values;
RUN;

See comments in code above.

The code below should work

DATA GROUP58B;
     SET GROUP58A;

     RETAIN COUNT;
           BY ID PROGRAM;
                IF FIRST.ID THEN COUNT=0;
                if first.program then count+1;
 
RUN;

topic Re: Enumerating Variable in SAS Programming

Enumerating Variable

Re: Enumerating Variable