topic Re: Numeric column in a dataset has "C" as a value in SAS Programming

Numeric column in a dataset has "C" as a value

rtaylor — Fri, 05 Aug 2016 12:17:29 GMT

A variable in a dataset is of type numeric, but shows a value 'C' when viewed or printed. Format is best12.

SAS Output:

What does it mean? Is it missing? How do I exclude such values?

RW9 — Fri, 05 Aug 2016 12:36:06 GMT

Its a special missing, you may find this paper helpfull:

And you can use the missing() function:

Or check specifically for that.

rtaylor — Fri, 05 Aug 2016 12:44:12 GMT

thanks.