Hi JeremyW, I don't think that it's that there are "unprintable" or "hidden" characters, so much as the way that the count function works in Excel Pivot Tables - it counts cells even when you consider them "missing". The solution is to sum a field that is either 1 or 0 when you want to provide a "count". You could use an Excel function to populate the cells in a "Counter" column. But, it is much neater to generate the column in your SAS dataset. The datastep statements to produces such "Counters" would be like: if CharVar1 = ' ' then CharVar1_Ctr = 0; else CharVar1_Ctr = 1; if NumVar1 = . then NumVar1_Ctr = 0; else NumVar1_Ctr = 1; Hope this helps.
... View more