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

[KAMP]

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 · Accepted solution]

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]

Thanks a lot. 🙂