topic Regarding missing french accents in Excel output from SAS DI jobs in SAS Data Management https://communities.sas.com/t5/SAS-Data-Management/Regarding-missing-french-accents-in-Excel-output-from-SAS-DI/m-p/179508#M3608 <HTML><HEAD></HEAD><BODY><P>I am reading data from oracle tables and view into SAS DI jobs, my oracle tables contains english language data as well as french with accents. When my SAS DI jobs are executing to create a MS excel file report as output then it is not showing french accents. please assist.</P></BODY></HTML> Tue, 24 Feb 2015 05:27:52 GMT Ashvin28 2015-02-24T05:27:52Z Regarding missing french accents in Excel output from SAS DI jobs https://communities.sas.com/t5/SAS-Data-Management/Regarding-missing-french-accents-in-Excel-output-from-SAS-DI/m-p/179508#M3608 <HTML><HEAD></HEAD><BODY><P>I am reading data from oracle tables and view into SAS DI jobs, my oracle tables contains english language data as well as french with accents. When my SAS DI jobs are executing to create a MS excel file report as output then it is not showing french accents. please assist.</P></BODY></HTML> Tue, 24 Feb 2015 05:27:52 GMT https://communities.sas.com/t5/SAS-Data-Management/Regarding-missing-french-accents-in-Excel-output-from-SAS-DI/m-p/179508#M3608 Ashvin28 2015-02-24T05:27:52Z Re: Regarding missing french accents in Excel output from SAS DI jobs https://communities.sas.com/t5/SAS-Data-Management/Regarding-missing-french-accents-in-Excel-output-from-SAS-DI/m-p/179509#M3609 <HTML><HEAD></HEAD><BODY><P>First step: find out when the accents are gone. Then troubleshoot you locale settings for that connection / environment. </P></BODY></HTML> Thu, 26 Feb 2015 08:10:32 GMT https://communities.sas.com/t5/SAS-Data-Management/Regarding-missing-french-accents-in-Excel-output-from-SAS-DI/m-p/179509#M3609 LinusH 2015-02-26T08:10:32Z Re: Regarding missing french accents in Excel output from SAS DI jobs https://communities.sas.com/t5/SAS-Data-Management/Regarding-missing-french-accents-in-Excel-output-from-SAS-DI/m-p/179510#M3610 <HTML><HEAD></HEAD><BODY><P>This is very likely caused by different code pages. </P><P>As Linus points out: Determine where you loose the accents. Is it already when loading the data into SAS or only when you write the data to the Excel? What code page is used in Oracle and what code page is used in SAS?</P></BODY></HTML> Mon, 02 Mar 2015 04:35:57 GMT https://communities.sas.com/t5/SAS-Data-Management/Regarding-missing-french-accents-in-Excel-output-from-SAS-DI/m-p/179510#M3610 Patrick 2015-03-02T04:35:57Z Re: Regarding missing french accents in Excel output from SAS DI jobs https://communities.sas.com/t5/SAS-Data-Management/Regarding-missing-french-accents-in-Excel-output-from-SAS-DI/m-p/179511#M3611 <HTML><HEAD></HEAD><BODY><P>Hi Patrick,</P><P></P><P>This was resolved by changing the Unicode server setting to use proper encoding. Thanks</P></BODY></HTML> Thu, 12 Mar 2015 15:47:06 GMT https://communities.sas.com/t5/SAS-Data-Management/Regarding-missing-french-accents-in-Excel-output-from-SAS-DI/m-p/179511#M3611 Ashvin28 2015-03-12T15:47:06Z