https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/Help-with-Transposing-my-Dataset/m-p/76297#M1707 Hi,<BR /> <BR /> I have a dataset as below<BR /> <BR /> ID VI HGT WGT<BR /> 10 1 40 100<BR /> 10 2 41 104<BR /> 11 2 32 202<BR /> <BR /> I would like to transpose this as hgt and wgt to the left and headers<BR /> be unique ID,VI. Basically something like this below should rescue me.<BR /> I'm not sure if this is possible.<BR /> <BR /> 10-1 10-2 11-2<BR /> HGT 40 41 32<BR /> WGT 100 104 202<BR /> <BR /> <BR /> I used basic transposing so far and couldn't find an example for<BR /> something like this any where else. <BR /> <BR /> Appreciate your Help...<BR /> <BR /> Regards,<BR /> Eddie Tue, 20 Oct 2009 21:58:19 GMT deleted_user 2009-10-20T21:58:19Z https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/Help-with-Transposing-my-Dataset/m-p/76297#M1707 Hi,<BR /> <BR /> I have a dataset as below<BR /> <BR /> ID VI HGT WGT<BR /> 10 1 40 100<BR /> 10 2 41 104<BR /> 11 2 32 202<BR /> <BR /> I would like to transpose this as hgt and wgt to the left and headers<BR /> be unique ID,VI. Basically something like this below should rescue me.<BR /> I'm not sure if this is possible.<BR /> <BR /> 10-1 10-2 11-2<BR /> HGT 40 41 32<BR /> WGT 100 104 202<BR /> <BR /> <BR /> I used basic transposing so far and couldn't find an example for<BR /> something like this any where else. <BR /> <BR /> Appreciate your Help...<BR /> <BR /> Regards,<BR /> Eddie Tue, 20 Oct 2009 21:58:19 GMT https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/Help-with-Transposing-my-Dataset/m-p/76297#M1707 deleted_user 2009-10-20T21:58:19Z https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/Help-with-Transposing-my-Dataset/m-p/76298#M1708 To me, it looks more like a report rather something you would like to store i a table.<BR /> Maybe you could try PROC TABULATE, it'll let you be quite free on where to put your data in a matrix.<BR /> <BR /> /Linus Mon, 02 Nov 2009 13:49:08 GMT https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/Help-with-Transposing-my-Dataset/m-p/76298#M1708 LinusH 2009-11-02T13:49:08Z https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/Help-with-Transposing-my-Dataset/m-p/76299#M1709 1. create new variable idvi to concatenate ID and VI, ie a variable with values like 10-1, 11-2<BR /> 2.proc transpose / var hgt wgt /id idvi Wed, 04 Nov 2009 17:10:16 GMT https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/Help-with-Transposing-my-Dataset/m-p/76299#M1709 abdullala 2009-11-04T17:10:16Z