title: How to display analysis variable (0 - 1) as percentage using Proc Tabulate in SAS?
body: <p>Suppose I have this data set like this:</p>
  
  <p><a href="http://s749.photobucket.com/user/liverton11/media/employsample.jpg.html" rel="nofollow">Sample Data Set</a></p>
  
  <p>And I would like to set up a table using proc tabulate such that it will look like:</p>
  
  <p><a href="http://s749.photobucket.com/user/liverton11/media/sampletable.jpg.html" rel="nofollow">Sample Tabulate</a></p>
  
  <p>So far I have codes like this:</p>
  
  <pre><code>    PROC TABULATE
      DATA = EMPLOY;
      CLASS RACE STATE;
      VAR EMPLOYED;
      TABLE RACE*STATE, N EMPLOYED*SUM EMPLOYED*PCTSUM&lt;TABLE*RACE&gt;;
      RUN;
  </code></pre>
  
  <p>But it doesn't seem to give me what I want, is there anyway to fix it?  I know it is odd using 0-1 and treat employed as an analysis variable for this but my boss doesn't want any 'N' (0) columns, just the 'Y' (1) columns.</p>
  
  <p>Thank you!</p>