topic How to chose the most appropriate value from one of three columns and copy it to a fourth column? in Discussions
https://community.jmp.com/t5/Discussions/How-to-chose-the-most-appropriate-value-from-one-of-three/m-p/189181#M40791
<P>Hi,</P><P>I am using JMP Pro on a regular basis in my work as a clinical professor of surgery in Sweden. Since not so many academic researchers in Sweden use JMP I really have appreciated the help I have got from the forum since there are not, yet, so many colleagues that I can ask (they mostly use SPSS).</P><P>My question is the following. I have three collums with events where Column 1 is Time in days to today´s date; column 2 is time to death and column 3 is time to new intervention. I would like to write a formula in the fourth column that först looks into column 3 and if there is a date there it picks it to column 4. If there is no date in column 3 it looks to column 2 and if there is a date there it picks that date. Otherwise it picks the date in column 1. See below where I have tried to exemplify:</P><P> </P><P>Column 1. Column 2 Column 3 Column 4</P><P>100 ---------- ----------- 100</P><P>100 32 ------------ 32</P><P>100 25 10 10</P><P> </P><P>Would very much appreciated if I could write some formula in column 4 that picks out the numbers from columns 1-3.</P><P> </P><P>Sincerely yours</P><P> </P><P>Lars</P>Tue, 26 Mar 2019 08:50:02 GMTLarsBirger2019-03-26T08:50:02ZHow to chose the most appropriate value from one of three columns and copy it to a fourth column?
https://community.jmp.com/t5/Discussions/How-to-chose-the-most-appropriate-value-from-one-of-three/m-p/189181#M40791
<P>Hi,</P><P>I am using JMP Pro on a regular basis in my work as a clinical professor of surgery in Sweden. Since not so many academic researchers in Sweden use JMP I really have appreciated the help I have got from the forum since there are not, yet, so many colleagues that I can ask (they mostly use SPSS).</P><P>My question is the following. I have three collums with events where Column 1 is Time in days to today´s date; column 2 is time to death and column 3 is time to new intervention. I would like to write a formula in the fourth column that först looks into column 3 and if there is a date there it picks it to column 4. If there is no date in column 3 it looks to column 2 and if there is a date there it picks that date. Otherwise it picks the date in column 1. See below where I have tried to exemplify:</P><P> </P><P>Column 1. Column 2 Column 3 Column 4</P><P>100 ---------- ----------- 100</P><P>100 32 ------------ 32</P><P>100 25 10 10</P><P> </P><P>Would very much appreciated if I could write some formula in column 4 that picks out the numbers from columns 1-3.</P><P> </P><P>Sincerely yours</P><P> </P><P>Lars</P>Tue, 26 Mar 2019 08:50:02 GMThttps://community.jmp.com/t5/Discussions/How-to-chose-the-most-appropriate-value-from-one-of-three/m-p/189181#M40791LarsBirger2019-03-26T08:50:02ZRe: How to chose the most appropriate value from one of three columns and copy it to a fourth column?
https://community.jmp.com/t5/Discussions/How-to-chose-the-most-appropriate-value-from-one-of-three/m-p/189191#M40792
<P>Please take a look at the formula in the table attached and check that's the behaviour you want:</P>Tue, 26 Mar 2019 09:39:15 GMThttps://community.jmp.com/t5/Discussions/How-to-chose-the-most-appropriate-value-from-one-of-three/m-p/189191#M40792ian_jmp2019-03-26T09:39:15Z