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 (April 2000, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Tue, 25 Apr 2000 09:33:49 -0700
Reply-To:     Ya Huang <ya.huang@AGOURON.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ya Huang <ya.huang@AGOURON.COM>
Subject:      Re: Delete records with certain variables have missing value
Comments: To: Lily Yu <lyu_98@YAHOO.COM>
Content-Type: text/plain; charset=us-ascii

Try something like:

data xx; set xx; if max(of _NUMERIC_) =. then delete;

this is for all numeric var is missing, if you want only some of the certain vars, give the name of the vars following the "of" in max function.

HTH

Ya Huang

Lily Yu wrote:

> Hi! > Can someone help me on how to delete records with > certain variables have missing value? Say if all > numeric value are missing? > > Thanks in advance! > > Yuan > > __________________________________________________ > Do You Yahoo!? > Send online invitations with Yahoo! Invites. > http://invites.yahoo.com


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