Counter in SAS

[Question]

Hi All,

I would like to add a new column that count weeks like below...

I know how to count number of rows, but here, it's different, I want to say for example week51 and year 2009 is Week1 like below. Your help will be much appreciated. Many Thanks

  CUST_10000048_V2; 

SET CUST_10000048;

RETAIN COUNTER;

BY SOLD_TO_ORG_ID DELIVERY_YEAR DELIVERY_WEEK;

IF FIRST.SOLD_TO_ORG_ID AND FIRST.DELIVERY_YEAR AND FIRST.DELIVERY_WEEK THEN COUNTER=0;

COUNTER=COUNTER+1;

  ;

SOLD_TO_ORG_ID	DELIVERY_DATE	WEEK_YEAR	DELIVERY_YEAR	DELIVERY_WEEK	NEW_COLUMN
10000048	21/12/2009	51 - 2009	2009	51	1
10000048	23/12/2009	51 - 2009	2009	51	1
10000048	28/12/2009	52 - 2009	2009	52	2
10000048	30/12/2009	52 - 2009	2009	52	2
10000048	04/01/2010	1 - 2010	2010	1	3
10000048	08/01/2010	1 - 2010	2010	1	3
10000048	11/01/2010	2 - 2010	2010	2	4

[Reeza]

Please don't post to multiple area's.

DATA  CUST_10000048_V2; 

SET CUST_10000048;

RETAIN COUNTER 0;

BY SOLD_TO_ORG_ID DELIVERY_YEAR DELIVERY_WEEK;

IF FIRST.DELIVERY_WEEK THEN COUNTER=counter+1;

run;

[Question · Accepted solution]

Sorry, Many thanks for your reply...

[Question]

Thank you again, it works perfectly