how to reorder the variables sequence

shiyiming

data a;
input   _1_x     _2_y     _1_t    _5_r    _1_abc...;
cards;
....
;
run;
there are many variables in a started with '_'+number.
question:
how can I reorder the variables by following sequence:
_1_abc _1_t  _1_x   _2_y  _5_r ........

thx!!!

shiyiming

用Retain

shiyiming

建议事先将表结构定义清楚。

shiyiming

参考[url:mtuw8fb2]http://support.sas.com/kb/8/395.html[/url:mtuw8fb2]

shiyiming

[code:3qsaw9js]
/*Select variables by order of default (alphabetic)*/
ods output Variables=vars(keep=Variable);ods listing close;proc contents  data=&yourdata; run;  ods listing;
/*Read into a mv*/
proc sql noprint;select Variable into :VarList separated by ' ' from vars where Variable like '_%';quit;
/*Reorder variables according to MV*/
data &yourdata;retain &VarList;set &yourdata;run;[/code:3qsaw9js]
We may think about if reordering variables is necessary or not.
JingJu

shiyiming

mark