Hi @DonH  thanks for the explanations.  I understood that the hash objects are tables, my main issue was the if-statement. The key was this sentence:   The check method returns 0 if it is found and returns a non-zero value if not. So this is subsetting the data to just those that were never a pre-account. 🙂 ... View more

@Emjay  If I would pay somebody to read their content, Guru is right up there. Let me also add my thanks to yours.    @data_null__  Guru thankkkkkkkkkkkkkkkkkkkkkkkk youuuuuuuuuuuuuuuuuuuuuuuuuuuu!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!  as always ... View more

I've seen this format approach in if-statements but I never understood the benefit.   What would be the reason to rather write:   proc format; value KBZ2range (FUZZ=0) low-1 = "valid" 1<-2 = "nv" 2<-3 = "valid" 3<-4 = "nv" 4<-5 = "valid" 5<-high = "nv"; quit; data foo; set have; if put(KBZ,KBZ2range.)='valid' then check='yes'; else check='no'; run; Instead of:   data foo2; set have; if (KBZ<=1 or 2<KBZ<=3 or 4<KBZ<=5) then check='yes'; else check='no'; run; A lot of extra typing... ... View more

Wow, thanks for the quick help! ... View more