Help using Base SAS procedures

Proc transpose long to wide for patient data?

Reply
N/A
Posts: 1

Proc transpose long to wide for patient data?

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 numberPatient Iddiagnosis1
11600
21700
31800
42600
52700
63600
73700
84600
94700

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

Thank you for your help!

Trusted Advisor
Posts: 1,131

Re: Proc transpose long to wide for patient data?

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

Thanks,
Jag
Ask a Question
Discussion stats
  • 1 reply
  • 156 views
  • 0 likes
  • 2 in conversation