Re: do loops weekday

Report Inappropriate Content · Posted 08-13-2023 12:35 PM

Question : Find weekday for every year from 15aug1940 to now(today) ??

output
August 15, 1940: Thursday
August 15, 1941: Friday
August 15, 1942: Saturday
August 15, 1943: Sunday
August 15, 1944: Tuesday
August 15, 1945: Wednesday
... (continuing for each year up to the current year)

MarkusWeick · Posted 08-13-2023 12:50 PM

Hi @112211, you could use the mod function to to get the remainder from the division of the date (an integer number in SAS) by 7. If the remainder is negative you have to add 7. Each of the seven positive possible remainders correspond to a weekday.

Hope, this helps.

Best, Markus

Please keep the community friendly.
Like posts you agree with or like. Mark helpful answers as “accepted solutions”. Generally have a look at https://communities.sas.com/t5/Getting-Started/tkb-p/community_articles

Kurt_Bremser · Posted 08-13-2023 01:51 PM

Use the MDY function to build the SAS dates. Then either use the WEEKDAY function to retrieve the weekday in numeric fashion, or use the DOWNAME format to display the weekday name.

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX

Quentin · Posted 08-13-2023 07:15 PM

Please show the code you have tried, so that we can help you improve it. In addition to the suggestions from others, you might want to use the INTNX function for advancing the date by a year at a time.

The Boston Area SAS Users Group is hosting free webinars!
Next webinar will be in January 2025. Until then, check out our archives: https://www.basug.org/videos. And be sure to subscribe to our our email list.

do loops weekday