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

moreilly — Sat, 25 Mar 2017 00:34:52 GMT

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

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

art297 — Sat, 25 Mar 2017 01:14:22 GMT

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

topic How to count the frequency of a value by unique ID's in SAS Programming

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

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