| Date: | Fri, 23 Sep 2005 02:46:28 -0400 |
|---|
| Reply-To: | John Hendrickx <John_Hendrickx@YAHOO.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | John Hendrickx <John_Hendrickx@YAHOO.COM> |
|---|
| Subject: | Re: SQL - Excluding columns from Select |
|---|
Here's yet another alternative, using macros available at
http://www.datasavantconsulting.com/roland/sasautos.html
proc sql ;
select %remove(%varlist(one),var4,var5)
from one;
quit ;
You can add up to 30 arguments to the %remove macro.
HTH,
John Hendrickx
|
