cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

Discussions

Solve problems, and share tips and tricks with other JMP users.
%3CLINGO-SUB%20id%3D%22lingo-sub-528044%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%EB%8B%A4%EC%A4%91%20%EC%97%B4%20%ED%96%89%EB%A0%AC%EC%97%90%EC%84%9C%20%EB%B0%98%EB%B3%B5%EB%90%98%EB%8A%94%20%EB%8D%B0%EC%9D%B4%ED%84%B0%EB%A5%BC%20%EC%B6%94%EC%B6%9C%ED%95%98%EB%8A%94%20%EB%B0%A9%EB%B2%95%EC%9D%80%20%EB%AC%B4%EC%97%87%EC%9E%85%EB%8B%88%EA%B9%8C%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-528044%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%EA%B0%90%EC%82%AC!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222022-07-29_18-37-14.png%22%20style%3D%22width%3A%20390px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222022-07-29_18-37-14.png%22%20style%3D%22width%3A%20390px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222022-07-29_18-37-14.png%22%20style%3D%22width%3A%20390px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222022-07-29_18-37-14.png%22%20style%3D%22width%3A%20390px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222022-07-29_18-37-14.png%22%20style%3D%22width%3A%20390px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222022-07-29_18-37-14.png%22%20style%3D%22width%3A%20390px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222022-07-29_18-37-14.png%22%20style%3D%22width%3A%20390px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222022-07-29_18-37-14.png%22%20style%3D%22width%3A%20390px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222022-07-29_18-37-14.png%22%20style%3D%22width%3A%20390px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222022-07-29_18-37-14.png%22%20style%3D%22width%3A%20390px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222022-07-29_18-37-14.png%22%20style%3D%22width%3A%20390px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222022-07-29_18-37-14.png%22%20style%3D%22width%3A%20390px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222022-07-29_18-37-14.png%22%20style%3D%22width%3A%20390px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222022-07-29_18-37-14.png%22%20style%3D%22width%3A%20390px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222022-07-29_18-37-14.png%22%20style%3D%22width%3A%20390px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222022-07-29_18-37-14.png%22%20style%3D%22width%3A%20390px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222022-07-29_18-37-14.png%22%20style%3D%22width%3A%20390px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F44405iD6FA159A4151ACD8%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%222022-07-29_18-37-14.png%22%20alt%3D%222022-07-29_18-37-14.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-528044%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CLINGO-LABEL%3E%EC%8A%A4%ED%81%AC%EB%A6%BD%ED%8C%85%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-528056%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%EB%8B%A4%EC%A4%91%20%EC%97%B4%20%ED%96%89%EB%A0%AC%EC%97%90%EC%84%9C%20%EB%B0%98%EB%B3%B5%EB%90%98%EB%8A%94%20%EB%8D%B0%EC%9D%B4%ED%84%B0%EB%A5%BC%20%EC%B6%94%EC%B6%9C%ED%95%98%EB%8A%94%20%EB%B0%A9%EB%B2%95%EC%9D%80%20%EB%AC%B4%EC%97%87%EC%9E%85%EB%8B%88%EA%B9%8C%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-528056%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%ED%82%A4%EC%99%80%20%EB%AA%B8%EB%AC%B4%EA%B2%8C%20%EC%97%B4%EB%8F%84%20%EB%B9%84%EA%B5%90%ED%96%88%EC%8A%B5%EB%8B%88%EB%8B%A4.%20%EA%B0%90%EC%82%AC!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-528260%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%EB%8B%A4%EC%A4%91%20%EC%97%B4%20%ED%96%89%EB%A0%AC%EC%97%90%EC%84%9C%20%EB%B0%98%EB%B3%B5%EB%90%98%EB%8A%94%20%EB%8D%B0%EC%9D%B4%ED%84%B0%EB%A5%BC%20%EC%B6%94%EC%B6%9C%ED%95%98%EB%8A%94%20%EB%B0%A9%EB%B2%95%EC%9D%80%20%EB%AC%B4%EC%97%87%EC%9E%85%EB%8B%88%EA%B9%8C%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-528260%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%EB%8B%A4%EC%9D%8C%EC%9D%80%20%ED%96%89%EB%A0%AC%EC%97%90%EC%84%9C%20%EB%B9%88%EB%8F%84%20%EC%88%98%EB%A5%BC%20%EA%B2%80%EC%83%89%ED%95%98%EB%8A%94%20%ED%95%9C%20%EA%B0%80%EC%A7%80%20%EB%B0%A9%EB%B2%95%EC%9E%85%EB%8B%88%EB%8B%A4.%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20Default%20To%20Here(%201%20)%3B%0Adt%20%3D%20%2F%2F%20Open%20Data%20Table%3A%20big%20class.jmp%0A%2F%2F%20%E2%86%92%20Data%20Table(%20%22big%20class%22%20)%0AOpen(%20%22%24SAMPLE_DATA%2Fbig%20class.jmp%22%20)%3B%3B%0Aar%20%3D%20dt%20%26lt%3B%26lt%3B%20getasmatrix(%20%7B4%2C%205%7D%20)%3B%0A%0A%0Adt_freq%20%3D%20New%20Table(%20%22dt_freq%22%2C%20private%2C%20New%20Column(%20%22groups%22%20)%20)%3B%0Adt_freq%3Agroups%20%26lt%3B%26lt%3B%20set%20values(%20ar%5B0%2C%202%5D%20)%3B%0ASummarize(%20dt_freq%2C%20Bygroup%20%3D%20by(%20%3Agroups%20)%2C%20ngroups%20%3D%20Count(%20%3Agroups%20)%20)%3B%0AClose(%20dt_freq%2C%20nosave%20)%3B%0AFor%20Each(%20%7Bvalue%2C%20index%7D%2C%20Bygroup%2C%20Bygroup%5Bindex%5D%20%3D%20Num(%20Bygroup%5Bindex%5D%20)%20)%3B%0Abygroup%20%3D%20Matrix(%20bygroup%20)%3B%0AtheReturned%20%3D%20bygroup%20%7C%7C%20ngroups%3B%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
lala
Level IX

How to extract repeated data in a multi-column matrix?

2022-07-29_18-43-04.pngThanks!

 

 

2 REPLIES 2
lala
Level IX

Re: How to extract repeated data in a multi-column matrix?

The height and weight columns were also compared. Thanks!
txnelson
Super User

Re: How to extract repeated data in a multi-column matrix?

Here is one way of retrieving the frequency counts from a matrix

Names Default To Here( 1 );
dt = // Open Data Table: big class.jmp
// → Data Table( "big class" )
Open( "$SAMPLE_DATA/big class.jmp" );;
ar = dt << getasmatrix( {4, 5} );


dt_freq = New Table( "dt_freq", private, New Column( "groups" ) );
dt_freq:groups << set values( ar[0, 2] );
Summarize( dt_freq, Bygroup = by( :groups ), ngroups = Count( :groups ) );
Close( dt_freq, nosave );
For Each( {value, index}, Bygroup, Bygroup[index] = Num( Bygroup[index] ) );
bygroup = Matrix( bygroup );
theReturned = bygroup || ngroups;
Jim

Recommended Articles