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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.