Date:         Fri, 5 Jan 2001 15:55:54 -0600
Reply-To:     Gregg Snell <Gregg.Snell@LABONE.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Gregg Snell <Gregg.Snell@LABONE.COM>
Subject:      Re: zero cells in proc freq
Comments: To: N Yiannakoulias <nwy@GPU.SRV.UALBERTA.CA>
Content-Type: text/plain; charset="iso-8859-1"

Add the 'missing' option to the tables statement:
        proc freq noprint;
        tables dayofyr*hour/list out=temp missing;
        run;

-----Original Message-----
From: N Yiannakoulias [mailto:nwy@GPU.SRV.UALBERTA.CA]
Sent: Friday, January 05, 2001 3:39 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: zero cells in proc freq


Hi all,

I'm using this:

proc freq noprint;
        tables dayofyr*hour/list out=temp;
run;

to dump an hourly count to a file.  This works fine except that zero events
are ignored.
So if no events occurred in hour five, hour five is skipped and no zero is
indicated.
I would be very happy if somone could help me with this simple problem,

N


--
----------------------