title: Uploading data from SAS to SQL Server table and � showing up in some values
body: <p>I'm trying to connect from SAS to SQL Server and insert data into a table. Some columns may contain some accents in unicode. I have been using libname to connect to the server and using proc SQLl to insert into SQL Server.</p>
  <p>I have manually created the table on SQL Server such that most of the columns are in <code>nvarchar format</code>. However, I noticed after uploading data from SAS to SQL Server, some values show up as �.</p>
  <p>Question: I was wondering why some of the values show up as � and how I could resolve this.</p>
  <p>Note: encoding in SAS is <code>utf-8</code>, whereas encoding in SQL Server is <code>latin1</code></p>
  <p>Note2: If I were to export the data in SAS to a csv and then manually upload it to SQL Server, the issue seems to dissappear. But I am trying to find an automation way where I could directly upload from SAS to SQL Server</p>
  <p>Thanks</p>