https://communities.sas.com/t5/SAS-Programming/How-to-make-my-data-into-matrix-form/m-p/444782#M111404 <P>What have you tried so far?</P> <P>&nbsp;</P> <P>Do you want a data set or a report?</P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 12 Mar 2018 14:57:01 GMT ballardw 2018-03-12T14:57:01Z https://communities.sas.com/t5/SAS-Programming/How-to-make-my-data-into-matrix-form/m-p/444629#M111381 <P>Hi I have a data like this</P> <P>&nbsp;</P> <P>Product type&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Class<BR />ama_001.tz&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Sofa<BR />ama_012.tz&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Sofa|Chair<BR />ama_111.tz&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Chair<BR />ama_521.tz&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Chair|Table|Fan<BR /><BR />and I want the output like in the MATRIX FORM</P> <P>&nbsp;</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Sofa&nbsp; &nbsp; &nbsp; Table&nbsp; &nbsp; &nbsp;Chair&nbsp; &nbsp; &nbsp;Fan<BR />Sofa&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1<BR />Table&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1<BR />Chair&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp;&nbsp;<BR />Fan&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp;</P> Mon, 12 Mar 2018 13:18:56 GMT https://communities.sas.com/t5/SAS-Programming/How-to-make-my-data-into-matrix-form/m-p/444629#M111381 Sunny4 2018-03-12T13:18:56Z https://communities.sas.com/t5/SAS-Programming/How-to-make-my-data-into-matrix-form/m-p/444782#M111404 <P>What have you tried so far?</P> <P>&nbsp;</P> <P>Do you want a data set or a report?</P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 12 Mar 2018 14:57:01 GMT https://communities.sas.com/t5/SAS-Programming/How-to-make-my-data-into-matrix-form/m-p/444782#M111404 ballardw 2018-03-12T14:57:01Z