Proc Summary not producing all combinations

[Sean_OConnor]

Folks,

I'm using a simple proc summary and a cross-tabulation of three variables which should give a combination of 216 rows of output. 

For some reason when I run this I'm not getting it however. Only getting 126 rows. 

The strange thing is that for some rows the count is . this indicating the cross tab does not exist in the dataset, but for others the cross tab isn't showing at all.

Can someone explain to me please why this occurs?

[PeterClemmensen · Accepted solution]

Show us your code please.

[ballardw]

If you want combinations of Class variables that do not actually exist in your data you likely are looking at wanting the COMPLETETYPES option on the proc.

I also suspect that you did not include the NWAY option so you get different _type_ levels that are summarizing only one variable (or 2 of 3) which would have missing values for the other class variable.

Show the code that you ran. Copy it from your editor and open a text box on the forum with the </> icon and paste the code.