How to reference stat columns language independent or how to force English stat column names?

Robbb — Thu, 26 Jun 2025 09:56:08 GMT

Hi all,

I am trying to write a scripts that has to work in different language settings of JMP.

Parts of my script use the Summary function:

Summary(
	Group( :SomeColumnX, :SomeColumnY, :SomeColumnZ ), // number of grouping columns different each time
	N( :Result ),
	Mean( :Result ),
	Std Dev( :Result ),
	CV( :Result ),
	Freq( "None" ),
	Weight( "None" ),
	statistics column name format( "stat" )
);

The resulting column names are different depending on the language setting. For example JMP in English gives columns like "Mean", "Std Dev", etc. but in German I get "Mittelwert", "Std.-Abw." and so on. In other languages I get other column names.
But this is not supposed to be the end of my script. I would like to use those columns later in the script, e.g. in column formulas of new columns.
How to reference those columns language independent? What would also solve my problems is to force English stat column names independent from the current language settings. Is that possible somehow?

Thanks
Rob

Re: How to reference stat columns language independent or how to force English stat column names?

jthi — Thu, 26 Jun 2025 11:29:01 GMT

Which JMP version are you using? Have you faced issues already due to different languages? For example, this should work fine when you run it with JMP's display language set to German (in JMP 18.2)

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
dt_summary = dt << Summary(
	Group(:Age),
	subgroup(:sex),
	Mean(:Height),
	Include marginal statistics
);

dt << Update(
	With(dt_summary),
	Match Columns(:age = :age)
);
Close(dt_summary, no save);

dt << New Column("A", Numeric, Continuous, Formula(
	:"Mean(height, F)"n + :"Mean(height, M)"n
));

topic Re: How to reference stat columns language independent or how to force English stat column names? in Discussions

How to reference stat columns language independent or how to force English stat column names?

Re: How to reference stat columns language independent or how to force English stat column names?