Two Column Transpose With Duplicate ID Variables

ismahero2 — Wed, 03 Jul 2024 13:05:13 GMT

Hi,

I have this dataset with two columns, the first column is the name of the actual variables and the second column is the value for that field. I want to transpose it but I am really bad with transpose. I will appreciate some help.

This is what I have:

The first column, 'FieldNames,' has the name of the variables I want. The second column, 'FieldValues,' has the actual values for the fields in the first column. As you can see, each record for each person is every four obs.

FieldNames	FieldValues
Name	John
Height	72
Weight	190
Age	44
Name	Suzzy
Height	59
Weight	125
Age	40
Name	Stephanie
Height	60
Weight	135
Age	30
Name	Brenda
Height	59
Weight	136
Age	47

This is how I need to have the data:

Name	Height	Weight	Age
John	72	190	44
Suzzy	59	125	40
Stephanie	60	135	30
Brenda	59	136	47

Re: Two Column Transpose With Duplicate ID Variables

A_Kh — Wed, 03 Jul 2024 13:35:23 GMT

If you use proc transpose, do it twice. First transpose by Fieldnames, the second time use Fieldnames as ID. You can align variable orders in data or proc steps later.

 proc sort data=have; 
         by fieldnames;
 run; 
 proc transpose data=have out=have1;
	 var fieldvalues;
	 by fieldnames;
 run; 
 proc transpose data=have1 out=want (drop=_:);
	 var col:;
	 id fieldnames;
 run;

topic Two Column Transpose With Duplicate ID Variables in SAS Programming

Two Column Transpose With Duplicate ID Variables

Re: Two Column Transpose With Duplicate ID Variables