question about ifs

[Rodrigo Briceño]

Dear SPSS users. I have the following problem: I am working on a health
survey that has the currency used for payment in one column and the amount
of payment in another column. The data about currencies and amount of
payment are in 10 columns (one for each individual). I developed the
following syntax in order to do the job:

IF (SH72U$01=1 | SH72U$02=1| SH72U$03=1| SH72U$04=1| SH72U$05=1|

  SH72U$06=1| SH72U$07=1| SH72U$08=1| SH72U$09=1| SH72U$10=1) treatm_riels =

  sum(SH72N$01,SH72N$02,SH72N$03,SH72N$04,SH72N$05,SH72N$06,SH72N$07

 ,SH72N$08,SH72N$09,SH72N$10) .

EXECUTE .

 

This is supposed to sum across columns all the amounts where the currency
variable equal 1, but there is a problem. I noticed that the sum is
incorrect in some cases, where currency values are different for each
observation. That means if the observation 20 has a 1 for individual 1
(meaning currency riel), a 2 for individual 2 (meaning currency US$) and
again a 1 for individual 3, the sum provided is the sum of the 3 values,
like if the currency considered was not taken into account.

 

I can share an extract of the DB if you want more details about it.

 

Thanks.

__________________________________________________________________

Rodrigo Briceño
Project Manager
Sanigest Internacional

[phone] ext. 113   Oficina Costa Rica
[phone]                   Fax
[phone]                   Celular
[hidden email] <mailto:[hidden email]>
 <http://www.sanigest.com/> www.sanigest.com

MSN:  <mailto:[hidden email]> [hidden email]
SKYPE: rbriceno1087

_____________________

This communication contains legal information which is privileged and
confidential. It is for the exclusive use of the address and distribution,
dissemination, copying or use by others is strictly prohibited. If you have
received this communication by error, please delete the original message and
e-mail us.


Esta comunicación contiene información legal privilegiada y confidencial
para el uso exclusivo del destinatario. La distribución, diseminación, copia
u otro uso por terceras personas es estrictamente prohibida. Si usted ha
recibido esta comunicación por error, le rogamos borrar el mensaje original
y comunicárnoslo a esta misma dirección.

 

====================To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Florio Arguillas]

try this one.

compute treatm_riels =0.
compute treatm_dollars =0.
do repeat x = SH72U$01 to SH72U$10/y = SH72N$01 to SH72N$10.
         if x = 1 treatm_riels = sum(treatm_riels, y).
         if x = 2 treatm_dollars = sum(treatm_dollars, y).
end repeat.
exe.



At 04:30 PM 11/30/2007, Rodrigo Briceno wrote:

>Dear SPSS users. I have the following problem: I am working on a health
>survey that has the currency used for payment in one column and the amount
>of payment in another column. The data about currencies and amount of
>payment are in 10 columns (one for each individual). I developed the
>following syntax in order to do the job:
>
>IF (SH72U$01=1 | SH72U$02=1| SH72U$03=1| SH72U$04=1| SH72U$05=1|
>
>   SH72U$06=1| SH72U$07=1| SH72U$08=1| SH72U$09=1| SH72U$10=1) treatm_riels =
>
>   sum(SH72N$01,SH72N$02,SH72N$03,SH72N$04,SH72N$05,SH72N$06,SH72N$07
>
>  ,SH72N$08,SH72N$09,SH72N$10) .
>
>EXECUTE .
>
>
>
>This is supposed to sum across columns all the amounts where the currency
>variable equal 1, but there is a problem. I noticed that the sum is
>incorrect in some cases, where currency values are different for each
>observation. That means if the observation 20 has a 1 for individual 1
>(meaning currency riel), a 2 for individual 2 (meaning currency US$) and
>again a 1 for individual 3, the sum provided is the sum of the 3 values,
>like if the currency considered was not taken into account.
>
>
>
>I can share an extract of the DB if you want more details about it.
>
>
>
>Thanks.
>
>__________________________________________________________________
>
>Rodrigo Briceño
>Project Manager
>Sanigest Internacional
>
>[phone] ext. 113   Oficina Costa Rica
>[phone]                   Fax
>[phone]                   Celular
>[hidden email] <mailto:[hidden email]>
>  <http://www.sanigest.com/> www.sanigest.com
>
>MSN:  <mailto:[hidden email]> [hidden email]
>SKYPE: rbriceno1087
>
>_____________________
>
>This communication contains legal information which is privileged and
>confidential. It is for the exclusive use of the address and distribution,
>dissemination, copying or use by others is strictly prohibited. If you have
>received this communication by error, please delete the original message and
>e-mail us.
>
>
>Esta comunicación contiene información legal privilegiada y confidencial
>para el uso exclusivo del destinatario. La distribución, diseminación, copia
>u otro uso por terceras personas es estrictamente prohibida. Si usted ha
>recibido esta comunicación por error, le rogamos borrar el mensaje original
>y comunicárnoslo a esta misma dirección.
>
>
>
>
>To manage your subscription to SPSSX-L, send a message to
>[hidden email] (not to SPSSX-L), with no body text except the
>command. To leave the list, send the command
>SIGNOFF SPSSX-L
>For a list of commands to manage subscriptions, send the command
>INFO REFCARD

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD