Date:         Thu, 29 Oct 2009 16:06:40 -0400
Reply-To:     Lou <lpogoda@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Lou <lpogoda@HOTMAIL.COM>
Organization: A noiseless patient Spider
Subject:      Re: Searching variables
Comments: To: sas-l@uga.edu

"Gerhard Hellriegel" <gerhard.hellriegel@T-ONLINE.DE> wrote in message
news:200910291858.n9TGnaBD031816@malibu.cc.uga.edu...
> you can use the VCOLUMN view from the SASHELP-dictionary views:
>
> proc sql;
>  create table names as
>  select memname from sashelp.vcolumn
>  where libname="SASHELP" and upcase(name)="SEX";
> quit;
>
> Gerhard

If you're going to use PROC SQL, you may as well bypass the views and access
the dictionary tables directly, as in

proc sql;
   create table names as
      select memname from dictionary.columns
      where libname = "SASHELP" and upcase(name) = "SEX";
quit;






>
>
>
>
> On Thu, 29 Oct 2009 14:48:43 -0400, Sid N <nsid31@GMAIL.COM> wrote:
>
>>Hi,
>>
>>I don't know if this has already been discussed in this group, but I would
>>like to know if I could search for a variable or a list of variables from
> a
>>library containing numerous datasets. I am looking for a way to list all
> the
>>SAS datasets in a library that contain the searched variable(s).
>>
>>Thank you for any suggestions.
>>
>>Sid