BookmarkSubscribeRSS Feed
Spacetime
Obsidian | Level 7

I am doing some extensive printing of tables out to Excel using the ExcelXP tagset.  One thing that happens, when a numeric is blank, it will print a . out to my table.  Also, when a character is blank, it will print a " " (so an actual space) out to my table.  My users asked me to make these simply be blank (no . and no " ").  Is there an option to set that will get these to print out that way?

Thanks.

2 REPLIES 2
Haikuo
Onyx | Level 15

Not tested for Excel output, but works for SAS display:

Try this:

Options missing='';

Haikuo

Spacetime
Obsidian | Level 7

Thank you, this did work for my numeric!  They no longer print a . to Excel.  For some reason my character are still printing the blank space to Excel though.  Now I am wondering whether this missing = option only applies to the numeric, and whether there is a similar option for the character.

It seems strange it would act this way for the missing character.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

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
  • 896 views
  • 3 likes
  • 2 in conversation