Proc transpose long to wide for patient data?

[megpryor4]

Hello:

I have a data set of professional claims data for patients. It is at the claims level data rather than the patient ID level. For example:

Cla

Claim number	Patient Id	diagnosis1
1	1	600
2	1	700
3	1	800
4	2	600
5	2	700
6	3	600
7	3	700
8	4	600
9	4	700

I want to make it at the Patient ID level instead.

Thank you for your help!

[Jagadishkatam]

Please try,

proc sort data=have;

by patient_id;

run;

proc transpose data=have;

by patient_id;

id claim_number;

var diagnosis1;

run;

Thanks,

Jag