Help using Base SAS procedures

WEEKVw. format with numeric output

Accepted Solution Solved
Reply
Contributor
Posts: 65
Accepted Solution

WEEKVw. format with numeric output

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,


Accepted Solutions
Solution
‎07-15-2015 03:31 PM
Super User
Posts: 19,869

Re: WEEKVw. format with numeric output

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

format date weekv5.;

View solution in original post


All Replies
Solution
‎07-15-2015 03:31 PM
Super User
Posts: 19,869

Re: WEEKVw. format with numeric output

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

format date weekv5.;

Contributor
Posts: 65

Re: WEEKVw. format with numeric output

Thank you.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 229 views
  • 0 likes
  • 2 in conversation