topic Re: Missing Dates appear as Dot. How can i replace them to blank in SAS Enterprise Guide

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

deleted_user — Tue, 02 Oct 2007 09:15:08 GMT

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

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

Peter_C — Tue, 02 Oct 2007 14:06:55 GMT

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

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

prholland — Tue, 16 Oct 2007 09:00:43 GMT

Sunil,

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

OPTIONS MISSING=" ";

........Phil

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

deleted_user — Fri, 09 Nov 2007 14:23:39 GMT

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

Regards,
Loccita