Date:         Fri, 5 Feb 2010 19:37:02 -0400
Reply-To:     Muthia Kachirayan <muthia.kachirayan@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Muthia Kachirayan <muthia.kachirayan@GMAIL.COM>
Subject:      Re: Variable selection (or more precisely variable pickup)
In-Reply-To:  <2fc7f3341002051535u3b241811k61f57bc5b52218f1@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1

.... but proc SQL is very good ..

On Fri, Feb 5, 2010 at 7:35 PM, Muthia Kachirayan <
muthia.kachirayan@gmail.com> wrote:

> There is always another way in SAS using Proc Contents and ODS output.
>
> proc contents data = sashelp.class;
> ods output Variables = Vars(keep = Variable
>             where = ( substr(Variable,length(Variable) - 2, 3) = 'ght'));
> run;
>
>
>
>
>  On Fri, Feb 5, 2010 at 4:09 PM, Zhaoqing Huang <anthony.hwangq@gmail.com>wrote:
>
>> Dear all,
>>
>> I have a huge dataset having more than 500 variables, and I want to
>> select some of them to form a sub-dataset.
>> For example, I want to pick all these variables whose last letters are
>> "XYZ".
>> Right now, the only way I think might work is to transpose the whole
>> dataset and select observation with "XYZ", and then transpose it back.
>> Is there a simpler way to do so?
>> Any information would be much appreciated.
>>
>> Zhaoqing
>> Grad Student
>> University of Southern California
>>
>
>