```Date: Fri, 29 Apr 2005 14:07:54 -0400 Reply-To: harry.droogendyk@RBC.COM Sender: "SAS(r) Discussion" From: Harry Droogendyk Subject: Re: Sum Content-Type: text/plain; charset="iso-8859-1" This is starting to look like homework questions... You've started well, breaking it into chunks, why don't you try to solve this the same way, do 1, then 2 etc.. See OnlineDocs, http://v8doc.sas.com/sashtml/, for: array: eg. array x x: ; do; loop for cycling through the array items if then/else for examining values of the array buckets -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU]On Behalf Of Thomas Sent: Friday, April 29, 2005 1:58 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Sum Hi all, May I know how to sum the following variables and then do the average across it? The -999 and . should be excluded from the summing and averaging. Thank you very much! Procedures: 1. sum across x and y separately. 2. each individual x divided by sum_x from No.1 (each individual y divided by sum_y). 3. square each individual from the NO.2 4. sum again the No.3 across x and y, respectively. 4. -999 and . are excluded here (treated as missing values). /*expected data*/ id x1 x2 x3 x4 y1 y2 y3 y4 y5 1 100 50 -999 . 20 22 23 25 30 2 -999 0 40 -999 . -999 40 -999 . 3 100 . -999 . 50 0 . . -999 /*expected output */ id index_x index_y; 1 0.5556 [(100/150)^2] + [(50/150)^2] 0.204 [the cal. same as var x] 2 1 [(0/40)^2] + [(40/40)^2 1 3 1 (100/100)^2 1 __________________________________________________________________________________________________________________________________ This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately. Ce courrier électronique est confidentiel et protégé. L'expéditeur ne renonce pas aux droits et obligations qui s'y rapportent. Toute diffusion, utilisation ou copie de ce message ou des renseignements qu'il contient par une personne autre que le (les) destinataire(s) désigné(s) est interdite. Si vous recevez ce courrier électronique par erreur, veuillez m'en aviser immédiatement, par retour de courrier électronique ou par un autre moyen. ```

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