Dear all, I have a quite simple step in my progam, where I create a macro variable which should contain values of the variable NAME (character). PROC SQL NOPRINT; SELECT DISTINCT UPCASE(name) INTO :ListOfVars SEPARATED BY "# " FROM contents; QUIT; As a result I get the values of the NAME variable sorted as => F1, F10, F11 etc. =====> List of variables : F1# F10# F11# F2# F3# F4# F5# F6# F7# F8# F9 I would like PROC SQL to create the list of values in the sequence as the values are sorted in the dataset. When adding a sorting variable VARNUM, I get the ordering I need, but also the WARNING "INTO clause specifies fewer host variables than columns listed in the SELECT clause." PROC SQL NOPRINT; SELECT DISTINCT UPCASE(name), varnum INTO :ListOfVars SEPARATED BY "# " FROM contents ORDER BY varnum; QUIT; =====> List of variables : F1# F2# F3# F4# F5# F6# F7# F8# F9# F10# F11 For the time being, I added a macro variable name also for the VARNUM to avoid the WARNING, but I was wondering, if there is a way, maybe an option to control the ordering of values? Thank you in advance, Natalie
... View more