title: How to export xlsx files in SAS
body: <p>The following two exports, will give an error on my machine (in both SAS base and SAS Enterprise Guide):</p>
  
  <pre><code>proc  export data=  sashelp.shoes
              outfile= " D:\SAS\myfile.xlsx"
              dbms=xlsx replace;
         sheet="Shoes";
  run;
  
  proc  export data=  sashelp.class
              outfile= " D:\SAS\myfile.xlsx"
              dbms=excelcs replace;
         sheet="Class";
  run;
  </code></pre>
  
  <p>as these exports produce the following errors respectively:</p>
  
  <pre><code>ERROR: DBMS type XLSX not valid for export.
  ERROR: DBMS type EXCELCS not valid for export.
  </code></pre>
  
  <p>By browsing the internet I think that the problem is caused by exporting the file from a 64-bit SAS version to a 32-bit Excel version. </p>
  
  <p>I downloaded and installed <code>pcfilesrv__931401__win__en__web__1.zip</code> from the <a href="https://support.sas.com/downloads/package.htm?pid=893" rel="nofollow noreferrer">SAS Support website</a> and hoped it would solve the problem, however the errors still occur.</p>
  
  <p>Anybody with another idea?</p>
  
  <p>Specs:</p>
  
  <p>Windows 64-bit Operating System</p>
  
  <p>SAS Enterprice Guide 5.1 (64-bit)</p>
  
  <p>SAS Base 9.3 (64-bit)</p>
  
  <p>Excel 2013 (32-bit)</p>
  
  <p><strong>EDIT:</strong>
  @Grinvydas Kareiva mentioned in his answer that I needed the "SAS/Access Interface to PC Files". This installation wizard after running <code>setup.exe</code> in the zip file I downloaded from the SAS Support website (see above). 
  <a href="https://i.stack.imgur.com/YCOHR.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/YCOHR.png" alt="Install Wizard"></a></p>
  
  <p>However, when I run <code>proc setinit</code>, it doesn't show up anywhere (changed site number and name manually):</p>
  
  <pre><code>Site name:    'xxxxxxx'.
  Site number:  xxxxxx.
  Expiration:   01SEP2017.
  Grace Period:  62 days (ending 02NOV2017).
  Warning Period: 31 days (ending 03DEC2017).
  System birthday:   01NOV2016.
  Operating System:   WX64_WKS.
  Product expiration dates:
  ---Base SAS Software                                                                                    01SEP2017  
  ---SAS/STAT                                                                                             01SEP2017  
  ---SAS/GRAPH                                                                                            01SEP2017  
  ---SAS Enterprise Guide                                                                                 01SEP2017  
  ---SAS Workspace Server for Local Access                                                                01SEP2017
  </code></pre>
  
  <p>Am I doing something wrong?</p>