Date:         Tue, 29 May 2001 15:43:43 -0700
Reply-To:     Ramon <rgaslonde@COMCAST.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ramon <rgaslonde@COMCAST.NET>
Subject:      Re: N/A
Content-Type: text/plain; format=flowed; charset="iso-8859-1";
              reply-type=original

Dear Listers, Thanks much all for your kind help. I am able only to display
blanks, or 999 or U (using .u)  for the missing values of var count, a
numeric variable that goes into a black box (a display macro tool) but not
the string 'N/A'...any thoughts?

----- Original Message -----
From: "data _null_," <datanull@GMAIL.COM>
To: <SAS-L@LISTSERV.UGA.EDU>
Sent: Wednesday, May 28, 2008 4:05 PM
Subject: Re: N/A


> You may need something more sophisticated but this should give you the
> general idea.  Format F8.2 may not be appropriate for your non-missing
> values.
>
> proc format;
>   value na ._-.z = 'N/A' other=[f8.2];
>   run;
> data work.test;
>   missing b c;
>   input a @@;
>   put a=na.;
>   cards;
> 10000 1e5 . b c -11.444444
> ;;;;
>   run;
>
>
> On 5/28/08, Ramon <rgaslonde@comcast.net> wrote:
>> Hi All,
>>
>> How can I display 'N/A' instead of a . or blank  (it's a numeric variable
>> "count" ...and needs to remain numeric)?
>>
>> Thanks!
>>
>> ----- Original Message -----
>> From: <Dana201052@GMAIL.COM>
>>