Hi everyone, I have a huge dataset and i have different variables with prefix _1 to _108, and I want to reorder them by the prefix. For example, the order should be a_1, b_1 ... z_1 then a_2, b_2 ..., z_2. I used code Select name into :var_1 separated by "," from x where name like '%_1'; And Proc sql; create table xxx as select ID ,&var_1. from xx I just those codes 108 times because I do not know how to use loop to do it. And I got a result only the prefix with _10, _20, _30 ...., _90 has the correct order that I want. The log shows that the rest variables already existsz on file work.xxx. Please Help, THANKS!
... View more