topic Re: intck assistance in SAS Procedures

intck assistance

mastereh — Thu, 13 May 2010 15:38:56 GMT

Current code is:
if date ge 20081228 and date le 20090103 then Week= 20081228 ;
else if date ge 20090104 and date le 20090110 then Week= 20090104 ;
else if date ge 20090111 and date le 20090117 then Week= 20090111 ;
else if date ge 20090118 and date le 20090124 then Week= 20090118 ;
else if date ge 20090125 and date le 20090131 then Week= 20090125 ;
else if date ge 20090201 and date le 20090207 then Week= 20090201 ;

This continues until the end of 2010. I'd like to condense this code using the intck function but can't seem to figure out how.

Any assistance would be greatly appreciated.

Re: intck assistance

sfsdtegsdsdgdffhgfh — Thu, 13 May 2010 15:58:51 GMT

try this

week = intnx('week',date,0,'b');

GL.

Re: intck assistance

Bill — Thu, 13 May 2010 16:13:01 GMT

here's one possibility ...

data test (drop=_:);
do _date='28dec08'd to '01jan2011'd by 7;
week='20'||put(intnx('week',_date,0,'b'),yymmdd6.);
output;
end;
run;