topic Dividing the value in two columns under the same category in SAS Visual Analytics in SAS Viya https://communities.sas.com/t5/SAS-Viya/Dividing-the-value-in-two-columns-under-the-same-category-in-SAS/m-p/746907#M975 <P>Hi I'm looking to create a new column in the same table like below where the columns are from the same category and value 1 is the numerator and value 2 is the denominator:&nbsp;</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>&nbsp;</TD><TD>Category 1</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>Value 1</TD><TD>Value 2</TD><TD><STRONG>New Value (Value 1/Value2)</STRONG></TD></TR><TR><TD>Measure 1</TD><TD>1</TD><TD>5</TD><TD><STRONG>0.20</STRONG></TD></TR><TR><TD>Measure 2</TD><TD>2</TD><TD>6</TD><TD><STRONG>0.33</STRONG></TD></TR><TR><TD>Measure 3</TD><TD>3</TD><TD>7</TD><TD><STRONG>0.43</STRONG></TD></TR><TR><TD>Measure 4</TD><TD>4</TD><TD>8</TD><TD><STRONG>0.50</STRONG></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thanks.</P><P>&nbsp;</P><P>Update: I'm looking to achieve this under SAS Visual Analytics.</P> Wed, 09 Jun 2021 21:41:05 GMT llai1 2021-06-09T21:41:05Z Dividing the value in two columns under the same category in SAS Visual Analytics https://communities.sas.com/t5/SAS-Viya/Dividing-the-value-in-two-columns-under-the-same-category-in-SAS/m-p/746907#M975 <P>Hi I'm looking to create a new column in the same table like below where the columns are from the same category and value 1 is the numerator and value 2 is the denominator:&nbsp;</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>&nbsp;</TD><TD>Category 1</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>Value 1</TD><TD>Value 2</TD><TD><STRONG>New Value (Value 1/Value2)</STRONG></TD></TR><TR><TD>Measure 1</TD><TD>1</TD><TD>5</TD><TD><STRONG>0.20</STRONG></TD></TR><TR><TD>Measure 2</TD><TD>2</TD><TD>6</TD><TD><STRONG>0.33</STRONG></TD></TR><TR><TD>Measure 3</TD><TD>3</TD><TD>7</TD><TD><STRONG>0.43</STRONG></TD></TR><TR><TD>Measure 4</TD><TD>4</TD><TD>8</TD><TD><STRONG>0.50</STRONG></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thanks.</P><P>&nbsp;</P><P>Update: I'm looking to achieve this under SAS Visual Analytics.</P> Wed, 09 Jun 2021 21:41:05 GMT https://communities.sas.com/t5/SAS-Viya/Dividing-the-value-in-two-columns-under-the-same-category-in-SAS/m-p/746907#M975 llai1 2021-06-09T21:41:05Z Re: Dividing the value in two columns under the same category in SAS Visual Analytics https://communities.sas.com/t5/SAS-Viya/Dividing-the-value-in-two-columns-under-the-same-category-in-SAS/m-p/750351#M995 <P>Please have a look here. You will have the solution.</P> <P><A href="https://documentation.sas.com/doc/en/vacdc/8.1/vdbliveeditadv/n1804pdfa1izx0n13q052py8d5n8.htm" target="_blank">https://documentation.sas.com/doc/en/vacdc/8.1/vdbliveeditadv/n1804pdfa1izx0n13q052py8d5n8.htm</A>&nbsp;</P> Thu, 24 Jun 2021 22:18:02 GMT https://communities.sas.com/t5/SAS-Viya/Dividing-the-value-in-two-columns-under-the-same-category-in-SAS/m-p/750351#M995 Sajid01 2021-06-24T22:18:02Z