topic How to save custom quantiles to a table in Discussions

How to save custom quantiles to a table

75Innovation — Fri, 11 Oct 2019 14:13:16 GMT

Hello,

I have a continuous variable which I broke down using a custom quantile (instead of normal quantile, default in JMP). My custom quantile is 0%, 25%, 50%, 75% and 100%. The distribution platform shows the output but how can I save this to a table? If I click the red triangle --> save, I only see the option to save default JMP normal quantiles only.

Any ideas about how I can save the custom quantiles rather than the default JMP normal quantiles?

Thanks

Re: How to save custom quantiles to a table

Mark_Bailey — Fri, 11 Oct 2019 15:03:36 GMT

Right-click on the table with the quantiles and select Make Into Data Table.

Re: How to save custom quantiles to a table

75Innovation — Fri, 11 Oct 2019 16:58:53 GMT

Mark, Appreciate the reply. I was looking for a solution to add quartiles to the main data table. This was I can work on the base dataset along with quartiles. I can definitely use your solution and then create a formula column.

Re: How to save custom quantiles to a table

nanayOf3 — Fri, 05 May 2023 15:40:20 GMT

How do you write this action into a script?

Re: How to save custom quantiles to a table

jthi — Fri, 05 May 2023 17:09:38 GMT

Let JMP script it for you (if you have JMP16+ even easier)

1. Open your table

2. Create your distribution

3. Right click on the Quantiles table box and Make into Data table

Slightly Script from Enhanced log:

Names Default To Here(1);
// Open Data Table: Big Class.jmp
// → Data Table("Big Class")
Open("$SAMPLE_DATA/Big Class.jmp");

// Launch platform: Distribution
Data Table("Big Class") << Distribution(Continuous Distribution(Column(:weight)));

// Make TableBox into a Data Table
// → Data Table("Untitled")
Local({obj},
	obj = Data Table("Big Class") << Distribution(
		Continuous Distribution(Column(:weight))
	);
	Report(obj)["weight", "Quantiles", Table Box(1)] << Make Into Data Table;
	obj << Close Window;
);

The script can be "auto"built without enhanced log but you have to collected the scripts from different places (from distribution platform and from result tables table script)