topic Re: Counter in SAS in SAS Procedures

Counter in SAS

Question — Thu, 14 Mar 2013 16:03:53 GMT

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

Re: Counter in SAS

Reeza — Thu, 14 Mar 2013 16:45:52 GMT

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;

Re: Counter in SAS

Question — Thu, 14 Mar 2013 16:56:47 GMT

Sorry, Many thanks for your reply...

Re: Counter in SAS

Question — Thu, 14 Mar 2013 16:58:12 GMT

Thank you again, it works perfectly