U can write a macro in sas that would do all that in one step. Sorry There are some experts here. Well I failed my last interview just bec of that question