topic Re: Proc transpose long to wide for patient data? in SAS Procedures

Proc transpose long to wide for patient data?

megpryor4 — Tue, 24 Feb 2015 21:49:14 GMT

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

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

Thank you for your help!

Jagadishkatam — Tue, 24 Feb 2015 23:15:47 GMT

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