topic Re: How to convert the data into this looking? in SAS Programming

How to convert the data into this looking?

Feyng819 — Wed, 14 Jul 2021 14:11:06 GMT

My original data look like this:
var1 var2 var3
1 3 C

And I want to make them look like this (splitting one row of data into four rows, var2 goes under var1, the value of var1 shows one row of data with var3 and one row of data without var3)
var1 var2 var3
1 . .
1 . C
3 . .
3 . C

Thank you!!

Re: How to convert the data into this looking?

Reeza — Wed, 14 Jul 2021 14:20:18 GMT

The term is TRANSPOSE

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/

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/

@Feyng819 wrote:
My original data look like this:
var1 var2 var3
1 3 C

And I want to make them look like this (splitting one row of data into four rows, var2 goes under var1, the value of var1 shows one row of data with var3 and one row of data without var3)
var1 var2 var3
1 . .
1 . C
3 . .
3 . C

Thank you!!

Re: How to convert the data into this looking?

Feyng819 — Wed, 14 Jul 2021 14:29:41 GMT

Thank you for your help! I would like to ask that how can I get the alternative var3 value? And i tried to use transpose and my data look like
1
3
C
Im not sure if I am using the transpose correctly

Re: How to convert the data into this looking?

Reeza — Wed, 14 Jul 2021 14:36:37 GMT

@Feyng819 wrote:

Im not sure if I am using the transpose correctly

Show your code if you're not sure if your code is correct.

Re: How to convert the data into this looking?

Feyng819 — Wed, 14 Jul 2021 14:43:34 GMT

I just tried out other codes from wide to long and it works! Thank you for your help