topic Re: do loops weekday in SAS Programming

do loops weekday

112211 — Sun, 13 Aug 2023 16:35:08 GMT

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)

Re: do loops weekday

MarkusWeick — Sun, 13 Aug 2023 16:50:53 GMT

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

Re: do loops weekday

Kurt_Bremser — Sun, 13 Aug 2023 17:51:33 GMT

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.

Re: do loops weekday

Quentin — Sun, 13 Aug 2023 23:15:34 GMT

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.