topic Question mark instead of dash in ODS Output in SAS Programming

Question mark instead of dash in ODS Output

Q1983 — Thu, 05 Nov 2020 20:13:51 GMT

Please forgive me but I cannot replicate the error I am getting. This is a general question

processing1 = 'Infosys – Distributed'

this is a snippet of code used in a dataset. In the dataset processing1 shows the value Infosys - Distributed.

However in ODS output the dash is replaced with ?

It appears ODS tagset ExcelXP is converting the dash to a ?. I realized I did not provide a sample however in general is there a way to get sas to show the dash instead?

Re: Question mark instead of dash in ODS Output

Kurt_Bremser — Thu, 05 Nov 2020 20:27:23 GMT

Make sure that the dash is a real dash and not some funny UTF character you got from a word processor.

Also try ODS EXCEL; TAGSETS.EXCELXP creates XML text files, which grows much larger than the xlsx (compressed archive of XML files) created by ODS EXCEL. And it might deal correctly with UTF characters.

Re: Question mark instead of dash in ODS Output

Kurt_Bremser — Fri, 06 Nov 2020 06:47:38 GMT

processing1 = 'Infosys – Distributed'
processing1 = 'Infosys - Distributed'

The first line is from your post, in the second line I typed the dash in manually; by looking closely, you can see the difference.