topic Re: ANOM in Discussions

ANOM

kd_kel — Mon, 15 Jul 2024 10:31:25 GMT

I have an ANOM summary report I generated in JMP. I wanted to extract the Group means in each row of the report and save to a new data table (Run Chart) using JSL scripting, any help ?

Re: ANOM

jthi — Mon, 15 Jul 2024 11:37:21 GMT

How does your run_chart_table look like? You could maybe use << Make Into Data table to the Oneway result table and concatenate that.

Re: ANOM

kd_kel — Mon, 15 Jul 2024 17:40:35 GMT

I want to assign the group means (pre and post group means ) from the anom summary report table to variables and then paste into pre and post columns of the data table below.

Re: ANOM

jthi — Mon, 15 Jul 2024 18:07:58 GMT

Below are few good options

Use make into datatable and concatenate
Get values into list/matrix, add as many rows as you have in those and use data table subscripting

And here is one possible script for the make into datatable + concatenate

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Drug.jmp");
dt_results = New Table("Results",
	Add Rows(0),
	New Column("FA", Character, Nominal),
	New Column("Pre", Numeric, Continuos),
	New Column("Post", Numeric, Continuos),
	New Column("Shift", Character, Nominal),
	New Column("Date", Numeric, Continuos)
);

ow = dt << Oneway(Y(:y), X(:Drug),
	ANOM(1, Show Summary Report(1), Point Options("Show Needles"))
);

tb = Report(ow)[Outline Box("Analysis of Means Summary"), Table Box(1)];
dt_ow = tb << Make Into Data Table;

Column(dt_ow, "Lower Limit") << Set Name("Pre");
Column(dt_ow, "Group Mean") << Set Name("Post");
dt_ow << Delete Columns({"Level", "Group N", "Upper Limit", "Limit Exceeded"});

dt_results << Concatenate(
	dt_ow,
	"Append To First Table"
);
Close(dt_ow, no save);

Re: ANOM

kd_kel — Tue, 16 Jul 2024 05:47:13 GMT

Thanks jthi !