topic Re: Data transformation from rows to columns in SAS Programming https://communities.sas.com/t5/SAS-Programming/Data-transformation-from-rows-to-columns/m-p/180157#M34435 <HTML><HEAD></HEAD><BODY><P>If this is a question about JMP, you should post it to the JMP User Community at </P><P></P><P><A href="http://community.jmp.com/" title="http://community.jmp.com/">Welcome | JMP User</A></P><P></P><P>PG</P></BODY></HTML> Fri, 29 Aug 2014 20:14:56 GMT PGStats 2014-08-29T20:14:56Z Data transformation from rows to columns https://communities.sas.com/t5/SAS-Programming/Data-transformation-from-rows-to-columns/m-p/180156#M34434 <HTML><HEAD></HEAD><BODY><P>Hello, </P><P></P><P>I have a txt file that gives me the data as shown below, but even I try to import it into SAS JMP it only gave me two columns with the data. I'll like to know if there is&nbsp; a way to use the first column as the column name and the second part after ":" as my data it self. I have multiple files and once I'm able to rearrange the data I'll concatenate them row after row.</P><P></P><P>Data from .txt:</P><P></P><P>Comment:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>Operator:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>BD:&nbsp;&nbsp;&nbsp;&nbsp; D_C</P><P>TS:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2014-05-02T05:22:08.3119997</P><P>CFile:&nbsp;&nbsp;&nbsp;&nbsp; C_2014_04_24-11_30_39_M2.ini</P><P>File:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20140423-PRD.ini</P><P>LTemp: 23.0</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">FCW:&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></P><P>I <X>:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -0.00047565</X></P><P>eta [%]:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NaN</P><P>M A [m2]:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.65300</P><P></P><P>This is how I'll like to see it...</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="781"><TBODY><TR><TD class="xl63" height="20" width="79">Comment:</TD><TD width="64">Operator:</TD><TD width="64">BD:</TD><TD width="126">TS:</TD><TD width="64">Cfile:</TD><TD width="64">File:</TD><TD width="64">Ltemp: </TD><TD width="64">FCW:</TD><TD width="64">I<X></X></TD><TD width="64">eta[%]</TD><TD width="64">M A [m2]</TD></TR><TR><TD>D_C</TD><TD>2014-05-02T05:22:08.3119997</TD><TD>C_2014_04_24-11_30_39_M2.ini</TD><TD>20140423-PDR.ini</TD><TD align="right">23</TD><TD>NaN</TD><TD align="right">0.653</TD></TR></TBODY></TABLE><P></P><P>Thank you</P></BODY></HTML> Fri, 29 Aug 2014 16:54:21 GMT https://communities.sas.com/t5/SAS-Programming/Data-transformation-from-rows-to-columns/m-p/180156#M34434 Alonso 2014-08-29T16:54:21Z Re: Data transformation from rows to columns https://communities.sas.com/t5/SAS-Programming/Data-transformation-from-rows-to-columns/m-p/180157#M34435 <HTML><HEAD></HEAD><BODY><P>If this is a question about JMP, you should post it to the JMP User Community at </P><P></P><P><A href="http://community.jmp.com/" title="http://community.jmp.com/">Welcome | JMP User</A></P><P></P><P>PG</P></BODY></HTML> Fri, 29 Aug 2014 20:14:56 GMT https://communities.sas.com/t5/SAS-Programming/Data-transformation-from-rows-to-columns/m-p/180157#M34435 PGStats 2014-08-29T20:14:56Z