Date:         Thu, 10 Jul 2008 11:41:17 -0400
Reply-To:     Nathaniel.Wooding@DOM.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Nat Wooding <Nathaniel.Wooding@DOM.COM>
Subject:      Re: Picking all the variables
Comments: To: SAS_learner <proccontents@GMAIL.COM>
In-Reply-To:  <c2192a610807100833u75cd3139m439710289cb03c1d@mail.gmail.com>
Content-Type: text/plain; charset="US-ASCII"

Rather than replace the values with zeros, if all you are doing is printing
the table, you could use a format to substitute zeros for blanks.

Data table;
input char $5.;
cards;
a
1
b

c
d
run;
proc format;
   value $fillit
   ' ' = '0';
run;
proc print data = table ;
    format char $fillit.;
run;

Nat Wooding
Environmental Specialist III
Dominion, Environmental Biology
4111 Castlewood Rd
Richmond, VA 23234
Phone:804-271-5313, Fax: 804-271-2977



             SAS_learner
             <proccontents@GMA
             IL.COM>                                                    To
             Sent by: "SAS(r)          SAS-L@LISTSERV.UGA.EDU
             Discussion"                                                cc
             <SAS-L@LISTSERV.U
             GA.EDU>                                               Subject
                                       Picking all the variables

             07/10/2008 11:33
             AM


             Please respond to
                SAS_learner
             <proccontents@GMA
                  IL.COM>






hello all,

I am getting a final dataset for my table and it has couple of
variables and the variables that are starting with _ (example _1,_2 ,
_3,_10)   are the variables that has my counts and are character .

Is it possible some way inside the dataset (Like operator )  to look
for all the variables starting with _  has a value if not replace the
missing values with 0 (This is Just for final representation in the
tables would not effect the counts )

thanks


CONFIDENTIALITY NOTICE:  This electronic message contains
information which may be legally confidential and/or privileged and
does not in any case represent a firm ENERGY COMMODITY bid or offer
relating thereto which binds the sender without an additional
express written confirmation to that effect.  The information is
intended solely for the individual or entity named above and access
by anyone else is unauthorized.  If you are not the intended
recipient, any disclosure, copying, distribution, or use of the
contents of this information is prohibited and may be unlawful.  If
you have received this electronic transmission in error, please
reply immediately to the sender that you have received the message
in error, and delete it.  Thank you.