data neworder_retain; retain Name Age Sex Weight Height; set sashelp.class; run; proc print data=neworder_retain(obs=10); title1 "SASHELP.CLASS using RETAIN for reordering"; title3 "[No side effects]"; run; proc export data=neworder_retain dbms=excel replace outfile="c:\temp\dinosaur\reordervars.xls"; sheet="Retain"; run;