Date:         Fri, 11 Nov 2005 10:16:28 -0800
Reply-To:     SAS_my_life <subramanyam.phani@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         SAS_my_life <subramanyam.phani@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: How to drop One variable from all the datasets
Comments: To: sas-l@uga.edu
In-Reply-To:  <3thjl7Fsg6ddU1@individual.net>
Content-Type: text/plain; charset="iso-8859-1"

Thanks Richard for your tip when I am using the above code with slight
change in name it is giving me a error

%let lib = datout;
%let aberrant = OCTA_SEQ ;

proc sql noprint;
  select 'alter table ' || catx('.', libname, memname) || " drop
&aberrant."
  into :del separated by ';'
  from dictionary.columns
  where libname="&lib" and name="&aberrant"
  ;
%put %superq(del);
&del;
 quit;

994     select 'alter table ' || catx('.', libname, memname) || " drop
&aberrant."
995     into :del separated by ';'
996     from dictionary.columns
997     where libname="&lib" and name="&aberrant"
998     ;
NOTE: No rows were selected.
999   %put %superq(del);
WARNING: Apparent symbolic reference DEL not resolved.

1000  &del;
      -
      180
WARNING: Apparent symbolic reference DEL not resolved.
ERROR 180-322: Statement is not valid or it is used out of proper
order.

1001
1002  quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds

can you look into it please