I have situation like recode id or some other variables whcih could be in
first column or any other positions, after recoding, I wish them stay in the
position where they were. For example, ID = substr(subjectid, 3,4). Here
subjectid is in the first column, however ID goes to the right most column,
what I realy want is to drop subjectid and put ID in the colum where
subjectid used to be. Is there any way to do it? I have over a hundred
vars, retain is certainly not practical, any suggestion?