Go to next iHi-
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=""></SELECT>Re: Go to next iThank you!!Re: Go to next iHi @nrodrig1
from the output you have
click CTRL and left mouse button on the red triangle of one of the plots. there, select "fit line" as in the picture.
Re: Go to next iHi, yes, that's the sort of output i'm looking for. However, I only see charts (bottom left screen shot). I apologize if i'm overlooking something very simple but i'm not seeing any way to pull up the regression r squared, y intercept or x coefficients. below are a couple of screen shots of my input and output. Is there something in the input screen i'm not selecting? In the output i've been clicking on down red triangles and right clicking my cursor all over the place but i can't seem to find anything that leads me to those diagnostics. Thanks!
Re: Go to next iI am not sure what coefficients you are looking for. Below is an output from a Fit Y by X, with Fit Line having been specified, and it has the reqression coefficients
Re: Go to next iWow 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?
Re: Go to next iHi @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
Re: Go to next iNot 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?
Re: Go to next iWould 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 )
);Re: Go to next iI 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.
