week function

[sophia_SAS]

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?

[pradeepalankar]

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

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

[Reeza]

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.

[pradeepalankar]

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;