JMP script: If N categories > 5 script

[#1]

Hello Everyone,

I would like to create a condition in case there is more than 5 categories in my variable (column), and then the rest of my script is ran.

I think the "n items" function is the one I need: 

If(N items(:Y1)>5,	

However, it doesn't work and I received a error saying: bar argument (:Y)...

Please someone can help me?

Sebastien

[#2 · Accepted solution]

You will have to first get a list of possible categories before using N Items. One fairly simple one is using associative array:

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
If(N Items(Associative Array(:age)) > 5,
	show(N Items(Associative Array(:age)));
	show("if");
,
	show(N Items(Associative Array(:age)));
	show("else");
);

[#3]

That is exactly that I wanted!

Thank's a lot for your answer.

Sebastien