BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
UMR13
Calcite | Level 5

Hello,  I am having an issue figuring out how to do this on SAS. I have provided a picture below

 

MC3-1 are different months of completion. I need the latest month of completion which would be MC3 if it has a month, MC2 if MC3 is missing and MC1 if MC3 and MC2 are missing. 

 

What would be the simplest way of doing this? 

 

Thank you.

 

Capture.PNG

1 ACCEPTED SOLUTION
1 REPLY 1