Date:         Tue, 18 Sep 2007 10:44:46 -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: listing variables

in my last post I was too unexact! Sorry. That works:

proc sql;
  create table vars as select name from sashelp.vcolumn
  where libname="SASHELP" and memname="CLASS";
quit;

You could also use a DATA step, but that is much slower!
Gerhard


On Tue, 18 Sep 2007 06:32:17 -0800, raveen perumal <raveencobra@INBOX.COM>
wrote:

>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?