Hi,   I would like assistance on how to get a count function that has two variables that could cause it to reset. I am looking at agents and the number of sales they have made per day. I want to have a count function that counts the number of consecutive zeros each agent has. At the moment I have a table that looks like this: Agent Date Number of Sales 1 01-Jan 0 1 02-Jan 1 1 03-Jan 3 1 04-Jan 0 1 05-Jan 0 2 01-Jan 0 2 02-Jan 0 2 03-Jan 0 2 04-Jan 2 3 01-Jan 1 3 02-Jan 0 3 03-Jan 0 3 04-Jan 3 3 05-Jan 4     And I would like to have a count function that looks like this (I really dont mind if the count variable when the ticket isnt zero is one or zero): Agent Date Number of Sales Count 1 01-Jan 0 1 1 02-Jan 1 0 (or 1) 1 03-Jan 0 1 1 04-Jan 0 2 1 05-Jan 0 3 2 01-Jan 0 1 2 02-Jan 0 2 2 03-Jan 0 3 2 04-Jan 2 0(or 1) 3 01-Jan 1 0(or 1) 3 02-Jan 0 1 3 03-Jan 0 2 3 04-Jan 3 0(or 1) 3 05-Jan 4 0(or 1)   So far I have tried this: proc sort data=agents2 out= agents3 by agent_id sale_dt sale; run; data test; set agents3; retain count; by agent_id; if first.agent_id and sale>0 then do; count=0; end; count+1; run;   However that didnt work I also tried this:       PROC SORT DATA= agents3 OUT=test /*NODUPKEY*/;             BY agent date sales;       RUN;       DATA test;             SET test;             RETAIN CONSEC_NUM;             BY agent date sales;             IF FIRST.salesTHEN CONSEC_NUM = 0;             CONSEC_NUM = CONSEC_NUM + 1;       RUN;   But this is not working. Does anyone have any idea how I can get this to work? ... View more