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
|