nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Go to next i

nrodrig1

Hi-

I have a dataset that has many "Supplier_part_number" combinations. I want to make a new table for each subset of these combinations. I want to only make one for each "Supplier_part_number" combination so i created a "FLAG_keep" column which is just an if statement that says if "Supplier_part_number" ==Lag("Supplier_part_number" ,1) then "FLAG_keep"=1 otherwise it equals 0 . Gives me a table for i=1. Then seems to just stop. i=2 and 3 have :FLAG_keep[i] ==1 so i expect not to get anything. but then i=4 has :FLAG_keep[i] ==0 and i don't get anything.

I tried mimicking the work here https://community.jmp.com/t5/Discussions/Break-Continue-a-nested-outer-for-loop/td-p/8885 but still seem to be doing something wrong. Grateful for any help. Thanks!

dt= data table("master_dataset for regressions");
for(i=1,i<=10,i++,
	if(:FLAG_keep[i] ==1, Break());
		dt<<Select Where( :Supplier_part_number ==:Supplier_part_number[i]);
		part_of_interest_1 = :Supplier_part_number[i];
		selRows = N row( dt << Get Selected Rows );
		dtsub = dt << Subset( output table name("JoinedSubset"|| char(i)));
);
w= new window("done");

Accepted answers

ron_horne

Hi @nrodrig1

If the goal is to produce a separate regression (or any other graph or analysis) the best thing would be to keep the table in once piece and use the By option in each platform. this would produce separate outputs for each By group (make sure the variable you put in the By is ordinal or nominal).

https://youtu.be/pXI9YSOEggs?t=86

one you do that, you can also use the "make combined data table" to summarize your output neatly.

https://youtu.be/mxmbGr_y8_Y?t=50

let us know if this helps

ron

All comments

nrodrig1

I changed break to continue

if(:FLAG_keep[i] ==1, continue());

now it skips the first two cases where :FLAG_keep[i] ==1 but then makes tables for each other row regardless of what :FLAG_keep[i] value is. Getting closer but I think there is some conceptual or logic that is key and i'm not getting.

vince_faller

Would subset by work for you?

Names default to here(1);
dt = open("$SAMPLE_DATA\Big Class.jmp");
dt << Subset(
	By( :age ),
	All rows,
	Selected columns only( 0 )
);

nrodrig1

Not sure i follow. i want a single table for each subset based on supplier_part number combination.

I will ultimately need to do regressions for each set within these supplier_part number combinations. My plan is to make table for each and within the table run a regression then use the some values from the regression output to map back to my main table. There might be a simpler way to do that and i'm open to suggestions. I can post table if you think that would help visualize?

ron_horne

Hi @nrodrig1

https://youtu.be/pXI9YSOEggs?t=86

one you do that, you can also use the "make combined data table" to summarize your output neatly.

https://youtu.be/mxmbGr_y8_Y?t=50

let us know if this helps

ron

nrodrig1

Wow this is great!

This has me much farther along but now brings me to another question which might have to do with the computing power or old jmp 12 version i have.

Fit Y by X isn't giving me the coefficients and R-Square statistics. Looks like i have to go through 'Fit Model' and that seems to have more bells and whistles to it. When i try to run the report with 300,000 rows approx 20,000 group by's it freezes. I can break it up into smaller groups - still a much faster way than what i was doing before. But just in case do you have any suggestions about the most efficient option to run 20,000 two indep var regressions?