Help using Base SAS procedures

If And Then

Accepted Solution Solved
Reply
Regular Contributor
Posts: 240
Accepted Solution

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
Respected Advisor
Posts: 3,777

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;

View solution in original post


All Replies
Super User
Posts: 17,828

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
Respected Advisor
Posts: 3,777

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

Re: If And Then

ThanksI tweaked it to work for me

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 171 views
  • 3 likes
  • 3 in conversation