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?
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.
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.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.