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,
Don't create a new variable, keeping it in a date form allows you use date functions further on.
format date weekv5.;
Don't create a new variable, keeping it in a date form allows you use date functions further on.
format date weekv5.;
Thank you.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.