topic Re: Can someone help re: if date= "Friday" then put 'Today is =' date; because it's not wo in SAS Programming

Can someone help re: if date= "Friday" then put 'Today is =' date; because it's not working.

KAMP — Wed, 17 Feb 2021 15:01:20 GMT

SAS Code:

Date=today()-5;

Format Date DOWNAME.;

put "date=" date;

is working and the code has output date as Friday

BUT, the code: if date= "Friday" then put 'Today is =' date; is not working. Can someone help?

ballardw — Wed, 17 Feb 2021 15:12:45 GMT

A format controls how a value displays, not what to test for equality.

If you want to test a formatted value the you would use Put(variable, formatname.)

If a value is a date then the easiest way to check if date is a specific day of the week is to use the WEEKDAY function.

The WEEKDAY function produces an integer that represents the day of the week, where 1=Sunday, 2=Monday, ..., 7=Saturday.

So you would use

if weekday(date) = 7 then <do what ever when "friday">

KAMP — Wed, 17 Feb 2021 15:19:40 GMT

Thanks a lot. 🙂