title: I am trying to import XLS data into my SAS via a proc import method. However when I run proc print to view it, it states that the data does not exist?
body: <p>Here is my code. The objective is to import and print the data from the xls file.</p>
  <pre><code>options nonumber;
  libname kenzie &quot;\\apporto.com\dfs\CGU\Users\kenziede-keyse_cgu\Desktop\INST483&quot;;
  run;
  proc import datafile = '\\apporto.com\dfs\CGU\Users\kenziede-keyse_cgu\Desktop\INST483\fh.xls' 
      out = kenzie.xlstosas DBMS = 'xls' replace; 
      getnames = no;  
      datarow=3;
      sheet = 'sheet1';
  proc print data = kenzie.xlstosas;
  run;
  
  data rename;
   set kenzie.xlstosas;
   rename A = ID 
          B = IDYR
          C = Year
          D = Country
          E = Political Rights
          ;
  proc print;
  run;
  </code></pre>
  <p>Any help would be very much appreciated! Also, would I just repeat the process to bring in more XLS sheets?</p>