topic Re: Start over count when a new value is reached in SAS Programming

Start over count when a new value is reached

tbick — Thu, 23 May 2013 13:06:35 GMT

Hello,

I have the following data:

personID caretype date

1 primary 18000

1 primary 18001

1 specialty 18005

1 primary 18007

1 specialty 18008

1 specialty 18009

1 primary 18020

I would like to create a count variable where the count starts over every time it reaches the caretype value of "primary". For example, I would like my data to look like the following:

personID caretype date count

1 primary 18000 1

1 primary 18001 1

1 specialty 18005 2

1 primary 18007 1

1 specialty 18008 2

1 specialty 18009 3

1 primary 18020 1

Any ideas on how to do this?

Thank you!

Re: Start over count when a new value is reached

Linlin — Thu, 23 May 2013 13:17:21 GMT

data have;

input personID caretype $ date;

cards;

1 primary 18000

1 primary 18001

1 specialty 18005

1 primary 18007

1 specialty 18008

1 specialty 18009

1 primary 18020

;

data want;

set have;

if upcase(caretype)="PRIMARY" then count=1;

else count+1;

run;

proc print;run;

Re: Start over count when a new value is reached

PaulLee — Thu, 23 May 2013 13:29:27 GMT

I think the retain statement needs to be used to make the count work....

data test;

input personID caretype $ date;

cards;

1 primary 18000

1 primary 18001

1 specialty 18005

1 primary 18007

1 specialty 18008

1 specialty 18009

1 primary 18020

;

data test2;
set test;
retain count;

if caretype = "primary" then count = 1;
else count = count + 1;
run;

Re: Start over count when a new value is reached

Linlin — Thu, 23 May 2013 13:38:55 GMT

you don't have to use retain if you change

count = count + 1;

count+1;

Re: Start over count when a new value is reached

tbick — Thu, 23 May 2013 16:47:55 GMT

Perfect, thank you!