Convert multiple columns to one column

swimmer23 — Mon, 30 Jan 2023 16:47:50 GMT

Hello,

I have the following dataset (here is an excerpt from it):

I want to convert the dataset shown above into the following one:

Can anyone tell me what SAS command I can use to create this transpose of the data?

Thank you in advance for your support.

Re: Convert multiple columns to one column

Reeza — Mon, 30 Jan 2023 16:53:30 GMT

Have you tried PROC TRANSPOSE?

https://stats.oarc.ucla.edu/sas/modules/how-to-reshape-data-wide-to-long-using-proc-transpose/

proc transpose data=have out=want;
by product_category;
run;