Count distinct values by subjects

[Neff]

I have this large data set comprising of over 1000 subjects and about 3000 variables which are ICD9 codes (Dx1- Dx3000). 

Dx represents the ICD diagnosis codes for each visit and is represented here as  1-4

My dataset looks similar to this:

 

I would like to get the distinct disease count for each subject.

For example: subject 1 has 4 visits but 3 distinct diagnosis.

                      subject 2 has 4 visits and 4 distinct diagnosis

Thanks.

[Neff]

I have this large data set comprising of over 1000 subjects and about 3000 variables which are ICD9 codes (Dx1- Dx3000). 

Dx represents the ICD diagnosis codes for each visit and is represented here as  1-4

My dataset looks similar to this:

 

I would like to get the distinct disease count for each subject.

For example: subject 1 has 4 visits but 3 distinct diagnosis.

                      subject 2 has 4 visits and 4 distinct diagnosis

Thanks.

[novinosrin · Accepted solution]

1. proc transpose

2. proc freq by id

[PGStats]

proc transpose data=myData out=codes;
by id;
var dx1-dx3000;
run;

proc sql;
create table counts as
select id, count(distinct col1) as nbCodes
from codes
group by id;
quit;

(untested)

[Neff]

Thank you so much!! Just what I needed and it worked perfectly well