Hi Robert,

All you need to do to achieve the results with missing combination, just add the "missing" option on the Proc Tabulate.

Example:

Proc Tabulate data=xxx missing; class ........... ; var ............. ; table ..................... ; >------>>>> more sas codes <<<<--------< run;

Also if you want you missing values to appear as say '0' you can specify it in the sas options:

Example:

Options Missing='0';

>------>>>> sas codes <<<<-------<

Hope this helps.

Ming

Date: Thu Aug 08, 1996 03:53 pm EDT Source-Date: Thu, 8 Aug 1996 15:41:36 -0400 From: Robert Abelson EMS: INTERNET / MCI ID: 376-5414 MBX: ROBERTA@otsuka.oapi.com

TO: Multiple recipients of list SAS-L EMS: INTERNET / MCI ID: 376-5414 MBX: SAS-L@uga.cc.uga.edu BCC: * Ming Lee / MCI ID: 708-0955 Subject: Proc Tabulate -Reply Message-Id: 21960808195312/0003765414DC3EM Source-Msg-Id: <s20a0c97.002@OTSUKA.OAPI.COM> U-Sender: "SAS(r) Discussion" <SAS-L@uga.cc.uga.edu> U-From: Robert Abelson <ROBERTA@otsuka.oapi.com>

>>> Kevin F. Spratt <Kevin-Spratt@UIOWA.EDU> 08/08/96 02:23pm >>> I am running SAS 6.11 under OS/2.

I am having a problem with proc tabulate. A sample table specification is below:

Table q, a*b,c*(N*f=3.);

My problem is that all possible combinations of a*b may not occur at each level of q. Thus, a table might look like this:

q a b c1 c2 1 1 1 3 3 1 2 6 9 2 1 1 10 2 2 3 5

2 1 1 8 3 2 1 1 10 2 2 3 5

How can I specify the table so that I get

q a b c1 c2 1 1 1 3 3 1 2 6 9 2 1 1 10 2 2 3 5

2 1 1 8 3 1 2 . . 2 1 1 10 2 2 3 5

Thanks in advance.

____________________________________________________________________________ _________

Kevin F. Spratt Iowa Testing Programs & Spine Diagnostic & Treatment Center 224-C Lindquist Center University of Iowa Iowa City, Iowa 52242 (319) 335-5572 (voice) (319) 335-6399 (fax) Kevin-Spratt@Uiowa.edu (e-mail)

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

SAS has a Technical Support Document, TS-DOC 278, that deals with this issue. You can download it from ftp.sas.com.

______________________________________________________________________ |Bob Abelson |"Original thought is like original sin -| |roberta@otsuka.oapi.com |both happened before you were born to | |Otsuka America Pharmaceutical|people you could not possibly have met."| | | | |DoD #6877 |- Fran Lebowitz | |_____________________________|________________________________________|