Desktop productivity for business analysts and programmers

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

Reply
N/A
Posts: 0

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

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
Valued Guide
Posts: 2,174

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

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
Frequent Contributor
Posts: 81

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

Sunil,

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


OPTIONS MISSING=" ";


........Phil
N/A
Posts: 0

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

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

Regards,
Loccita
Ask a Question
Discussion stats
  • 3 replies
  • 6992 views
  • 0 likes
  • 3 in conversation