How to count the frequency of a value by unique ID's

[moreilly]

All,

I am using Medicare data and trying to figure out a way to find the number of unique ids (there are several duplicate bene_ids) with one condition (back_pn_office_visit=1).  The following code for unique bene_ids works, but I can't figure out how to add the condition.  Any ideas?  Thank you! 

proc sql;
select count (distinct bene_id) as in 'n_id' from back_analysis_2013A;
quit;

where does 'back_pn_office_visit=1' go?

Monica

Monica

[art297 · Accepted solution]

Some of your syntax is off. I think you want something like:

proc sql;
  select count (distinct sex) as n_id
    from sashelp.class
      where age gt 12
  ;
quit;
 

Art, CEO, AnalystFinder.com