DATA TRANSPOSE IN SAS

[Harish2]

HI team,

I have the table called Customer and data looks like this.

Customer
_TEMA001	PIUM_PCCC	PIUM_PCCD
VV	1	Provider Comprehensive SURS Review
VV	4	MCO Review Outcome Accuracy
VV	7	Beneficiary Death
VV	2	Algorithm Limited Review
VV	5	State-Directed Recovery
VV	8	Provider Death
VV	3	DRA Attestation
VV	6	Excluded Entity
VV	9	Prepayment Review

I need the output of this customer

table into below format by using Proc Transpose.

Output
VV	PIUM_PCCC	1	PIUM_PCCD	Provider Comprehensive SURS Review
VV	PIUM_PCCC	4	PIUM_PCCD	MCO Review Outcome Accuracy
VV	PIUM_PCCC	7	PIUM_PCCD	Beneficiary Death
VV	PIUM_PCCC	2	PIUM_PCCD	Algorithm Limited Review
VV	PIUM_PCCC	5	PIUM_PCCD	State-Directed Recovery
VV	PIUM_PCCC	8	PIUM_PCCD	Provider Death
VV	PIUM_PCCC	3	PIUM_PCCD	DRA Attestation
VV	PIUM_PCCC	6	PIUM_PCCD	Excluded Entity
VV	PIUM_PCCC	9	PIUM_PCCD	Prepayment Review

Please help me to do this by using Proc Transpose.

Thanks,

Harish

[Kurt_Bremser]

You do not transpose anything, you just add two columns with fixed content. That needs only a data step.