09-17-2012 12:23 PM
Hi, I've been given a business task to code, and although in Englisgh it's simple and doable, the code in SAS is a little harder...
So I resorted to this site for the help. I'm tryin gto code this in SAS (preferably not SQL, but that's fine too):
(Ab_Flag => 3 and ID is populated and not(UN_NO > ' ' and UDD_NO is not populated))
If these conditions satisfy, then create a new flag (New_Flag = 'Yes')
Thanks for all your help..
09-17-2012 12:46 PM
You should post an example of the data you have and your expected output.
But it appears a simple criteria:
if ab_flag>3 and not missint(id) and not(not missing(un_no) and missing(udd_no)) then new_flag='Yes';