|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)|
|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 <
> 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'));
> On Fri, Feb 5, 2010 at 4:09 PM, Zhaoqing Huang <firstname.lastname@example.org>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
>> 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.
>> Grad Student
>> University of Southern California