https://communities.sas.com/t5/SAS-Programming/Wide-to-Long/m-p/666400#M199374 <P>Hi All,</P> <P>I have a dataset below that I would like to transpose from wide to long format. I've always struggled with getting proc transpose to do what I envision but thinking that proc transpose can't handle this request. I have many other measurements and time periods so hopefully there is some method out there that can handle more than what I am presenting here in the data.</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">data have; input id approach diet time1 measure1_1 measure2_1 $ time2 measure1_2 measure2_2 $ time3 measure1_3 measure2_3 $; cards; 1 1 1 10 5 water 85 10 water 100 103 water 2 2 2 12 5 protein 92 11 water 102 103 water ; run;<BR /><BR />data want;<BR />input id approach diet time measure1 measure2 $;<BR />cards;<BR />1 1 1 10 5 water<BR />1 1 1 85 10 water<BR />1 1 1 100 103 water<BR />2 2 2 12 5 protein<BR />2 2 2 92 11 water<BR />2 2 2 102 103 water<BR />;<BR />run;</CODE></PRE> Wed, 01 Jul 2020 14:59:20 GMT PeterBr 2020-07-01T14:59:20Z https://communities.sas.com/t5/SAS-Programming/Wide-to-Long/m-p/666400#M199374 <P>Hi All,</P> <P>I have a dataset below that I would like to transpose from wide to long format. I've always struggled with getting proc transpose to do what I envision but thinking that proc transpose can't handle this request. I have many other measurements and time periods so hopefully there is some method out there that can handle more than what I am presenting here in the data.</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">data have; input id approach diet time1 measure1_1 measure2_1 $ time2 measure1_2 measure2_2 $ time3 measure1_3 measure2_3 $; cards; 1 1 1 10 5 water 85 10 water 100 103 water 2 2 2 12 5 protein 92 11 water 102 103 water ; run;<BR /><BR />data want;<BR />input id approach diet time measure1 measure2 $;<BR />cards;<BR />1 1 1 10 5 water<BR />1 1 1 85 10 water<BR />1 1 1 100 103 water<BR />2 2 2 12 5 protein<BR />2 2 2 92 11 water<BR />2 2 2 102 103 water<BR />;<BR />run;</CODE></PRE> Wed, 01 Jul 2020 14:59:20 GMT https://communities.sas.com/t5/SAS-Programming/Wide-to-Long/m-p/666400#M199374 PeterBr 2020-07-01T14:59:20Z https://communities.sas.com/t5/SAS-Programming/Wide-to-Long/m-p/666408#M199381 <P>The %UNTRANSOPSE macro does exactly what you want.</P> <P><A href="https://support.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2018/2419-2018.pdf" target="_blank">https://support.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2018/2419-2018.pdf</A></P> <P>&nbsp;</P> <P>The command shown on page 3 is analogous to your problem and ought to work.</P> Wed, 01 Jul 2020 15:25:02 GMT https://communities.sas.com/t5/SAS-Programming/Wide-to-Long/m-p/666408#M199381 PaigeMiller 2020-07-01T15:25:02Z https://communities.sas.com/t5/SAS-Programming/Wide-to-Long/m-p/666530#M199447 <P>Works well, thanks for sharing!</P> Thu, 02 Jul 2020 02:55:29 GMT https://communities.sas.com/t5/SAS-Programming/Wide-to-Long/m-p/666530#M199447 PeterBr 2020-07-02T02:55:29Z