title: Creating a new column in a table using proc sql, need to multiply four other columns together
body: <p>I'm creating a new table to count total billing by state. Total billing includes price, quantity sold, a discount per customer, and sales tax in each state. I need a new table that gives me the 50 states and the total billing in each state. </p>
  
  <p>I've tried simply multiplying the 4 fields together, but that hasn't seemed to work. </p>
  
  <pre><code>proc sql;
  create table jarod.total bill as
  select
      State_CD,
      Sale_ID,
      PriceOUT*(1-Discount)*(1+State Sales Tax)
  from jarod.sales
      order by State_CD;
  quit; 
  </code></pre>
  
  <p>I wanted to get the total sale price for each transaction, which i would then somehow sum by state (unsure how to do this either) but my table won't create due to error.</p>