cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Register to attend Discovery Summit 2025 Online: Early Users Edition, Sept. 24-25.
  • New JMP features coming to desktops everywhere this September. Sign up to learn more at jmp.com/launch.
Choose Language Hide Translation Bar
Robbb
This widget could not be displayed.
" alt = "Level III"/> Robbb
Level III

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

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

1 REPLY 1
jthi
Super User

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

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
));

-Jarmo

Recommended Articles