Date:         Fri, 17 Mar 2006 16:14:52 -0500
Reply-To:     "Droogendyk, Harry" <harry.droogendyk@RBC.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Droogendyk, Harry" <harry.droogendyk@RBC.COM>
Subject:      Re: any wild card for select variables in proc sql?
Content-Type: text/plain; charset="iso8859-1"

John:

While SQL doesn't accept the colon wildcard specifier, data set options
may be used in SQL as well.  So, move your var: to a keep dataset option
and use select *.

proc sql;
  create table t1 as
    select * from t ( keep = var: ) ;
quit;

-----Original Message-----
From: owner-sas-l@listserv.uga.edu [mailto:owner-sas-l@listserv.uga.edu]
On Behalf Of John Lin
Sent: 2006, March, 17 3:50 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: any wild card for select variables in proc sql?

Hi SAS-L,

I got a quick question, as follows:

proc sql; create table T1 as select var1,var2 from T;

I am wondering if any wild card for variable names,
like:

proc sql; create table T1 as select var: from T;

Unfortunately, the above does not work.

Thanks in advance.

-John

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
_______________________________________________________________________

This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations.
Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized.
If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately.

Ce courrier électronique est confidentiel et protégé. L'expéditeur ne renonce pas aux droits et obligations qui s'y rapportent.
Toute diffusion, utilisation ou copie de ce message ou des renseignements qu'il contient par une personne autre que le (les) destinataire(s) désigné(s) est interdite.
Si vous recevez ce courrier électronique par erreur, veuillez m'en aviser immédiatement, par retour de courrier électronique ou par un autre moyen.