Date:         Thu, 19 Mar 2009 11:59:52 -0400
Reply-To:     Gerhard Hellriegel <gerhard.hellriegel@T-ONLINE.DE>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Gerhard Hellriegel <gerhard.hellriegel@T-ONLINE.DE>
Subject:      Re: Sorting columns

Try

proc sql noprint;
  select distinct name into :varnames separated by ' '
  from dictionary.columns
  where libname="SASHELP" & memname="CLASS";
quit;
%put &varnames;

That works, so I assume that MYLIB.MYFILE does not exist.
Gerhard





On Thu, 19 Mar 2009 08:54:39 -0700, Lonjer <j.leung3@LSE.AC.UK> wrote:

>Hi,
>
>I'm trying to sort my columns and came across the following in the
>archives...
>
>proc sql;
>  select distinct name into :varnames separated by ' '
>  from dictionary.columns
>  where libname="MYLIB" & memname="MYFILE";
>quit;
>
>
>data mylib.myfile;
>  retain &varnames;
>  set mylib.myfile;
>run;
>
>
>However I'm geting a "Warning: Apparent symbolic reference VARNAMES
>not resolved"
>
>Can someone help?
>
>Thanks,
>Jer