I am having a problem getting my data to display in EG or a Stored Process using Proc Print. I’m able to query my data, and Send To Excel – which tells me it’s the proc print.
The error I’m getting is ‘ERROR: Invalid characters were present in the data.’ In some of my fields within the names would be the company’s trademarks. When I pull this information into EG, it will display in the field as a triangle with a question mark in the middle
(Field�Name – should have an ` above one of the letters).
However, when I go to do a report display with a proc print or proc report I get the error.
I’m running version 7.15 (7.100.5.5850) (64-bit) – this was not an issue before we did our upgrade. Is there something different I need to do now with this version?
I’ve tried adding this code to my field when I select my data from the tables, but it still does not work;
Compress(fieldname,,’kw’)
When I look in the log, it has 'ENCODING=UTF8'
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.