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
maybe
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.
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
maybe
ThanksI tweaked it to work for me
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.