How to do FIRST_VALUE() OVER in JMP script?

kyf — Wed, 26 Jun 2024 00:26:18 GMT

SELECT

FIRST_VALUE(..) OVER (PARTITION BY .. ORDER BY ..) AS ..

FROM ..

Re: How to do FIRST_VALUE() OVER in JMP script?

txnelson — Wed, 26 Jun 2024 01:47:14 GMT

Here are a couple of ways to do a similar selection

names default to here(1);
dt = 
// Open Data Table: Big Class.jmp
// → Data Table( "Big Class" )
Open( "$SAMPLE_DATA/Big Class.jmp" );

// Find the Name of the tallest person by sorting
sortDT = dt << sort(by(:height), order(descending));
value = sortDT:name[1];
close( sortDT, nosave );
show("Tallest by sorting",value);

// Tallest by selection
value = :Name[(dt<<get rows where( :height == col max(:height) ))[1]];
show("Tallest by selection", value );

topic Re: How to do FIRST_VALUE() OVER in JMP script? in Discussions

How to do FIRST_VALUE() OVER in JMP script?

Re: How to do FIRST_VALUE() OVER in JMP script?