Hi,
I have a SAS dataset that has a character column . format $255.
It has values just like other character columns.
When I create an excel extract using ods excel, for this particular column it shows the values as for example . This it does for all rows but only for this column.
I tried compress, trim and strip on this column thinking it could be reacting to spaces maybe. Didnt help.
Has anyone encountered this issue? What and how can I check if there are any special characters in that column in the SAS dataset that is causing this issue.
COMMERCIAL ????????????????????????????????????????????????????????????????????????????????????????????????????
The column itself has only the value COMMERCIAL.
... View more