BookmarkSubscribeRSS Feed
JasonNC
Quartz | Level 8

Hi,

 

I am using ODS ExcelXp tagset to create my report.

I don't want to display .  or 0 for missing values in my excel output for numeric variables just want the cell to be blank

Is there a way to achieve this ?

1 REPLY 1
SASKiwi
PROC Star
options missing = ' ';

Catch up on SAS Innovate 2026

Nearly 200 sessions are now available on demand with the SAS Innovate Digital Pass.

Explore 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
  • 1 reply
  • 1639 views
  • 2 likes
  • 2 in conversation