Yom

You can do this with Proc Datasets using the colon modifier to specify that you want to get rid of the sets with the specified prefix.

Nat Wooding

data a1 a2 a3 b; x=1; proc contents; proc datasets; delete a: ; proc contents; run;

yom <yomsas@GMAIL.COM > To Sent by: "SAS(r) SAS-L@LISTSERV.UGA.EDU Discussion" cc <SAS-L@LISTSERV.U GA.EDU> Subject Re: Delete table

07/18/2006 04:48 AM

Please respond to yom <yomsas@GMAIL.COM >

In fact I was not clear in my message. There is a second question : I would like to delete all the tables whose name has prefix 'table'.

yom

2006/7/18, yom <yomsas@gmail.com>: > > Dear All, > > I would like to know what is the simpliest way to delete a table. > How to delete tables whose name is like 'tableXX' where XX is a number. > > Thank you very much ! > > yom >

----------------------------------------- CONFIDENTIALITY NOTICE: This electronic message contains information which may be legally confidential and/or privileged and does not in any case represent a firm ENERGY COMMODITY bid or offer relating thereto which binds the sender without an additional express written confirmation to that effect. The information is intended solely for the individual or entity named above and access by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution, or use of the contents of this information is prohibited and may be unlawful. If you have received this electronic transmission in error, please reply immediately to the sender that you have received the message in error, and delete it. Thank you.