topic Re: Create a counter variable in SAS Programming

Create a counter variable

desireatem — Wed, 26 Apr 2017 17:47:19 GMT

I have this data set and I want to create a count variable for number of time in hospital;

Id date

001 01/07/17

001 03/07/17

002 01/07/17

003 02/01/17

003 04/05/17

004 05/05/17

;

I want to create a third variable number of visit such that the data becomes;

Id date number_visit

001 01/07/17 1

001 03/07/17 2

002 01/07/17 1

003 02/01/17 1

003 04/05/17 2

004 05/05/17 1

best.

Reeza — Wed, 26 Apr 2017 17:47:35 GMT

See the solution here to create a counter variable:

Jagadishkatam — Thu, 27 Apr 2017 02:04:44 GMT

alternatively, you could also try the proc sql monotonic()

proc sql;
create table want as select *, (monotonic()-min(monotonic())+1) as number_visit from have group by id;
quit;