Missing Dates appear as Dot. How can i replace them to blank

[deleted_user]

Hi

My report has a date column which shows Dots . when the date is missing.

How can I make them as NULL or blank


Sanjay

[Peter_C]

suppose your dates are formatted in DATE9. format.
Then create your own date format with no dot (just blank) for missing.
[pre]* run this code to create mdate9 format ;
proc format ;
value mdate .=' ' other = [date9.] ;
run;[/pre]
Then use format mdate. instead of date9.

If you were using a different format than date9., then put your other format inside the []


good luck

PeterC

[prholland]

Sunil,

You can change the display of all missing values, whether character or numeric, to blank with the following OPTIONS statement:


OPTIONS MISSING=" ";


........Phil

[deleted_user]

You can also use computed columns -recode a column in filter and query.

Regards,
Loccita