Transposing with correct naming convention

[rosegarden81]

Hello guys,

I have data like this below. I want it in the format in the second table below. My current code is as simple as below. Is there any way of creating transposed variables like Desc_A, Desc_B instead of Desc_1, Desc_2?...

Would highly appreciate your response..

Regards

Proc transpose data = have out= data1 prefix=Desc_;

by patientID; 

var description;

run;

Have:

patientID	Description
1	A
1	B
1	C
2	A
2	TTT

Want:

patientID	Desc_A	Desc_B	Desc_C	Desc_TTT
1	1	1	1
2	1			1

OR

Want:

patientID	Desc_A	Desc_B	Desc_C	Desc_TTT
1	A	B	C
2	A			TTT

Instead of:

patientID	Desc_1	Desc_2	Desc_3	Desc_4
1
2

[novinosrin]

No values to transpose?

[rosegarden81]

Hi There, Actually, the values to be transposed are the "Description" values so it is okay to be either the exact same values as original description or it could be 1...

Want:

patientID	Desc_A	Desc_B	Desc_C	Desc_TTT
1	1	1	1
2	1			1

OR

Want:

patientID	Desc_A	Desc_B	Desc_C	Desc_TTT
1	A	B	C
2	A			TTT

[novinosrin · Accepted solution]

data have;
input patientID	Description	$;
cards;
1	A
1	B
1	C
2	A
2	TTT
;

Proc transpose data = have out= data1 prefix=Desc_;

by patientID; 

id description;
var  description;

run;

[Reeza]

Use ID statement in PROC TRANSPOSE to specify the variable to be used in the name. Use IDLABEL to specify a variable that’s the label.