10-26-2016 08:31 AM
I'm currently using EG 7.12 (point & click - no programming) and when I run a query and eventually use that for a summary report. The problem I'm having is that a period (.) will display in each cell that does not have data and thus it creates a problem when I convert it to Exce and try to sum or filter that column.
Is there a way to adjust options to either show "nothing" or zero when there is no data for a cell)s) in a column/row?
10-26-2016 08:52 AM
Well, the problem is with the difference in understanding between SAS and Excel. SAS represents missing numbers as . to differentiate them from missing character values. Excel does not. You have many options here. Setting options missing=''; is one way, though bear in mind it covers your current session only and may cause confusion for other programmers. You could also change your sum in Excel to be a countif() and count non '.' values.
You could of course also just do a find and replace, or do the summing in SAS, then export the result - rather than using two applications to do one job, or export to Excel as text.