LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (September 2002, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Tue, 17 Sep 2002 12:19:56 -0600
Reply-To:   Jack Hamilton <JackHamilton@FIRSTHEALTH.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Jack Hamilton <JackHamilton@FIRSTHEALTH.COM>
Subject:   Re: Deleting data set in a data step
Comments:   To: WHITLOI1@WESTAT.com
Content-Type:   text/plain; charset=US-ASCII

Interesting. It doesn't seem to recognize data step views. Yet (according to a usage note; I haven't tried it), it can be used to delete a view of an Oracle table established through a libname. There's some inconsistency there.

A little birdie tells me they're considering adding PROC DELETE back to the documentation in a future release.

-- JackHamilton@FirstHealth.com Manager, Technical Development METRICS Department, First Health West Sacramento, California USA

>>> "Ian Whitlock" <WHITLOI1@WESTAT.com> 09/17/2002 5:36 AM >>> Jack,

This is what they mean by it is "obsolete" and maybe "supported".

19 data v / view = v ; 20 x = 1 ; 21 run ;

NOTE: DATA STEP view saved on file WORK.V. NOTE: A stored DATA STEP view cannot run under a different operating system. NOTE: DATA statement used: real time 0.16 seconds

22 proc delete data = v ; 23 run ;

WARNING: File WORK.V.DATA does not exist. NOTE: PROCEDURE DELETE used: real time 0.04 seconds

IanWhitlock@westat.com

-----Original Message----- From: Jack Hamilton [mailto:JackHamilton@FIRSTHEALTH.COM] Sent: Monday, September 16, 2002 1:28 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: Deleting data set in a data step

I wonder what they mean by "supported", if that does not include "documented".

The tech support notes say "The DELETE procedure was replaced by the DELETE statement in PROC DATASETS beginning with Release 6.06."

On the other hand, there are version 8 notes which specifically recommend PROC DELETE to work around problems in other procedures, and there are current examples which use it.

-- JackHamilton@FirstHealth.com Manager, Technical Development METRICS Department, First Health West Sacramento, California USA

>>> paul_dorfman@HOTMAIL.COM 09/13/2002 10:48 PM >>> Brad,

It is, in fact, supported in version 9. I have no clue why it is not documented. If redundancy is the problem, then methods of slaughtering SAS data sets are redundant enough without the DELETE proc...

Kind regards, ================= Paul M. Dorfman Jacksonville, FL =================

From: "Goldman, Brad (AT-Atlanta)" <Brad.Goldman@AUTOTRADER.COM>

It is no longer documented, but I was told from a little birdie that is supported and will continue to be supported. And great undocumented features and tricks is what SAS-L is all about! :)

Brad

> Yes, PROC DELETE is easier, but has been made obsolescent > (too quick and > easy to use, I suppose) and is no longer documented.

_________________________________________________________________ Send and receive Hotmail on your mobile device: http://mobile.msn.com


Back to: Top of message | Previous page | Main SAS-L page