Good idea, but it does not work. You can't change the type of a variable
(from num to char and vv). You would have to work with a converted derived
var of the other type. It is popossible, but in this case it would be too
much work. A quicker way is; recode the 0-values to missing and force
missing values to be printed as a blank: OPTIONS MISSING='';
Regards - Jim.
Y. (Jim) Groeneveld, MSc IMRO TRAMARKO tel. +31 412 407 070
senior statist./data man. P.O. Box 1 fax. +31 412 407 080
J.Groeneveld@ITGroups.com 5350 AA BERGHEM, NL www.imrotramarko.com
I think I master my computer, sometimes I seem to be its slave.
Notice of confidentiality: this e-mail may contain confidential information
intended for the addressed recipient only.
If you have received this e-mail in error please delete this e-mail and
please notify the sender so that proper delivery can be arranged.
> -----Original Message-----
> From: Leonora cru [mailto:ldelacru1995@YAHOO.COM]
> Sent: 27 January 2003 09:12
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: missing value for numerics, set 0 to blanks
> SAS-L Community,
> First of all, thanks to Brian Winkler and Roland
> Rashleigh-Berry re tips on indentation.
> I jave another question to you guys:
> If I want to convert the values of a numeric field to
> blanks as in this example:
> data final ;
> set final4 ;
> array numflds (*) _NUMERIC_ ;
> do i=1 to dim(numflds) ;
> if numflds(i) = 0 then numflds(i) = '';
> end ;
> run ;
> Is this a good way of converting the values 0 to ''?
> I would like to set missing on the proc report option
> so that I will see blanks instead of 0.
> Thanks for any suggestion.
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.