Help using Base SAS procedures

Counter in SAS

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 96
Accepted Solution

Counter in SAS

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_IDDELIVERY_DATEWEEK_YEARDELIVERY_YEARDELIVERY_WEEKNEW_COLUMN
1000004821/12/200951 - 20092009511
1000004823/12/200951 - 20092009511
1000004828/12/200952 - 20092009522
1000004830/12/200952 - 20092009522
1000004804/01/20101 - 2010201013
1000004808/01/20101 - 2010201013
1000004811/01/20102 - 2010201024

Accepted Solutions
Solution
‎03-14-2013 12:56 PM
Frequent Contributor
Posts: 96

Re: Counter in SAS

Sorry, Many thanks for your reply...

View solution in original post


All Replies
Super User
Posts: 19,770

Re: Counter in SAS

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;

Solution
‎03-14-2013 12:56 PM
Frequent Contributor
Posts: 96

Re: Counter in SAS

Sorry, Many thanks for your reply...

Frequent Contributor
Posts: 96

Re: Counter in SAS

Thank you again, it works perfectly Smiley Happy

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 193 views
  • 0 likes
  • 2 in conversation