topic Re: How to transpose 1 column in to 2 columns keeping all other as it is? in SAS Programming

How to transpose 1 column in to 2 columns keeping all other as it is?

yogita_patel — Tue, 24 Dec 2024 22:59:55 GMT

I would like to transpose column sord only. here is the sample data below.

I tried using ID statement. but other columns are also getting transpose.

Re: How to transpose 1 column in to 2 columns keeping all other as it is?

PaigeMiller — Tue, 24 Dec 2024 23:17:47 GMT

I cannot imagine what this data set would look like if SORD is split into 2 columns but the other column stay as they are. Please show us.

Also, please take a step back and describe the real problem that this is related to, without reference to SAS or Excel or transforming this data. Most likely, your boss or professor wants you to solve a real problem, they didn't say transform this matrix, they asked you to solve a real problem. What is that real problem?

Also, we prefer data presented as working SAS data step code (examples and instructions). We can't really work with data in screen captures.

Re: How to transpose 1 column in to 2 columns keeping all other as it is?

Tom — Tue, 24 Dec 2024 23:25:03 GMT

Not sure what you mean by transpose.

If you want to make another variable that has the same values as SORD then a simple assignment statement will work.

data want;
  set have;
  sord2 = sord;
run;

But why?

Re: How to transpose 1 column in to 2 columns keeping all other as it is?

Ksharp — Wed, 25 Dec 2024 01:55:51 GMT

That would be better if you post desired output.
If you just want split column sord into two columns ,that is easy:

data want;
set have;
if sord=1 then sord1=1;
if sord=2 then sord2=2;
run;