BookmarkSubscribeRSS Feed
SGB
Obsidian | Level 7 SGB
Obsidian | Level 7

https://communities.sas.com/message/190760#190760 - Related Question and Answers from the community!

My question regarding dynamically getting the number of each weekdays in all 12 months in a given year has been answered by HaiKuo, Quentin and Tom.

I want to know the dates associated with those weekdays as well.

I tried tweaking the existing code but it didnt work..

Year Month Day     num date

2013 Jan     Sun    4      Jan 6 2013

2013 Jan      Sun   4      Jan 13 2013

2013 Dec     Sat   4      Jan 7 2013

2013 Dec      Sat   4      Jan 14 2013

2014 Jan     Sun    4      Jan 6 2014

2014 Jan      Sun   4      Jan 13 2014

2014 Dec     Sat   4      Jan 7 2014

2014 Dec      Sat   4      Jan 14 2014

Something like this. 

Appreciate your time and help in this regard.

Thanks

SGB

2 REPLIES 2

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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