effect:IF statement

Can you post a sample workbook showing expected results?

I'm going to repost this. I changed up the description a little bit.
I now have a sample workbook attached to help clarify.


Hi there,

I have blood pressure data on about 1200 ppl.

I have listed out their systolic/diastolic BPs and the different blood pressure drugs they're on:

ID # Systolic BP Diastolic BP alpha beta CCBs Diu. # of BP meds
9090A 120.5 90 1 0 0 1 2
9090B 130.5 105 0 0 1 1


Now, what I need to do is adjust their current blood pressure to get their REAL blood pressure by compensating for the drugs they're on. For instance, 9090A is on an alpha blocker and a diuretic. That means that their real blood pressure is much higher than 120.5 and 90, but it's shown as 120.5/90 because of the drugs.

This is easy to adjust when the subjects are only on one drug. But as shown in the examples above, the difficulty arises when I have to consider that they're on multiple drugs.

The literature says that I have to adjust their blood pressure by adding the mono-drug therapy effect of the first medication with the highest effect plus the weighted average effect of the second medication. These effects are given values. And you have to do this for both the systolic blood pressure and the diastolic blood pressure.

Confusing, I know. So, I made a sample workbook that details out the steps that need to be done with an example.

Please let me know if you can help me

Thank you so much,
Anish

Hi TMShucks,

Thank you for trying. I understand that it's confusing. Incase it helps at all, diuretic drugs would be any of the drugs that have the codes td, pd, ld, b+td, ace+td, pd+td, ara+td, aag+td.

Please let me know if there is anything else I can clarify or clean up on the sample workbook.

Thanks,
Anish

Are you "locked in" with the way the data is arranged?

It might be a lot easier if the drugs were in columns grouped by diuretic and otherwise.
For instance non-diuretics from columns B to whatever (say L) and diuretics from columns M to whatever.

Is it safe to assume any drug or combination of drug with last character being a "d" would be a diuretic?

No, the data is not locked in.

And yes, it is safe to assume that any drug that ends in d is a diuretic (besides ccbd and *ace+ccbd).

-Anish

Thank you for doing this. Everything in the systolic seems accurate, but I'm a little confused on the diastolic. The diastolic should be similar to the systolic; that is, if one of the two drugs is a diuretic, the drug with the lowest effect should be multiplied by .48 (I think you have .28 listed).

So, if SYS1D applies to a person, then DIA1D should also apply to that person.

Thank you,
Anish

Thank you for fixing it; however, the issue I mentioned in the previous post is still there. A person who is on 2 drugs in which one of them is a diuretic, let's say b and ara+td (id:19003), that person will have their SYS1D adjusted in addition to DIA1D adjusted. That's because one of the 2 drugs (ara+td) is a diuretic.Therefore, there should be an adjustment to DIA1D as well.


In the case of ID 19004, they are on 2 drugs, none of which are a diuretic. Therefore, only SYS0D and DIA0D should be adjusted. There should be no adjustment to DIA1D (as you have shown).

I hope I explained that clearly and hope that helps. Once again, I appreciate all the effort you've put in.

-Anish

I think I figured it out! Woohoo!

Thanks so much for all of your assistance.