https://communities.sas.com/t5/New-SAS-User/How-to-Calculate-Gross-sales-Column-from-Order-Quantity-and-Unit/m-p/821310#M34902 <P>Thanks!</P> Fri, 01 Jul 2022 16:29:27 GMT LABRADOR 2022-07-01T16:29:27Z https://communities.sas.com/t5/New-SAS-User/How-to-Calculate-Gross-sales-Column-from-Order-Quantity-and-Unit/m-p/821307#M34900 <P>How do I calculate gross sales from Order Quantity and Unit Price in SAS 9.4?&nbsp;</P> <TABLE dir="ltr" style="height: 1557px; border-style: solid: inset 20px; border-color: #3c499c; background-color: #fbeda3;" border="1" cellspacing="0" cellpadding="0"><COLGROUP><COL width="100" /><COL width="100" /><COL width="100" /></COLGROUP> <TBODY> <TR> <TD width="100px" height="57px" data-sheets-value="{&quot;1&quot;:2,&quot;2&quot;:&quot;Order Quantity&quot;}">Order Quantity</TD> <TD width="100px" height="57px" data-sheets-value="{&quot;1&quot;:2,&quot;2&quot;:&quot;Unit Price&quot;}">Unit Price</TD> <TD width="100px" height="57px" data-sheets-value="{&quot;1&quot;:2,&quot;2&quot;:&quot;Gross Sales&quot;}">Gross Sales</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:20}">20</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:37.72}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$37.72</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:11}">11</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:35.85}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$35.85</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:1}">1</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:37.72}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$37.72</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:28}">28</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:35.85}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$35.85</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:8}">8</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:37.33}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$37.33</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:20}">20</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:35.85}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$35.85</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:15}">15</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:37.72}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$37.72</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:1}">1</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:37.33}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$37.33</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:16}">16</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:12.1}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$12.10</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:19}">19</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:13.64}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$13.64</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:30}">30</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:35.85}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$35.85</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:13}">13</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:37.72}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$37.72</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:5}">5</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:12.1}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$12.10</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:26}">26</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:37.33}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$37.33</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:9}">9</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:12.1}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$12.10</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:8}">8</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:13.64}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$13.64</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:23}">23</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:35.85}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$35.85</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:17}">17</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:13.64}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$13.64</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:11}">11</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:37.72}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$37.72</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:26}">26</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:37.33}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$37.33</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:3}">3</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:37.33}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$37.33</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:6}">6</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:12.1}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$12.10</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:7}">7</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:37.72}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$37.72</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:28}">28</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:13.64}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$13.64</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:19}">19</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:35.85}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$35.85</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:26}">26</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:13.64}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$13.64</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:11}">11</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:37.33}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$37.33</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:24}">24</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:35.85}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$35.85</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:27}">27</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:37.72}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$37.72</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:21}">21</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:13.64}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$13.64</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:16}">16</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:35.85}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$35.85</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:15}">15</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:35.85}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$35.85</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:4}">4</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:12.1}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$12.10</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:29}">29</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:37.72}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$37.72</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:3}">3</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:13.64}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$13.64</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:14}">14</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:35.85}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$35.85</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:12}">12</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:37.72}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$37.72</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:10}">10</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:37.72}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$37.72</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:6}">6</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:35.85}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$35.85</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:8}">8</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:37.72}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$37.72</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:20}">20</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:37.33}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$37.33</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:22}">22</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:13.64}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$13.64</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:25}">25</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:37.33}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$37.33</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:2}">2</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:12.1}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$12.10</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:26}">26</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:35.85}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$35.85</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:30}">30</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:37.72}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$37.72</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:20}">20</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:37.72}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$37.72</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:28}">28</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:35.85}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$35.85</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:25}">25</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:12.1}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$12.10</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> <TR> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:17}">17</TD> <TD width="100px" height="30px" data-sheets-value="{&quot;1&quot;:3,&quot;3&quot;:37.72}" data-sheets-numberformat="{&quot;1&quot;:4,&quot;2&quot;:&quot;\&quot;$\&quot;#,##0.00&quot;,&quot;3&quot;:1}">$37.72</TD> <TD width="100px" height="30px">&nbsp;</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> Fri, 01 Jul 2022 16:09:27 GMT https://communities.sas.com/t5/New-SAS-User/How-to-Calculate-Gross-sales-Column-from-Order-Quantity-and-Unit/m-p/821307#M34900 LABRADOR 2022-07-01T16:09:27Z https://communities.sas.com/t5/New-SAS-User/How-to-Calculate-Gross-sales-Column-from-Order-Quantity-and-Unit/m-p/821309#M34901 <P>First figure out what is the name of the dataset. Let's say it is named HAVE.</P> <P>Second figure out what are the names of the variables. Let's say they are named QUANTITY and PRICE.</P> <P>&nbsp;</P> <P>Now you have the information you need to write some code.</P> <PRE><CODE class=" language-sas">data want; set have; gross = quantity*price; run;</CODE></PRE> Fri, 01 Jul 2022 16:22:58 GMT https://communities.sas.com/t5/New-SAS-User/How-to-Calculate-Gross-sales-Column-from-Order-Quantity-and-Unit/m-p/821309#M34901 Tom 2022-07-01T16:22:58Z https://communities.sas.com/t5/New-SAS-User/How-to-Calculate-Gross-sales-Column-from-Order-Quantity-and-Unit/m-p/821310#M34902 <P>Thanks!</P> Fri, 01 Jul 2022 16:29:27 GMT https://communities.sas.com/t5/New-SAS-User/How-to-Calculate-Gross-sales-Column-from-Order-Quantity-and-Unit/m-p/821310#M34902 LABRADOR 2022-07-01T16:29:27Z