Help using Base SAS procedures

code not missing and not populated into one line

Reply
Super Contributor
Posts: 395

code not missing and not populated into one line

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

Super User
Posts: 17,831

Re: code not missing and not populated into one line

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';

Ask a Question
Discussion stats
  • 1 reply
  • 121 views
  • 0 likes
  • 2 in conversation