topic Transpose Wide to Long in SAS Programming

Transpose Wide to Long

mcook — Wed, 08 Jul 2020 21:26:49 GMT

I have a table with variables:

Item N Mean n_A n_B n_C n_D n_0 n_1 n_2 n_3 n_4 PVal pBis

I want to get it to the form with variables:

Item Stats N Value

Where Stats is broken up into 4 different rows. N, pBis, PVal, Mean. and Value gives the value of those stats.

such as...

Item Stats Nd Value

A1 N 100 100

A1 pBis 100 0.4

A1 PVal 100 0.28

A1 Mean 100 0.56

B1 N 150 150

B1 pBis 150 0.31

B1 PVal 150 0.46

B1 Mean 150 0.46

C1 ............

etc.

mcook — Wed, 08 Jul 2020 21:31:57 GMT

I have reason to believe that a data step with 4 output statements could be used.

ballardw — Wed, 08 Jul 2020 22:29:17 GMT

I can "guess" that perhaps n_A is supposed to be an n associated with something like A but what are n_0 n_1 and so on?

And if there is an A1 I tend to suspect there may be an A2, A3 or such lurking somewhere.

You might consider providing a data step that actually gives us some values to work with.