topic Re: Transpose data from long to wide in SAS Programming

Transpose data from long to wide

DipuRahman — Wed, 09 Jun 2021 17:49:20 GMT

Hey everyone.

Need help with transposing data from long to wide. Here is the data I have:

pump_number	adj_cycle_number	cycle_up_slope	cycle_down_slope	target
11	1	1843.61	-3894.3	fail
11	2	2055.37	-4053.6	fail
11	3	2154.83	-4212.41	fail
12	1	2132.037	-2704.71	pass
12	2	2139.293	-2855.92	pass
12	3	2232.83	-4663.27	pass

This is what I need:

pump_number	cycle_up_slope1	cycle_up_slope2	cycle_up_slope3	cycle_down_slope1	cycle_down_slope2	cycle_down_slope3	target
11	1843.61	2055.37	2154.83	-3894.3	-4053.6	-4212.41	fail
12	2132.037	2139.293	2232.83	-2704.71	-2855.92	-4663.27	pass

Can you help?

Thanks!

Dipu

Re: Transpose data from long to wide

Reeza — Wed, 09 Jun 2021 17:54:40 GMT

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

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

Both of these have examples for exactly your situation.

The data step lets you do it in one step, the transpose is multiple steps but easier to understand for beginners in my opinion.

If you have issues getting it to work feel free to post your code.

@DipuRahman wrote:

Hey everyone.

Need help with transposing data from long to wide. Here is the data I have:

pump_number adj_cycle_number cycle_up_slope cycle_down_slope target

11 1 1843.61 -3894.3 fail

11 2 2055.37 -4053.6 fail

11 3 2154.83 -4212.41 fail

12 1 2132.037 -2704.71 pass

12 2 2139.293 -2855.92 pass

12 3 2232.83 -4663.27 pass

This is what I need:

pump_number cycle_up_slope1 cycle_up_slope2 cycle_up_slope3 cycle_down_slope1 cycle_down_slope2 cycle_down_slope3 target

11 1843.61 2055.37 2154.83 -3894.3 -4053.6 -4212.41 fail

12 2132.037 2139.293 2232.83 -2704.71 -2855.92 -4663.27 pass

Can you help?

Thanks!

Dipu

Re: Transpose data from long to wide

novinosrin — Wed, 09 Jun 2021 17:58:23 GMT


data have;
input pump_number	adj_cycle_number	cycle_up_slope	cycle_down_slope	target $;
cards;
11	1	1843.61	-3894.3	fail
11	2	2055.37	-4053.6	fail
11	3	2154.83	-4212.41	fail
12	1	2132.037	-2704.71	pass
12	2	2139.293	-2855.92	pass
12	3	2232.83	-4663.27	pass
;

proc transpose data=have out=_have;
 by pump_number adj_cycle_number target;
 var cycle_up_slope	cycle_down_slope;
run;

proc transpose data=_have out=want(drop=_name_);
 by pump_number target;
 var col1;
 id _name_ adj_cycle_number;
run;

Re: Transpose data from long to wide

DipuRahman — Wed, 09 Jun 2021 18:12:06 GMT

@Reeza Thank you.

Re: Transpose data from long to wide

DipuRahman — Wed, 09 Jun 2021 18:14:50 GMT

Thanks you