topic Creating new column in Discussions https://community.jmp.com/t5/Discussions/Creating-new-column/m-p/5627#M5626 <HTML><HEAD></HEAD><BODY><P>I am trying to create a column titled &gt;2 Exac from the following example data set.</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Patient</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Exac/yr</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>&gt;2 Exac</STRONG></TH></TR><TR><TD style="padding: 2px;">234</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">234</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">234</TD><TD style="padding: 2px;">5</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">234</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">235</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">0</TD></TR><TR><TD style="padding: 2px;">235</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">0</TD></TR><TR><TD style="padding: 2px;">235</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">0</TD></TR><TR><TD style="padding: 2px;">236</TD><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">236</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">236</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">236</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">1</TD></TR></TBODY></TABLE><P></P><P>If any row for a particular patient is greater than or equal to 2 then I want to place a 1 in the new column (&gt;2 Exac) for that patient (for each entry in the database).</P><P>If no row for a particular patient is greater than or equal to 2, then I want to place a 0 in the new column for that patient.</P><P></P><P>What is the easiest way to do this?</P></BODY></HTML> Thu, 20 Sep 2012 01:12:26 GMT jstewart 2012-09-20T01:12:26Z Creating new column https://community.jmp.com/t5/Discussions/Creating-new-column/m-p/5627#M5626 <HTML><HEAD></HEAD><BODY><P>I am trying to create a column titled &gt;2 Exac from the following example data set.</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Patient</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Exac/yr</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>&gt;2 Exac</STRONG></TH></TR><TR><TD style="padding: 2px;">234</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">234</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">234</TD><TD style="padding: 2px;">5</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">234</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">235</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">0</TD></TR><TR><TD style="padding: 2px;">235</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">0</TD></TR><TR><TD style="padding: 2px;">235</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">0</TD></TR><TR><TD style="padding: 2px;">236</TD><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">236</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">236</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">236</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">1</TD></TR></TBODY></TABLE><P></P><P>If any row for a particular patient is greater than or equal to 2 then I want to place a 1 in the new column (&gt;2 Exac) for that patient (for each entry in the database).</P><P>If no row for a particular patient is greater than or equal to 2, then I want to place a 0 in the new column for that patient.</P><P></P><P>What is the easiest way to do this?</P></BODY></HTML> Thu, 20 Sep 2012 01:12:26 GMT https://community.jmp.com/t5/Discussions/Creating-new-column/m-p/5627#M5626 jstewart 2012-09-20T01:12:26Z Re: Creating new column https://community.jmp.com/t5/Discussions/Creating-new-column/m-p/5628#M5627 <HTML><HEAD></HEAD><BODY><P>A column formula is easy and will stay updated when adding, editing or deleting rows.</P><P></P><P style="margin: 0.0px 0.0px 0.0px 0.0px;">Col Maximum(:Name("Exac/yr"), :Patient) &gt;= 2</P></BODY></HTML> Thu, 20 Sep 2012 06:23:49 GMT https://community.jmp.com/t5/Discussions/Creating-new-column/m-p/5628#M5627 ms 2012-09-20T06:23:49Z