BookmarkSubscribeRSS Feed
Hillel_Morris
Calcite | Level 5

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

                  

 

 

2 REPLIES 2
collinelliot
Barite | Level 11

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.

Reeza
Super User

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;;

 

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 916 views
  • 0 likes
  • 3 in conversation