WEEKVw. format with numeric output

[m1986MM]

Hello everyone,

There is a date variable, containing different dates from 2000 to 2015, in my dataset. I need to group the observation by week. So I wrote the following code to generate the weekly values:

data new; set old;

weekly_date=put(date,weekv5.); run;

The reason for using weekv5. is that I need to know the year and the week of each date.

The problem is that the outcome of the above code is in character format, but I need to compare the weekly_date, for example keep the observation with weekly_date greater than specific time. To do that, I think I need weekly_date should be in numeric format. How can I fix it?

Thanks,

[Reeza · Accepted solution]

Don't create a new variable, keeping it in a date form allows you use date functions further on.

format date weekv5.;

[m1986MM]

Thank you.