Hello,

I have a data something like below however I would like to select 20 random ICD9 codes and 15 random ICD10 codes in my report. Here is the data looks like

Patient ID Code type     Code
100         ICD9     V320
100         ICD10     E321
100         ICD9     V322
100         ICD9     V323
200         ICD9     V324
200         ICD10     E325
300         ICD9     V326
300         ICD9     V327
300         ICD9     V328
300         ICD9     V329
400         ICD10     E330

All I am looking for is 20 random patients for ICD9 code type and 15 random patients for ICD10 codes it will be great if all 35 patients are distinct.

Any help will be greatly appreciated.

Thanks.

This might work however i need random records for specific code type ICD9/ICD10 that is where I am struck at.