Date:         Tue, 18 Sep 2007 10:46:51 -0400
Reply-To:     Bob_Abelson@HGSI.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Bob_Abelson@HGSI.COM
Subject:      Re: listing variables
Comments: To: raveen perumal <raveencobra@inbox.com>
In-Reply-To:  <7D4CB33ED7C.000001B5raveencobra@inbox.com>
Content-Type: text/plain; charset=us-ascii

proc sql;
        create table yourcols as
        select name
        from dictionary.columns
        where libname='YOURLIB' and memname='YOURDATA';
quit;

Bob Abelson
HGSI
240 314 4400 x1374
bob_abelson@hgsi.com



"raveen perumal" <raveencobra@inbox.com>
09/18/2007 10:33 AM

To
bob_abelson@hgsi.com, sas-l@listserv.uga.edu
cc

Subject
Re: [SAS-L] listing variables






Hi

can you give the exact code using "DICTIONARY.COLUMNS" for this need?
It would be helpful for me also

Thanks,
Raveen


> -----Original Message-----
> From: bob_abelson@hgsi.com
> Sent: Tue, 18 Sep 2007 10:11:23 -0400
> To: sas-l@listserv.uga.edu
> Subject: Re: [SAS-L] listing variables
>
> Look into PROC CONTENTS. The printed output gives a lot more information
> than just the variable names, but if that's all you need, you can direct
> its output to a datasets and keep just the columns in that dataset you
> want. Another possibility is PROC SQL using the DICTIONARY.COLUMNS
table.
>
> Bob Abelson
> HGSI
> 240 314 4400 x1374
> bob_abelson@hgsi.com
>
>
>
> "Tyralynn frazier" <tfrazi2@EMORY.EDU>
> Sent by: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
> 09/18/2007 10:07 AM
> Please respond to
> "Tyralynn frazier" <tfrazi2@EMORY.EDU>
>
>
> To
> SAS-L@LISTSERV.UGA.EDU
> cc
>
> Subject
> listing variables
>
>
>
>
>
>
> Hello,
> I am trying to make a list of all the variable names of my columns in a
> sas data set. I know this is not difficult, but how do I do this?