Hi,
I am facing a challenge in getting two date values like Year and Week to be concatenated as YearWeek.
For example:
Year=2015
Week number = 1 To 52
Result needed is a new varaible "Year_Weeknumber" = 201501, 201502 etc. in this format, displaying year and week number.
I have the year and weeknumber calculated in SAS from dates, but unable to concatenate them.
I am able to have yearMonth, YearQuarter values from date using Format, but did not find "Year Weeknumber" option there.
Regards,
Abhi
If numeric use math
var=year*100+week;
if if you want a Character use catt
var=catt(year, put(week, z2.));
If numeric use math
var=year*100+week;
if if you want a Character use catt
var=catt(year, put(week, z2.));
Thank you so much Reeza..It works !!!
Catch the best of SAS Innovate 2025 — anytime, anywhere. Stream powerful keynotes, real-world demos, and game-changing insights from the world’s leading data and AI minds.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.