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.