Date:         Sun, 29 Jan 2006 11:47:20 -0800
Reply-To:     tanwan <tanwanzang@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         tanwan <tanwanzang@YAHOO.COM>
Organization: http://groups.google.com
Subject:      Re: fill in the missing values for multiple columns
Comments: To: sas-l@uga.edu
In-Reply-To:  <1138556668.451698.208180@g14g2000cwa.googlegroups.com>
Content-Type: text/plain; charset="iso-8859-1"

data one1;
input date $ v1 v2 v3;
cards;
19910102   .       .       .
19910103  0.4750   .       .
19910104   .       .       .
19910107   .       .       .
19910108   .       .       .
19910109   .      0.5375   .
19910110   .       .      2.5875
19910111   .       .       .




data two2;
        retain  x1-x3  . ;
        set one1;
                x1=sum(x1, v1);
                x2=sum(x2, v2);
                x3=sum(x3, v3);
        drop v1-v3;
        rename x1=v1 x2=v2 x3=v3;
proc print data = two2;
run;