I am exporting a lot of Excel files from SAS EG, and using these Excel files to create summary reports. My 'go-to' tool in Excel is the handy dandy Pivot Table. Here is my basic issue:
When I use a Pivot Table to "Count" the number of observations within a particular field, the number returned is always equal to the total number of lines in the Excel tab the Pivot Table is sourced from.
Speaking with a few other SAS users in my organization, they are suggesting there are "unprintable" or "hidden" characters which are in those fields, and therefore being counted by the Pivot Table.
I am looking for a way to change my settings, or alter some code, in SAS EG, so that the Excel file being exported comes out without these "unprintable" or "hidden" characters.
Anyone experienced and solved this issue in the past?