BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
abhilashatiwari
Obsidian | Level 7

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

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User

If numeric use math

var=year*100+week;

 

if if you want a Character use catt

 

var=catt(year, put(week, z2.));

View solution in original post

2 REPLIES 2
Reeza
Super User

If numeric use math

var=year*100+week;

 

if if you want a Character use catt

 

var=catt(year, put(week, z2.));

abhilashatiwari
Obsidian | Level 7

Thank you so much Reeza..It works !!!

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

Tips for filtering data sources in SAS Visual Analytics

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.

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