cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
hogi
Level XI

Tabulate - N categories ?

Tabulate and Tables/Summary are very similar, but ...
hey, Tabulate, what is the difference between counting numerical and non-numerical categories?

 

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt << Summary(
	Group( :age ),
	N Categories( :sex )
);

dt << Tabulate(
	Show Control Panel( 0 ),
	Add Table(
		Column Table( Analysis Columns( :sex ), Statistics( N Categories ) ),
		Row Table( Grouping Columns( :age ) )
	)
);


Tables/Summary:
hogi_1-1719214892335.png

 

Tabulate: 

same settings, but Tabulate will fail and generate a warning:

hogi_2-1719214961320.png

hogi_0-1719214853066.png

1 ACCEPTED SOLUTION

Accepted Solutions
hogi
Level XI

Re: Tabulate - N categories ?

dirty workaround: 

 

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
Tabulate(
	Transform Column(
		"sex_num",
		Formula( Col Rank( :sex, <<tie( minimum ) ) )
	),
	Show Control Panel( 0 ),
	Add Table(
		Column Table( Statistics( N Categories ), Analysis Columns( :sex_num ) ),
		Row Table( Grouping Columns( :age ) )
	)
);

View solution in original post

2 REPLIES 2
hogi
Level XI

Re: Tabulate - N categories ?

dirty workaround: 

 

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
Tabulate(
	Transform Column(
		"sex_num",
		Formula( Col Rank( :sex, <<tie( minimum ) ) )
	),
	Show Control Panel( 0 ),
	Add Table(
		Column Table( Statistics( N Categories ), Analysis Columns( :sex_num ) ),
		Row Table( Grouping Columns( :age ) )
	)
);
hogi
Level XI

Re: Tabulate - N categories ?

fun fact:
for header statistics, N unique (= N categories)  is available for categorical entries:

hogi_1-1719221895224.png

 

... but not for continuous ones:

hogi_0-1719221821707.png