Hi, My variables: ID, year, drinks(beer or wine). I want to count distinct ID by the drinks variable: only count the ID-numbers who only drank beer and those who only drank wine. If a person drank both, they should not be in any count. My code: proc sql create tables want as select year, drinks, count(distinct ID) from have group by year, drinks exit; This only count distinct within each drink-type: if a person has more than one beer he is only in the count once, but if he also had wine he is also in the count for wine. Hope someone can help me with my problem!!
... View more