topic If And Then in SAS Procedures

If And Then

BETO — Fri, 11 Jan 2013 20:29:54 GMT

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

Re: If And Then

Reeza — Fri, 11 Jan 2013 20:36:29 GMT

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.

Re: If And Then

data_null__ — Fri, 11 Jan 2013 20:38:53 GMT

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;

Re: If And Then

BETO — Fri, 11 Jan 2013 20:41:27 GMT

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

Re: If And Then

BETO — Fri, 11 Jan 2013 20:54:33 GMT

ThanksI tweaked it to work for me