Date:         Tue, 27 May 2003 12:39:00 +0200
Reply-To:     "GOMEZ TEJERINA, PEDRO ALBERTO" <PEDRO.GOMEZ@GRUPOBBVA.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "GOMEZ TEJERINA, PEDRO ALBERTO" <PEDRO.GOMEZ@GRUPOBBVA.COM>
Subject:      Looking for a more efficient way
Content-Type: text/plain;charset=iso-8859-1

--- Recibido de   BBVACENT.U094016 GOMEZ TEJERINA, PEDRO AL* 27-05-03 12.39

  -> SAS-L@LISTSERV.UGA.EDU

Dear SAS users,

I am looking for a more efficient way to make a calculus on a data step.

I have a table called "clients" (N*p), where N is the number of rows and  p
is the number of columns (assets).
On a different table (called "desv") there are the standard deviations of
each asset on a single row. The names of the variables (the assets) are the
same on both tables.

I would like to make a multiplication of each asset of every client of the
table "clients" by each standard deviation of the table "desv". I am doing
this multiplication by a data step which merges both tables by the names of
the assets (always taking into care that the names of the variables are the
same on both tables). It seems to me that a rename step is necessary.

Could anybody think of a more efficient way?

Many thanks for your help.

Yours,


            Pedro Alberto Gómez
  Departamento de Investigación Comercial
  BBVA
  Goya 14
  28001
  Madrid.
  913743577 <mailto:PEDRO.GOMEZ@GRUPOBBVA.com>
************************************  DISCLAIMER  *****************************************
This message is intended exclusively for the named person. It may contain
confidential, propietary or legally privileged information. No confidentiality or
privilege is waived or lost by any mistransmission. If you receive this message in
error, please immediately delete it and all copies of it from your system, destroy any
hard copies of it and notify the sender. Your must not, directly or indirectly, use,
disclose, distribute, print, or copy any part of this message if you are not the
intended recipient. Any views expressed in this message are those of the individual
sender, except where the message states otherwise and the sender is authorised
to state them to be the views of GrupoBBVA. Please note that internet e-mail neither
guarantees the confidentiality nor the proper receipt of the message sent. If the
addressee of this message does not consent to the use of internet e-mail, please
communicate it to us immediately.

******************************  AVISO LEGAL  ***********************************************
Este mensaje es solamente para la persona a la que va dirigido. Puede contener
información  confidencial  o  legalmente  protegida.  No  hay  renuncia  a  la
confidencialidad o privilegio por cualquier transmisión mala/errónea. Si usted
ha recibido este mensaje por error,  le rogamos que borre de su sistema
inmediatamente el mensaje asi como todas sus copias, destruya todas las copias
del mismo de su disco duro y notifique al remitente.  No debe,  directa o
indirectamente, usar, revelar, distribuir, imprimir o copiar ninguna de las partes de
este mensaje si no es usted el destinatario. Cualquier opinión expresada en este
mensaje proviene del remitente, excepto cuando el mensaje establezca lo contrario
y el remitente esté autorizado para establecer que dichas opiniones provienen de
GrupoBBVA. Nótese que el correo electrónico via Internet no permite asegurar ni la
confidencialidad de los mensajes que se transmiten ni la correcta recepción de los
mismos. En el caso de que el destinatario de este mensaje no consintiera la
utilización del correo electrónico via Internet, rogamos lo ponga en nuestro
conocimiento de manera inmediata.
***********************************************************************************************