Missing values from SAS
I found the answer myself. You just select the "Match Entire Cell Contents"
option. Thanks anyway!
"Mitch" wrote:
I am forced to work with an Excel sheet that was imported from SAS. It
contains the standard period "." in all cells where the data was missing. I
cannot rerun the SAS to eliminate the missing data marks. Is there a way to
eliminate the "." in Excel without also eliminating the decimal point in
numeric cell values?
|