If And Then

[BETO]

Data Test_3;

Set Test_3;

if find(Deposit_Pull_Schedule,substr(left(put(today(),weekdate.)),1,3))-1 then

deliveryday="NO ";else deliveryday="YES";

Run;

I'm trying to create and IF statement currently in the cell I could have

1)MON

2)MON WED THU

3)MON TUE WED THU FRI

I need the if statement to look at cell name Deposit_Pull_Schedule to see if there is a match. Since report is running from yesterday pull I would like it to look for all of THU only.

Currently it gives me all no

[Reeza]

Is the -1 in the wrong place, it should be today() -1 if you're looking from yesterday.....

But that's a wild guess because I don't fully understand what you're asking.

[BETO]

Col1                        COL2

MON                          NO

MON TUE                   NO

MON THU                  YES

I will try it thanks for quick response. Above is an example of what I'm looking for since yesterday is what I'm comparing for . I'm looking for all THU

[data_null__ · Accepted solution]

maybe

Data Test_3;
   input Deposit_Pull_Schedule $50.;
   if find(Deposit_Pull_Schedule,put(today()-1,weekdate3.),'I')
      then deliveryday="YES";
      else deliveryday="NO ";
   cards;
1)MON
2)MON WED THU
3)MON TUE WED THU FRI
;;;;
   run;

[BETO]

ThanksI tweaked it to work for me