## If And Then

Solved
Regular Contributor
Posts: 240

# If And Then

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

Accepted Solutions
Solution
‎01-11-2013 03:38 PM
Posts: 3,852

## Re: If And Then

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;

All Replies
Super User
Posts: 23,776

## Re: If And Then

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.

Regular Contributor
Posts: 240

## Re: If And Then

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

Solution
‎01-11-2013 03:38 PM
Posts: 3,852

## Re: If And Then

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;
Regular Contributor
Posts: 240