Create Macro Variable from dataset column and bound by quotes

[J_CKY]

Hi,

I managed to create a macro variable that read-in from a dataset column.  However, I would like to bound those individual "cell" by quotations.

The code I used to is as follow:

*** creating dataset TABLELIST with all dataset with name begin with "_" in CC library ;
    DATA WORK.TABLELIST (KEEP=MEMNAME);
      SET SASHELP.VMEMBER
      (WHERE = (UPCASE(LIBNAME)= "CC" AND UPCASE(MEMNAME) =: '_'));
      RUN;


    PROC SQL NOPRINT;
      SELECT MEMNAME 
        INTO :TABLES SEPARATED BY " " 
      FROM WORK.TABLELIST;
      QUIT;RUN;

What I want to achieve is &tables. macro variable to be '_A' '_B' '_C' etc.

Now my code only managed to make &tables resolved as _A _B _C etc.

Thanks,

Jack

[slchen · Accepted solution]

PROC SQL NOPRINT; 
          SELECT CATS("'",MEMNAME,"'")  
            INTO :TABLES SEPARATED BY " "  
          FROM WORK.TABLELIST; 
          QUIT;

[Tom]

Double quotes are easier since you can use the QUOTE() function.  Just change MEMNAME to QUOTE(trim(MEMNAME)) in your SELECT statement.

To quote with single quotes you could use cats("'",MEMNAME,"'") instead.

[RW9]

Could I ask what you use the &TABLES. macro for later on.  Am just thinking if you have the SQL already you may be able to use that as a sub-query rather than assigning it to a macro variable.