topic Re: refer to levels of variables in Discussions

refer to levels of variables

ezorlo — Sat, 10 Jun 2023 23:41:25 GMT

Dear Community

How do I perform a count of the levels of a variable?

In R i can type length(levels(x)).

example: the species of bacteria are levels of the variable "species"

best,

Re: refer to levels of variables

pmroz — Mon, 06 Dec 2021 13:34:48 GMT

If you want unique values in a list or table column here are some functions that will help. The first one is for a list:

/*
Function Name: get_unique_values
Description: Find the unique values in a list.  Uses an associative array
Arguments:
in_list		List to get unique values for
*/
Get_unique_values = Function( {in_list},
      {Default Local}, 
      tmp = [=> 0]; 
      Insert Into( tmp, in_list ); 
      tmp << get keys; 
);

For a table column:

/* Function Name	Get_Unique_Values_col
Description:	Get the unique values for a column.  For example:

	Indications
	------------
	AAAAA
	BBBBB
	AAAAA
	CCCCC
	CCCCC

unique_list = get_unique_values_col (:Indications)

will return {"AAAAA", "BBBBB", "CCCCC"}

Arguments:
dtcol		column descriptor to calculate unique values for
*/
Get_Unique_Values_col = Function( {dtcol},{default local},
// Eval/expr trickery to get this to work.
	eval(eval expr(
		Summarize(unique_list = By(expr(dtcol)))));
	unique_list;
);

Re: refer to levels of variables

Dan_Obermiller — Mon, 06 Dec 2021 14:22:40 GMT

If you prefer an interactive solution, use Tables > Summary. Put the column you want as a Group variable and click OK. The number of rows in the resulting data table is the number of levels.

Make the variable you want an ordinal or nominal variable. Use Analyze > Distribution.

Re: refer to levels of variables

ezorlo — Sat, 11 Dec 2021 19:18:27 GMT

Hi thanks for this interesting answer. I could not get it to work though. it is undoubtedly due to my lack of skills.

Re: refer to levels of variables

ezorlo — Sat, 11 Dec 2021 19:24:18 GMT

Thank you very much

In the histogram there is a line with "levels" , gives me exactly what i need.

still, at the risk of whining, the numbers of levels may be in the hundreds and it is cumbersome to scroll past the frequency table. I imagine there should be an easier way to find out how many unique values are in a column...

Re: refer to levels of variables

Dan_Obermiller — Sun, 12 Dec 2021 19:22:12 GMT

Then use the Tables > Summary approach. You may get a table with hundreds of rows, but the row panel at the bottom will tell you how many rows are in the table.

You can also look to see if this suggestion was put into the JMP Wish List. If it is there, kudo it to cast your vote to add this feature. If you don't find it there, then add it.

Re: refer to levels of variables

ian_jmp — Mon, 13 Dec 2021 10:17:19 GMT

'Cols > Columns Viewer' gives this kind of output with 'Show Summary':

Re: refer to levels of variables

ezorlo — Wed, 14 Feb 2024 12:39:29 GMT

Thank you!!

This is the best most direct way to find the number of levels.

It is a little "hidden" but at least it gives me what I need