Reorder SAS variables

[hhchenfx]

Hi Everyone,

I have a data file like

data have;

input var x_1 x_3 x_bac x_1dnx b ;

datalines;

0 1 1 1 1 0

;

run;

I want to put all X_ to the end, since there are hundred of X_ variable and they follow no rule other than the prefix of X_, is there any way to do it quicky?

Thank you,

HHC

[data_null__ · Accepted solution]

data reorder;
   if 0 then set have(drop=x_:);
   set have;
   run;

[PeterClemmensen]

@data_null__ very cool solution 🙂

Just to understand, when we use the if 0 trick, we make sure that whatever follows is only done in compilation right?

[data_null__]

---

@PeterClemmensen wrote:

@data_null__ very cool solution 🙂

Just to understand, when we use the if 0 trick, we make sure that whatever follows is only done in compilation right?

---

Correct.

[hhchenfx]

Hi Data_null_,
Interesting indeed!
But what does the "if 0" do to the code?
Thank you,
HHC

[data_null__]

---

@hhchenfx wrote:
Hi Data_null_,
Interesting indeed!
But what does the "if 0" do to the code?
Thank you,
HHC

---

http://support.sas.com/documentation/cdl/en/lrcon/65287/HTML/default/viewer.htm#p1d61passkeqo0n1jdn0...

It is an expression that is FALSE preventing the SET statement from being executed.  The SET statement is compiled which places variables in the PDV in the desired order.

[hhchenfx]

Thank you for your help!

HHC