Hello,
I have the following dataset (here is an excerpt from it):
product_category | part1 | part2 | part3 | part4 |
hose_connector | connector1 | connector2 | connector3 | connector4 |
printer | printer1 | printer2 | printer3 | printer4 |
glasses | glasses1 | glasses2 | glasses3 | glasses4 |
I want to convert the dataset shown above into the following one:
hose_connector | connector1 |
hose_connector | connector2 |
hose_connector | connector3 |
hose_connector | connector4 |
printer | printer1 |
printer | printer2 |
printer | printer3 |
printer | printer4 |
glasses | glasses1 |
glasses | glasses2 |
glasses | glasses3 |
glasses | glasses4 |
Can anyone tell me what SAS command I can use to create this transpose of the data?
Thank you in advance for your support.