topic Re: Putting character variables into a Proc report numeric column in SAS Procedures

Putting character variables into a Proc report numeric column

Hillel_Morris — Wed, 26 Apr 2017 22:04:17 GMT

Good afternoon all.

I believe I have done this in the past but can't remember how.

In a proc report, can I place an N/A in a cell if the value isn't possible,

For example I have a report like this:

Brown White Green

Dog 3 2 0

Turtle 2 0 2

Since there is no such thing as a Green Dog or a White Turtle, I want to put the term 'N/A' into those cells, like so:

Brown White Green

Dog 3 2 N/A

Turtle 2 N/A 2

Is this possible?

Thanks.

- Hillel

Re: Putting character variables into a Proc report numeric column

collinelliot — Wed, 26 Apr 2017 22:56:41 GMT

You can use a user-defined format:

proc format;
value myFmt
0 = 'N/A'
OTHER=[8.]; <-- Or whatever format you want.
run;

Then just use this format for the variable you're displaying.

If it's missing and not zero, set missing to 'N/A' in the format.

Re: Putting character variables into a Proc report numeric column

Reeza — Wed, 26 Apr 2017 22:57:32 GMT

Have you considered a custom format where . is set to NA. I personally wouldn't use 0, because you could 0 red dogs but it's possible they exist (Clifford the Big Red Dog probably doesn't count though).

proc format;
value miss_na_fmt
. = 'N/A'
other = [best12.];
run;;