title: Calculate Column Percentage sas
body: <p>I have the following dataset: </p>
  
  <pre><code>Date        Occupation      Tota_Employed
  1/1/2005      Teacher         45
  1/1/2005      Economist       76
  1/1/2005      Artist          14
  2/1/2005      Doctor          26
  2/1/2005      Economist       14
  2/1/2005      Mathematician   10
  
  and so on until November 2014
  </code></pre>
  
  <p>What I am trying to do is to calculate a column of percentage of employed by occupation such that my data will look like this: </p>
  
  <pre><code>Date        Occupation      Tota_Employed   Percent_Emp_by_Occupation
  1/1/2005      Teacher         45               33.33
  1/1/2005      Economist       76               56.29
  1/1/2005      Artist          14               10.37
  2/1/2005      Doctor          26               52.00
  2/1/2005      Economist       14               28.00
  2/1/2005      Mathematician   10               20.00
  </code></pre>
  
  <p>where the percent_emp_by_occupation is calculated by dividing total_employed by each date (month&amp;year) by total sum for each occupation to get the percentage:</p>
  
  <p>Example for Teacher: (45/135)*100, where 135 is the sum of 45+76+14</p>
  
  <p>I know I can get a table via proc tabulate, but was wondering if there is anyway of getting it through another procedure, specially since I wanted this as a separate dataset. </p>
  
  <p>What is the best way to go about doing this? Thanks in advance. </p>