topic Wide to Long Dataset in New SAS User

Wide to Long Dataset

JJ_83 — Wed, 24 Mar 2021 15:36:32 GMT

I have this wide dataset structure.

data have;
	input ID 7. CO2 Methane N2O HFC;
	datalines;
1004377 54 28 54 30
1000112 88 40 72 1
;

And I want this long dataset structure.

data want;
	input ID 7. Substance $ Amount;
	datalines;
1004377 CO2     54
1004377 Methane 28
1004377 N2O     54
1004377 HFC     30
1000112 CO2     88
1000112 Methane 40
1000112 N2O     72
1000112 HFC     1
;

I'm sure there is an easy way to do this, but can't figure it out. Ideas?

Re: Wide to Long Dataset

Reeza — Wed, 24 Mar 2021 15:38:24 GMT

Transposing data tutorials:
Wide to Long:
https://stats.idre.ucla.edu/sas/modules/how-to-reshape-data-wide-to-long-using-proc-transpose/

https://stats.idre.ucla.edu/sas/modules/reshaping-data-wide-to-long-using-a-data-step/

And sometimes a double transpose is needed for extra wide data sets:
https://gist.github.com/statgeek/2321b6f62ab78d5bf2b0a5a8626bd7cd

@JJ_83 wrote:

I have this wide dataset structure.
data have;
	input ID 7. CO2 Methane N2O HFC;
	datalines;
1004377 54 28 54 30
1000112 88 40 72 1
;
And I want this long dataset structure.
data want;
	input ID 7. Substance $ Amount;
	datalines;
1004377 CO2     54
1004377 Methane 28
1004377 N2O     54
1004377 HFC     30
1000112 CO2     88
1000112 Methane 40
1000112 N2O     72
1000112 HFC     1
;
I'm sure there is an easy way to do this, but can't figure it out. Ideas?

Re: Wide to Long Dataset

mklangley — Wed, 24 Mar 2021 15:45:27 GMT

proc transpose data=have out=want (rename=(_name_=substance col1=amount));
    by id notsorted;
run;

Re: Wide to Long Dataset

JJ_83 — Wed, 24 Mar 2021 15:57:23 GMT

I knew it was something simple. Thank you!

Re: Wide to Long Dataset

JJ_83 — Wed, 24 Mar 2021 15:57:36 GMT

Thank you!