code not missing and not populated into one line

podarum — Mon, 17 Sep 2012 16:23:24 GMT

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..

Re: code not missing and not populated into one line

Reeza — Mon, 17 Sep 2012 16:46:07 GMT

You should post an example of the data you have and your expected output.

But it appears a simple criteria:

new_flag='No';

if ab_flag>3 and not missint(id) and not(not missing(un_no) and missing(udd_no)) then new_flag='Yes';