WEEKVw. format with numeric output

m1986MM — Wed, 15 Jul 2015 19:18:45 GMT

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,

Re: WEEKVw. format with numeric output

Reeza — Wed, 15 Jul 2015 19:31:29 GMT

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

format date weekv5.;

Re: WEEKVw. format with numeric output

m1986MM — Wed, 15 Jul 2015 19:36:21 GMT

Thank you.

topic Re: WEEKVw. format with numeric output in SAS Procedures

WEEKVw. format with numeric output

Re: WEEKVw. format with numeric output

Re: WEEKVw. format with numeric output