Date:         Tue, 14 Aug 2007 10:55:08 -0400
Reply-To:     "Fehd, Ronald J. (CDC/CCHIS/NCPHI)" <rjf2@CDC.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Fehd, Ronald J. (CDC/CCHIS/NCPHI)" <rjf2@CDC.GOV>
Subject:      Re: freq procedure
In-Reply-To:  <1187096062.608518.181210@22g2000hsm.googlegroups.com>
Content-Type: text/plain; charset=us-ascii

> From: aninha

> i am trying to get a cross table of two variables, but when
> the value is zero between two values of the different
> variables it just does not come out. and i need it to appear,
> anyone knows?

when there is no values in the cross-tab
SAS will not report it.

You need to create a format with zeros and use the PreLoadFmt option

see: sgf2007.236:
Getting the Most from PROC MEANS
Andrew H. Karp.

> It is most often used with CLASS statement options such as PRELOADFMT.

http://www2.sas.com/proceedings/forum2007/236-2007.pdf

Ron Fehd  the macro maven  CDC Atlanta GA USA RJF2 at cdc dot gov