topic Re: subset in JSL -syntax issue in Discussions

subset in JSL -syntax issue

ShirAlpert20 — Thu, 27 Mar 2025 14:21:52 GMT

I'm trying to subset all the data in the row which the value in column: " is rejects?" ==Y to new table called rejects

I try several ways but non of them working and I get the error:
"Unexpected "Split_dt". Perhaps there is a missing ";" or ",".
Line 77 Column 1: ►Split_dt << Select Where( :is rejects? == "Y" );"

this code is part of larger script that create the column :"is rejects?"

when I run the all script I get the error above, but when I run it separately it is working.

what can I do to fix it?

option1:

rejects = Split_dt << Subset(
	Where(:is rejects? == "Y"),
	Output Table Name("rejects"),
	All Columns
);

option2:

Split_dt << Select Where(:is rejects? == "Y");
rejects = Split_dt << Subset(Output Table Name("rejects"), All Columns);

the full script:

Split_dt = Current Data Table();

Split_dt << New Column("is rejects?", character, Formula("N"));
Column(Split_dt, "is rejects?") << Delete Formula;

// Get the number of columns in the data table
numCols = N Cols(Split_dt);

// Iterate over each row in the data table
For Each Row(
// Iterate over each column starting from column 6
	For(colIndex = 6, colIndex <= numCols, colIndex++, 
// Get the column reference
		currentCol = Column(Split_dt, colIndex);
// Check if the value in the current cell is greater than 100 and "is rejects?" is "N"
		If(
			currentCol[] > 100 & :is rejects? == "N" & Contains(currentCol << Get Name, "BI")
			 == 0, 
// Change the value in the "is rejects?" column to "Y"
			:is rejects? = "Y";
// Exit the loop early since we only need one match
			Break();
		);
	)
);


rejects = Split_dt << Subset(
	Where(:is rejects? == "Y"),
	Output Table Name("rejects"),
	All Columns
);

Re: subset in JSL -syntax issue

jthi — Thu, 27 Mar 2025 14:23:31 GMT

I usually use Rows() when subsetting specific rows (you can also subset selected rows, but usually you end up performing unnecessary selects in the table when doing this).

This example will subset all rows which have sex == "F"

Names Default To Here(1); 

dt = open("$SAMPLE_DATA/Big Class.jmp");

rows_to_subset = dt << get rows where(:sex == "F");

dt_subset = dt << Subset(Rows(rows_to_subset), Output Table("Subset F"));

Re: subset in JSL -syntax issue

ShirAlpert20 — Mon, 31 Mar 2025 06:11:10 GMT

thank you for the quick response.
the solution you suggested give the same error :(

Re: subset in JSL -syntax issue

jthi — Mon, 31 Mar 2025 06:13:31 GMT

Which JMP version are you using? Did you try my example script?

Re: subset in JSL -syntax issue

txnelson — Mon, 31 Mar 2025 10:00:42 GMT

Try

rejects = Split_dt << Subset(
	Filtered Rows(:is rejects? == "Y"),
	Output Table Name("rejects"),
	All Columns
);