cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
the_qrv
Level I

Use of N Categories(:column) from Summary table for script computations

Hi, I would like to inquire how to make use of N Categories(:X) resut in summary to make mathematical operations via script. It seems the :N Categories (:column) can not be used directly to do the computations, even if I rename or make another numeric column, blk_count. Here is what i have:

dt_ax = dt_X << Summary (

          Group (:abx),

          N Categories (:blk),

          Link to original table (0));

dt_X << Update (

          with (dt_ax),

          Match Columns(:abx = :abx),

          Ignore missing);

close(dt_ax, no save);

dt_X << New column("blk_count",

          Numeric,

          continuous,

          << set each value(blk_count == :N Categories( :blk ));

Appreciate all your inputs! Thanks in advance!

1 ACCEPTED SOLUTION

Accepted Solutions
Byron_JMP
Staff

Re: Use of N Categories(:column) from Summary table for script computations

This will give you the number of levels for a specified column:

dt_X<<new column("N Levels of blk", formula(

Summarize( x = by( :blk ) );

N Items( x );));

If you wanted to know how many rows are in each level then the Col Number function work:

Col Number( :blk, :blk )

JMP Systems Engineer, Health and Life Sciences (Pharma)

View solution in original post

2 REPLIES 2
Byron_JMP
Staff

Re: Use of N Categories(:column) from Summary table for script computations

This will give you the number of levels for a specified column:

dt_X<<new column("N Levels of blk", formula(

Summarize( x = by( :blk ) );

N Items( x );));

If you wanted to know how many rows are in each level then the Col Number function work:

Col Number( :blk, :blk )

JMP Systems Engineer, Health and Life Sciences (Pharma)
the_qrv
Level I

Re: Use of N Categories(:column) from Summary table for script computations

Thanks Byron for the help!