DATA Step, Macro, Functions and more

How to make my data into matrix form

Reply
New Contributor
Posts: 2

How to make my data into matrix form

[ Edited ]

Hi I have a data like this

 

Product type                  Class
ama_001.tz                   Sofa
ama_012.tz                   Sofa|Chair
ama_111.tz                   Chair
ama_521.tz                   Chair|Table|Fan

and I want the output like in the MATRIX FORM

 

                 Sofa      Table     Chair     Fan
Sofa            1                         1
Table                                                   1
Chair                        1            1  
Fan                                         1 

Super User
Posts: 13,321

Re: How to make my data into matrix form

What have you tried so far?

 

Do you want a data set or a report?

 

 

Ask a Question
Discussion stats
  • 1 reply
  • 129 views
  • 1 like
  • 2 in conversation