Swap values row wise

pavank — Mon, 16 Sep 2024 04:14:19 GMT

Input values ;
Cards
12 33 56 77 99;
run
Q.) swap 33 and 77 values remaining keep same
Output
12 77 56 33 99

Re: Swap values row wise

Patrick — Mon, 16 Sep 2024 04:30:23 GMT

If that's not just an "academic" question then you will likely need to provide more information to get a suitable answer.

Please also provide a fully working data step that creates the have data and show us the desired result so we understand if that's about switching values between variables on a single row or if it is about swapping rows.

Variable swap:

data have;
  infile datalines dlm=' ';
  input var1-var5;
  _v=var2;
  var2=var4;
  var4=_v;
  drop _v;
Cards;
12 33 56 77 99
;
run;

proc print data=have;
run;

Row swap:

data have;
  infile datalines dlm=' ';
  input var @@;
Cards;
12 33 56 77 99
;
run;

data want;
  do _i=1,4,3,2,5;
    set have point=_i;
    output;
  end;
  stop;
run;

proc print data=want;
run;

topic Re: Swap values row wise in SAS Programming

Swap values row wise

Re: Swap values row wise