topic Re: Counter in SAS, please help. Thanks in SAS Programming

Counter in SAS, please help. Thanks

Question — Thu, 14 Mar 2013 16:32:00 GMT

Hi All,

This should be very quick for you, 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 mucg appreciated.

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, please help. Thanks

ArtC — Thu, 14 Mar 2013 17:26:58 GMT

Add this line of code.

if first.delivery_week then new_column+1;

Re: Counter in SAS, please help. Thanks

Question — Thu, 14 Mar 2013 17:57:33 GMT

Many Thanks Art

Re: Counter in SAS, please help. Thanks

Haikuo — Thu, 14 Mar 2013 18:28:04 GMT

As a variation of ArtC's suggestion:

new_column+first.delivery_week;

Haikuo

Re: Counter in SAS, please help. Thanks

ArtC — Thu, 14 Mar 2013 18:45:27 GMT

yours is cleaner Haikuo - thanks

Re: Counter in SAS, please help. Thanks

PGStats — Thu, 14 Mar 2013 19:32:36 GMT

An alternative would be :

proc rank data=myData out=want;

BY SOLD_TO_ORG_ID DELIVERY_YEAR;

var delivery_week;

ranks new_column;

run;