topic Re: counting in SAS Programming

counting

sophia_SAS — Thu, 12 Jun 2014 12:50:52 GMT

I would like to count the number of weeks in my dataset. The starting number should begin with 501. Please advise on the code. Below is a sample of dataset I want to have in the end. The week count continues for 10 years.

Thanks

Data want;

input week count;

05Jul2010 501

12Jul2010 502

19Jul2010 503

26Jul2010 504

;;

run;

Re: counting

OS2Rules — Thu, 12 Jun 2014 12:58:06 GMT

proc sort data=want;

by week;

run;

data want2;

set want;

by week;

retain count;

if _n_=1 then count=500;

if first.week then count + 1;

run;

Re: counting

DBailey — Thu, 12 Jun 2014 13:05:56 GMT

proc sql;

select

count(distinct week) as weeks

from have;

quit;

Re: counting

Haikuo — Thu, 12 Jun 2014 13:06:08 GMT

Here is one way:

Data have;

input week date9.;

format week date9.;

cards;

05Jul2010

12Jul2010

19Jul2010

26Jul2010

;;

/*data step*/

data want;

set have;

retain start;

if _n_=1 then

start=week;

count=intck('week',start,week)+501;

drop start;

run;

/*proc sql;*/

proc sql;

create table want_sql as

select *, 501+intck('week',min(week),week) as count from have;

quit;

Regards,

Haikuo

Re: counting

sophia_SAS — Thu, 12 Jun 2014 13:30:57 GMT

Thanks for the code. If I want to stop the count at 525, what do I change?

Re: counting

stat_sas — Thu, 12 Jun 2014 14:15:36 GMT

data want;
set have;
by week;
if first.week then n+1;
run;

data final;
set want;
count=500+n;
if count>525 then stop;
run;