[R] things that are difficult/impossible to do in SAS or SPSS but simple in R

James Reilly reilly at stat.auckland.ac.nz
Fri Jan 18 00:03:22 CET 2008

> 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

I believe the CLASSDATA option in PROC TABULATE lets you specify which 
values will show up in the table, including unobserved values.


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

More information about the R-help mailing list