topic Re: set counter in SAS Programming

set counter

Steelers_In_DC — Fri, 13 Feb 2015 14:16:11 GMT

I am using a counter like this:

data test;

set data;

by power_id record_date;

cure_count+1;

if first.power_id then count= 1;

if default ne '' then count= 0;

There is a facility_id that roles up to power_id. Is there a way to keep facility_id in this dataset but not count by it?

Here is what I have:

Here is what I want:

LinusH — Fri, 13 Feb 2015 14:29:03 GMT

Do cure_count+1; only when facility_id = 1?

Steelers_In_DC — Fri, 13 Feb 2015 14:39:28 GMT

I'm not sure I understand your solution. This is for a table that has millions of power_id's and facility_id's.

RW9 — Fri, 13 Feb 2015 14:58:54 GMT

Hi,

data want;

set have;

by power_id facility_id;

retain cure_count;

if first.factility_id then sum(cure_count,1);

run;

LinusH — Fri, 13 Feb 2015 15:20:24 GMT

From you sample it looked like facility restarts its count, each date? Your sample may not represent the real complexity.

Perhaps you could use first.record_date instead.

Tom — Fri, 13 Feb 2015 15:26:32 GMT

Why did you bump the counter when you did? Was it because of the change in date?

data want ;

set have ;

by power_id record_date ;

if first.power_id then cure_count=0;

if first.record_date then cure_count+1;

run;