title: merge SAS char to num
body: <pre><code>libname Prob 'Y:\alsdkjf\alksjdfl';
  </code></pre>
  
  <p>the geoid here is char I wanna convert to num to be able to merge by id;</p>
  
  <pre><code> data Problem2_1; 
   set Prob.geocode;     
   id = substr(GEOID, 8, 2);
   id = input(id, best5.);  
   output;
   run;
  </code></pre>
  
  <p>geoid here is numeric;</p>
  
  <pre><code>data Problem2_2; c
  set Prob.households;
  id = GEOID;
  output;
  run;
  
  data Problem2_3;
  merge Problem2_1
  Problem2_2 ;
  by    ID;
  run;
  
  proc print data =  Problem2_3;
  </code></pre>
  
  <p>*ERROR: Variable geoid has been defined as both character and numeric.
  *ERROR: Variable id has been defined as both character and numeric.</p>