Return to Archive

SAS Tip of the Month
July 2003

If it is necessary to convert a unique list of values, separated by a space, within a variable to a macro parameter here is a piece of SAS code that will do this using SQL:

   PROC SQL;
      SELECT DISTINCT var
         INTO :macrovar SEPARATED BY ' '
         FROM dset1
         WHERE var1 IS NOT MISSING;
      QUIT;
   RUN;