title: how to format data in PROC SQL
body: <p>I have a little problem with formatting data from a PROC SQL on SAS 
  I want to make an extraction of several columns but specifying the position of each column and the length for example:</p>
  
  <pre><code>number (position 0 , length 10, fill the rest with zero on the right)
  Name ( position 11 , length 20 , fill the rest with spaces on the right)
  Date ( position 21 , length 8 , delete "/" between DD MM YYYY) ......
  </code></pre>
  
  <p>Thank you </p>
  
  <pre><code>proc sql; 
  create table CC as 
  select SUBSTRING(Num_Compte from 16 for 8) , 
      pmin.DANAIS, 
      pmin.CDNSDPTZ, 
      pmin.NNSCMNZ, 
      pmin.NOADR, 
      pmin.SIREN, 
      pmin.NIC, 
      pmin.NOM_PAT, 
      amin.LBLGMTPL, 
      amin.NOVOIE, 
      amin.CDTYVOI, 
      amin.LIBVOIE, 
      amin.LIBLD, 
      amin.CDPOST, 
      amin.LBLCDST, 
      amin.CDINSDPT, 
      amin.NINSCMN 
  from sasuser.toto 
  inner join saspcmb.pmin on SUBSTRING(Num_Compte from 16 for 8) = ident 
  inner join saspcmb.amin on SUBSTRING(Num_Compte from 16 for 8) = ident ; 
  quit;
  </code></pre>