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 (March 2004, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Tue, 16 Mar 2004 18:59:07 -0500
Reply-To:     Noreen McDonald <noreen@BERKELEY.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Noreen McDonald <noreen@BERKELEY.EDU>
Subject:      missing values

I'm working with a large dataset (~500,000 records) and need to recode missing values. Currently values of -1, -7, -8, and -9 represent missing values (note these are used in both character and numeric fields).

I'm an inexperienced user and all I could think of was to treat the dataset as an array and test each value to see if it is a missing value (- 1, -7, -8, -9) and if so set it to . or " ". However this would require me to separately test numeric and character variables and seems computationally intensive.

I'm guessing there's a much better way to approach this problem. I'm very grateful for any suggestions. Noreen McDonald


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