title: Copy table from SQL Server to Oracle in SAS- Column Names Too Long in SQL Server
body: <p>We are trying to copy a full table from a SQL Server database to Oracle in SAS EGuide while keeping the column names. Unfortunately, some tables in SQL Server have column names longer than the 32 character SAS limit. </p>
  
  <p>For example, the "USR" table in SQL Server has a field "Identity_Source_System_Modified_On" and SAS truncates the column to "Identity_Source_System_Modified_". The column label in SAS maintains the full name. </p>
  
  <p>Is there a way to create this table in Oracle using the column label as opposed to the column name? Or another way to copy this table without SAS truncating the column name?</p>
  
  <pre><code>libname DEST oracle user=&amp;user. pass = &amp;pass. path = 'ORACLE100' 
  schema=TESTSCHEMA buffsize = 25000;
  
  proc sql;
  connect to odbc (uid="&amp;user." pwd="&amp;passsql." dsn='goven');
  create table User_Table as select * from connection to odbc
  (
  select * from dbo.USR  
  );
  disconnect from odbc;
  quit ;
  
  proc sql;
  create table Dest.USR as
  select 
  *
  from work.User_Table;
  quit;
  </code></pre>