Updated   Hi! Suppose I have dataset as followings   ID SEX    RACE                                      AGE  1   F       Non-hispanic White                 5-15 2   M      Asian/Other                              5-15 3   M      Asian/Other                             15-20 4   F       Hispanic                                  15-20 5   M      Hispanic                                  15-30  6   M     Non-hispanic Black                  25-30   I want to create a table as following      5-15 15-20 25-30 Sex       Male 50% 66.6% 100% Female 50% 33.3% 0 Race        Non-Hispanic White 50% 0 0 Non-Hispanic Black 0 0 100% Hispanic 0 66.6% 0 Asian/Other 50% 33.3% 0   I know how to use proc sql without sub-section age group but is there a way to aggregate all age sections in one step? Thanks! ... View more

Suppose I have a dataset looks like the following:   ID .     age  MED1    MED2    MED3 001 .     1      1055        7832    3435 202 .      0     1051        3423    3455 204 .      3      5040         3423 .  3444 213 .       4     9999        3432 .  4546   Each patient has three prescriptions and each has a code comes with it. I want to see if patients age less than 5 have prescription MED1-MED3 in code (7832, 3435, 1051).  I used proc sql the following but it gave me the same dataset.  PROC SQL; CREATE TABLE WANT AS SELECT * FROM MEDS WHERE MED1 OR MED2 OR MED3 IN (7832, 3455, 1051) AND AGE <= 5; QUIT; How can I correct this? Thanks.  ... View more