BookmarkSubscribeRSS Feed
Tammie
Calcite | Level 5

I am trying to figure out what procedure I need to use ... I have a database of emerg patients, and it contains their diagnosis, severity levels 1-5, and admission status.  I need to identify the top 10 diagnosis by volume, include their distribution of severity level, with a percent admission by diagnosis and percent admission by total volume of emerg patients.  It's the top 10 that is really stumping me.... any suggestions?

Thanks a million.

1 REPLY 1
LinusH
Tourmaline | Level 20

Without digging to deep into your requirement, PROC RANK will help you rank your top ten.

If your rank is based on a simple frequency count of contributing records, PROC FREQ/SUMMARY/SQL could do the trick.

Data never sleeps

Catch up on SAS Innovate 2026

Nearly 200 sessions are now available on demand with the SAS Innovate Digital Pass.

Explore Now →
What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1429 views
  • 0 likes
  • 2 in conversation