title: SAS - omit missing values on proc tabulate procedure
body: <p>I need help to omit missing values on proc tabulate procedure. I understand that by right proc tabulate do not calculate missing values. However, when I  do not specify /missing on the class variable, the result won't appear and the log shows a warning that says:</p>
  
  <blockquote>
    <p>WARNING: A class, frequency, or weight variable is missing on every observation. </p>
  </blockquote>
  
  <p>Below is the proc tabulate step of the dataset: </p>
  
  <pre><code>TITLE j=left "Jadual B1 : Jumlah penduduk mengikut kumpulan etnik, kawasan pihak berkuasa tempa'tan dan negeri, Malaysia, 2010";
  Title2 font=bold italic j=left "Table   B1 : Total population by ethnic group, local authority area and state, Malaysia, 2010";
  title3 " ";
  title4 j=left "Negeri : NEGERI SEMBILAN";
  title5 font=bold italic j=left "State";
  ods escapechar='^';
  
  proc tabulate data=WORK.DOSM order=data ;
  
      class DISTRICT NEW_ETHNICITY NEW_CITIZENSHIP  MELAYU BUMI_LAIN CINA INDIA LAIN Bumiputera /missing;
  
      var ID;
      table ALL DISTRICT=' ', ALL 
          NEW_ETHNICITY={LABEL=' '}* (( Bumiputera ={LABEL=' '}*  (MELAYU={LABEL=' '}* N 
  BUMI_LAIN={LABEL=' '} * N ALL) INDIA={LABEL=' '}*N  CINA={LABEL=' '}*N LAIN={LABEL=' '} *N ))
  
  
  
      NEW_CITIZENSHIP={LABEL=' '} 
      /Box='Daerah Pentadbiran/Kawasan Pihak Berkuasa Tempatan ^S={font_style=italic}
                                                          Administrative District/Local Authority Area' row=float;
  
      keylabel N=' ';
      keylabel all='Jumlah ^S={font_style=italic}/ Total';
      footnote font=arial bold j=left "Nota" font=arial bold italic "/Note:";
      footnote2 j=l f='ARIAL amt/bold' "^_^_^_^_^_^_^_^_^_^_^_^_^_^_^_^_^_^_^_^_^_^_^_^Angka-angka di atas tidak disesuaikan untuk kurang penghitungan.";
      footnote3 j=l font=bold italic "^_^_^_^_^_^_^_^_^_^_^_^_^_^_^_^_^_^_^_^_^_^_^_^The above figures have not been adjusted for under enumeration.";
  run;
  </code></pre>
  
  <p>And below is my output: </p>
  
  <p><a href="https://i.stack.imgur.com/DZvaQ.png" rel="nofollow noreferrer">Output</a></p>
  
  <p>But, I need the result to not show the missing values as per the image red highlighted columns.  </p>