> Max Kuhn wrote: >> Factors have huge benefits over character data in SAS. For a series >> regulatory filings, I had miles of SAS code to compute KxK tables >> where all the cells must show up. For example, if one of the levels of >> one of the variables was never observed, the corresponding row or >> column would not show up in proc freq. The basic way around this was >> to get all possible combinations of the variables and assign each cell >> to have a row count of 0.00000001. Then you would merge this data with >> the real counts. The missing row/columns would show up since they had >> data, but it was below the printing threshold of proc freq. Hoepfully, >> they have added a feature to do this. >> On 18/1/08 4:44 AM, Peter Dalgaard wrote: > I could have sworn that this was a fluke and that it would work if you > put a user-defined format on the classification variable, but no go.... > I can't find anything that does this, neither in PROC FREQ nor PROC > TABULATE.
I believe the CLASSDATA option in PROC TABULATE lets you specify which values will show up in the table, including unobserved values. http://support.sas.com/onlinedoc/913/getDoc/en/proc.hlp/a002473736.htm#a003069171 I'm not aware of any way to do this in PROC FREQ, though. -- James Reilly Department of Statistics, University of Auckland Private Bag 92019, Auckland, New Zealand ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.