Hi All Another question is that if I want to find all HouseNo that DO NOT have any member with Age>50, how do I do so? Thank you ... View more

Thanks for all the helpful comments. But now I notice that I have some records with Age=. So now I want age that are also 0=<AGE<12. Thanks ... View more

proc sql;   select distinct HouseNo     from have       where Age gt 50   ; quit; Hi This code works. But if I have a even more complicated dataset like the below: House No Person No Age Item Code 1 1 12 01 1 1 12 02 1 2 21 03 1 2 21 04 2 1 15 01 2 2 45 05 2 3 50 06 And I want the distinct House No and the Person No who meets the Age criteria and his Age, how do I modify the code? Remember for each distinct House No & Person No, he can have multiple records due to the different Item Code. Thank you ... View more

data a ;   length apple orange $32 ;   input apple orange ;   char = apple < orange ;   num = input(apple,32.) < input(orange,32.) ;   put (_all_) (=); cards; 1 2 11 2 1E20 200 run; apple=1 orange=2 char=1 num=1 apple=11 orange=2 char=1 num=0 apple=1E20 orange=200 char=1 num=0 Thank you everybody for the helpful comments. But regarding the given code, I don't understand char = apple < orange ;   num = input(apple,32.) < input(orange,32.) ;   put (_all_) (=); cards; 1 2 11 2 1E20 200 ... View more

data XXX; set YYY; if Apple<Orange then Test='Y'; if Apple=Orange then Test='Equal'; if Apple>Orange then Test='N'; run; Why instead of showing 'Equal' SAS shows 'E'? Thank you ... View more

Thanks for the reply. But I don't understand how SAS read range for character variable format. "'3' is smaller than '30' since ' ' (space) comes before '0' ." I don't understand. Can someone explain things more clearly so I won't make the same mistake? Thank you a lot! ... View more

table var='Text to display', n; What is n? Thanks ... View more

I don't understand. Where am I supposed to state the new names in the code? I need it for Proc Freq Thanks ... View more