topic Re: week function in SAS Programming

week function

sophia_SAS — Fri, 10 Jan 2014 22:21:43 GMT

I'm using the following function: week_function=week(dt,'u'); For weeks 0-9 (i.e. January - March), SAS only returns a single value I.e. 0, 1, 2, 3, 4 etc. However, I would like SAS to return a two value digit instead, so

0 --> 00

1 --> 01

2 --> 02

and so on.

Suggestions?

Re: week function

pradeepalankar — Fri, 10 Jan 2014 22:32:24 GMT

Use this, but this will be text instead of numeric .

week_function=put(week(dt,'u'),z2.);

Re: week function

Reeza — Fri, 10 Jan 2014 22:35:34 GMT

If you want it displayed as 01, 02 you can apply the z2 format. If you want it as text instead, use the formula supplied above.

Re: week function

pradeepalankar — Fri, 10 Jan 2014 22:49:00 GMT

As explained by Reeza above, you can also use Z2. in format if you need column as Num;

data want;

format week_function z2.;

week_function=week('01JAN2014'd,'u');

run;