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?

Thanks,

Tong