title: yyyymm convert to full sas date (dd/mm/ccyy) - SAS
body: <p>I am trying to get the last day of the month from a field numeric in SAS (<code>ccyymm</code>).</p>
  
  <p>for example
  201401 would be 31-01-2014.</p>
  
  <p>I have managed to get the field to show as a date type field (still showing as ccyymm though) with the following code in a <code>PROC SQL</code> <code>SELECT statement</code></p>
  
  <pre><code>year_month_field INFORMAT YYMMN6. AS year_month_date
  </code></pre>
  
  <p>I think that I found some code from another question that had been asked that should give me the last day of the month once I can get the full date.</p>
  
  <pre><code>INTNX ( MONTH , year_month_date , 1) -1 
  </code></pre>
  
  <p>Will this work? If not any other suggestions would be appreciated.</p>
  
  <p>Dan</p>