Date:         Sat, 18 Mar 2006 11:12:26 -0800
Reply-To:     subbhu <tataphani@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         subbhu <tataphani@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: Missing numeric values as blanks
Comments: To: sas-l@uga.edu
In-Reply-To:  <481qkbFhled1U1@individual.net>
Content-Type: text/plain; charset="iso-8859-1"

richard,

I used missing = '' option once in my macro my manager told me it is
Just for viewing purpose but it won't change the nature of dataset ,
what I mean is if I need to change the dataset or make it in a perm..
dataset then this option will work .....????
Richard A. DeVenezia wrote:
> The_Grudge wrote:
> > Okay, everything appears to be working okay.
> >
> > However, I have a date field in my data that doesn't always contain a
> > value.
> > In these instances, I want the date to be blank, not a period!!!!!
> >
> > How do I remove the period from blank dates?
>
> No need to swear.  Try
> options missing=' ';
>
> SAS will render numeric values that are missing with a space instead of a
> period (the default).
>
> --
> Richard A. DeVenezia
> http://www.devenezia.com/