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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.