Missing values from SAS
press Ctrl-H to get the Replace dialog box. Put the period in the Find box
and leave the Replace box empty
Check the box for "match entire cell contents." (If it doesn't show, click
the Options button to display it)
"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?
|