LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (January 2003, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Mon, 27 Jan 2003 10:15:33 +0100
Reply-To:   Jim Groeneveld <J.Groeneveld@ITGROUPS.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Jim Groeneveld <J.Groeneveld@ITGROUPS.COM>
Subject:   Re: missing value for numerics, set 0 to blanks
Comments:   To: Leonora cru <ldelacru1995@YAHOO.COM>
Content-Type:   text/plain; charset="iso-8859-1"

Dear Leonora,

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. > http://mailplus.yahoo.com >


Back to: Top of message | Previous page | Main SAS-L page