topic Re: Transposing with correct naming convention in SAS Programming

Transposing with correct naming convention

rosegarden81 — Tue, 16 Oct 2018 03:35:58 GMT

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

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

Re: Transposing with correct naming convention

novinosrin — Tue, 16 Oct 2018 03:33:42 GMT

No values to transpose?

Re: Transposing with correct naming convention

rosegarden81 — Tue, 16 Oct 2018 03:37:05 GMT

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

Want:

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

Re: Transposing with correct naming convention

novinosrin — Tue, 16 Oct 2018 03:38:47 GMT


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;

Re: Transposing with correct naming convention

Reeza — Tue, 16 Oct 2018 04:05:01 GMT

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.