BookmarkSubscribe
Choose Language Hide Translation Bar
Community Trekker

## 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),

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 ));

1 ACCEPTED SOLUTION

Accepted Solutions
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, Pharm and BioPharm Sciences
2 REPLIES 2
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, Pharm and BioPharm Sciences
Community Trekker

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

Thanks Byron for the help!