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