Date:         Wed, 7 Jul 2010 12:27:10 -0700
Reply-To:     "Choate, Paul@DDS" <Paul.Choate@DDS.CA.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Choate, Paul@DDS" <Paul.Choate@DDS.CA.GOV>
Subject:      Re: Proc Delete Lives On In SAS Institure Code
In-Reply-To:  <4A65BFB28FC42A4B81AAA01C69E990370232B2A9@LTA3VS023.ees.hhs.gov>
Content-Type: text/plain; charset="us-ascii"

Missed this last week. Please excuse the late post.

Proc delete doesn't allow wildcard colons!  So if you have several datasets with a common suffix you can't sweep them all out in one.

data help1 help2 help3 help4 help5 help6 help7 help8;
     set sashelp.class;
run;

/*isn't allowed*/
proc delete data=help:;
run;

/*     minimal form?  */
proc delete data=help1 help2 help3 help4 help5 help6 help7 help8;
run;

/*     like magic    */
proc datasets; delete help:;
quit;


Paul Choate
DDS Data Extraction
(916) 654-2160
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Fehd, Ronald J. (CDC/OSELS/NCPHI)
Sent: Tuesday, June 29, 2010 10:16 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: Proc Delete Lives On In SAS Institure Code

http://www.sascommunity.org/wiki/PROC_Delete

note which is faster:

* proc datasets delete
* sql drop table
* proc delete <---<<<

Ron Fehd  the quicker is better maven

> -----Original Message-----
> From: Nat Wooding
> Subject: Proc Delete lives on in SAS Institute Code
>
>
> Although Proc Delete long ago disappeared from SAS documentation, it
is
> occasionally referenced in threads on this list. For those who have
not
> seen
> it, the syntax is
>
> Proc Delete data = one;
> Run;
>