topic Re: Getting rid of the no data period in SAS Enterprise Guide

Getting rid of the no data period

BillB — Wed, 26 Oct 2016 12:31:09 GMT

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?

Re: Getting rid of the no data period

Loko — Wed, 26 Oct 2016 12:41:24 GMT

Hello,

Usually a period is used in SAS to represent missing numeric values.

Try options missing=''; and see if it helps.

Re: Getting rid of the no data period

RW9 — Wed, 26 Oct 2016 12:52:40 GMT

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.

Re: Getting rid of the no data period

TomKari — Wed, 26 Oct 2016 13:12:04 GMT

Which EG task are you using to get your report?

Re: Getting rid of the no data period

BillB — Wed, 26 Oct 2016 18:15:53 GMT

Summary Tables Wizard