Date:         Sun, 30 Dec 2007 21:59:16 -0800
Reply-To:     Patrick <patrick.matter@GMX.CH>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Patrick <patrick.matter@GMX.CH>
Organization: http://groups.google.com
Subject:      Re: adding hardocded values to a list of vars in a macro variable
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

You were almost there.
Happy New Year
Patrick

data one;
input name $ age;
cards;
Iris 22
jack 29
stan 21
;
 %let lib=work;
 %let dsn=one;


proc sql noprint;
    select catt("'",name,"' 'K'") into :varlst separated by ' '
        from dictionary.columns
        where libname=%upcase("&lib") and memname=%upcase("&dsn") ;
quit;

%put &varlst;