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

[yogita_patel]

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.

[PaigeMiller]

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.

[Tom]

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?

[Ksharp]

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;