Renaming all your variables does not necessarily have to be that much of a hassle. The following code gives an example of how you could use metadata to flip "_het" to "het_" for many variables. It would have to adapted to the particulars of your data, probably, but this should give you an idea. data have;
retain a_het xx_het zdfe_het b_het a234_het 0;
x = 1;
run;
proc sql;
SELECT catx('=', name, prxchange('s/(\w{1,28})(_)(het)/\3\2\1/i', -1, strip(name))) INTO :renameMe SEPARATED BY ' '
FROM sashelp.vcolumn
WHERE libname = 'WORK' AND
memname = 'HAVE' AND
prxmatch('/_het$/i', strip(name)) > 0;
quit;
data want;
set have;
rename &renameMe;
run;
... View more
