About Georg

Georg

Can anybody please share how to switch the language Preference to English by JSL? We would like to ensure, that everybody uses the english Version of JMP. Thanks in Advance, Georg

Georg

In my JMP 15.1.0 (win10) in GB I can Change Background Color via context menu interactively.

Georg

Nonlinear platform can fit Parameters for freely definable formulas. Please check out corresponding documentation.

Georg

Perhaps you didn't change to "all files" in open dialog? JMP starts open dialog with "all jmp files", to see other files, you need to change this setting.

Georg · ‎09-18-2020

Sorry, I cannot answer, the Code works fine on JMP 15 with Win10 on my Computer, and the last two steps are quite Basic commands that should have been implemented in JMP 13 already (but I cannot check). Can you perform that both steps of select columns 6+7 and delete selected separately one after the other? e.g. by marking script line in Editor and Pressing the Play button. Where exactly is the Problem?

Georg · ‎09-14-2020

I'm not sure, too 🙂 This means, you Need to be more specific on what you Need. If you simply want to explore the values of a large table, you May want to use the columns viewer Columns->Columns viewer There you easily can compare columns of a large table.

Georg · ‎09-14-2020

This one deletes columns: Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); // make some copies of columns dt << New Column( "weight_copy", set each value( :weight ) ); dt << New Column( "height_copy", set each value( :height ) ); to_delete_lst = {}; For( i = 1, i < N Col( dt ), i++, For( j = i + 1, j <= N Col( dt ), j++, If( (Column( i ) << get data type) == (Column( j ) << get data type), // all celles are equal ? If( Mean( (Column( i ) << get values) == (Column( j ) << get values) ) == 1, Print( (Column( i ) << get name) || " equal to " || (Column( j ) << get name) ); insert into(to_delete_lst, j); ); ); ) ); // show list of equals Show(to_delete_lst); wait(3); dt << select columns(to_delete_lst); dt << delete columns;

Georg · ‎09-14-2020

"Show tree structure" May help you to adress the proper Position in the report. Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Cities.jmp" ); obj = Distribution( Column( :CO ) ); obj << Fit Distribution( LogNormal( Set Spec Limits for KSigma( 3 ) ) ); obj << show tree structure;

Georg · ‎09-14-2020

I'm not sure if I get you Right, for modelling you can select the columns that you think are important, so there is no Need to delete the column. You want to delete some rows where a column has the same value? Below is the Code for it: Otherwise please describe more in Detail what you Need, an example May be very helpful. Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); wait(3); dt << Select duplicate rows( Match( :age ) ); dt << delete rows;

Georg · ‎07-26-2020

Can be done by a formula using the if statement, there you are most flexible and can use conditions on other columns or even combinations of columns.

Georg · ‎07-24-2020

on my System (JMP Pro 15.0 or JMO 15.1) at Win10 it does not work. To be more precise: I open Big Class Right click on "Distribution" -> Copy Right click --> Paste --> Nothing changes!!! I would have expected a script named "Distribution 2" to appear. Copy works (because I can do paste into a new script window), Paste probably also works (overwriting the current script with the same Name, so Nothing changes in the view). But generating a copy of an existing script with a new Name does not work (i.e. replicating by adding " 2" to the Name doesn't work) And the Miracle is, that it works sometimes. Usually it works on the update script, and then a new one is created: "Update From Database 2" and it works on table variables like "SQL", there "SQL 2" is generated. Why doesn't it work Always? For example see table generated by below script. For "SQL" it works, for "Oneway" it doesn't. New SQL Query( Version( 130 ), Connection( "JMP" ), JMP Tables( ["Big Class" => "$SAMPLE_DATA\Big Class.jmp" ] ), QueryName( "SQLQuery1" ), Select( Column( "name", "t1" ), Column( "age", "t1", Analysis Type( "Ordinal" ), Numeric Format( "Fixed Dec", "0", "NO", "" ) ), Column( "sex", "t1" ), Column( "height", "t1", Numeric Format( "Fixed Dec", "0", "NO", "" ) ), Column( "weight", "t1", Numeric Format( "Fixed Dec", "0", "NO", "" ) ) ), From( Table( "Big Class", Alias( "t1" ) ) ), Where( In List( Column( "sex", "t1" ), {"M"}, UI( SelectListFilter( ListBox, Base( "Categorical" ) ) ) ) ) ) << Run

Georg · ‎07-23-2020

Often I just want to duplicate a table script (e.g. in table Big class) see screenshot. Via context menu in table property area I first do Copy and in a second step I do Paste. This in some case works (and an new script with the same Name and attached "2" is generated). Most times it does not work, why? What is the easiest way to duplicate a script? My only Workaround is to copy the Content and the Name into a new script. It's possible, but many more Manual work.

Georg · ‎07-22-2020

@Craige_Hales unfortunately I was not able to figure out how to do simple shapes as Spheres, planes and lines in the Scene. The Vector in the example is very impressive, but I Need simple shapes also. The Show properties command gives only three possibilities for adding markers, Ellipsoids and vectors. The platform is experimental, so would you recommend me to do Scenes with many spheres, some planes and lines in OpenGL or is there a way to do it in Graph 3D Box? Thanks! Add Markers [Action] [Scripting Only] (Draws n markers on the plot.) Add Ellipsoid [Action] [Scripting Only] (Draws an ellipsoid on the plot.) Add Vector [Action] [Scripting Only] (Draws a vector or arrow on the plot.)

Georg · ‎07-22-2020

@Alma1 , I do not know what data you have, an example would be helpful. In the below script (when you execute) you see a dataset and both t-test performed, giving different results. Generally, statistical Tests have preconditions, and t-test assumes normal Distribution of the dataset, pooled t-test assumes equal variance, t-test works also with different variance. This is because they work with mean and variance, and if that two numbers do not represent the data correctly, the method doesn't work. If you perform a t-test, and the assumptions are not valid, you cannot rely on the result. In the below example you can see different results for both t-Tests, but be Aware, that normal Distribution is also not valid in this case. You can find These results in the documentation also, and I found STIPS a quite good training to understand this stuff. Names Default To Here( 1 ); cdt = Open( "$SAMPLE_DATA\companies.jmp" ); cdt << Oneway( Y( :Name( "Profits ($M)" ) ), X( :Type ), Means( 1 ), t Test( 1 ), Mean Diamonds( 1 ), SendToReport( Dispatch( {"Oneway Anova"}, "Summary of Fit", OutlineBox, {Close( 1 )} ), Dispatch( {"Oneway Anova"}, "Analysis of Variance", OutlineBox, {Close( 1 )} ), Dispatch( {"Oneway Anova"}, "Means for Oneway Anova", OutlineBox, {Close( 1 )} ) ) );

Georg · ‎07-21-2020

Maybe this is a solution? If I'm not able (for what reason ever) to put a data request into one query, I perform first one query, and with that result I perform the second one. Please see below a script snippet, where the content of a first table column is taken into the sql query string for the second query. dt_First = New SQL Query( connection( First_cnx_str ), queryname( "dt_First" ), customSQL( First_sql ) ) << Run Foreground(); // save file to current directory Wait( 1 ); dt_First_name = dt_First << get name(); dt_First << save( curr_path || dt_First_name ); // get values as condition for Second query sample_lst = dt_First:Sample_NO << get values( ); // Prepare condition string cond_string = "and t1.sample_no in ( " || Char( sample_lst[1] ); For( i = 2, i <= N Items( sample_lst ), i++, cond_string = cond_string || ", " || Char( sample_lst[i] ) ); cond_string = cond_string || " ) "; // Place condition string into pg_sql Substitute Into( Second_sql, "__COND_STRING__", cond_string ); dt_Second = New SQL Query( connection( Second_cnx_str ), queryname( "dt_Second" ), customSQL( Second_sql ) ) << Run Foreground();

Georg · ‎07-21-2020

slope and intercept are different (independent) parameter of a model, so they will have a different confidence interval

Georg · ‎07-20-2020

Trying to write a script for this I found the following below working. JMP15@Win10. The first part opens two tables and starts some Reports, and the second Closes all report Windows post saving scripts to belonging tables. But when the report has a local datafilter, the script is not working any more (get scriptable object doesn't get the Right reference). Is there a way to find proper reference for each report window, to save the script and close the report? - Thanks // Preparation Names Default To Here( 1 ); dt1 = Open( "$SAMPLE_DATA/Big Class.jmp" ); dis = dt1 << run script( "Distribution" ); biv = dt1 << run script( "Bivariate" ); one = dt1 << run script( "Oneway" ); dt2 = Open( "$SAMPLE_DATA/Membrane.jmp" ); one2 = dt2 << run script( "Oneway" ); lst_scr = dt1 << Get Table Script Names; dt1 << Delete Scripts( lst_scr ); // delete all scripts lst_scr = dt2 << Get Table Script Names; dt2 << Delete Scripts( lst_scr ); // delete all scripts Wait( 5 ); // Script performance Names default to here(1); win_lst = Get Window List( Type( "Reports" ) ); For( i = 1, i <= N Items( win_lst ), i++, obj = win_lst[i][Outline Box( 1 )] << get scriptable object; obj << save script to data table; obj << close window; );

Georg · ‎07-18-2020

Unpooled is needed when variance is different

Georg · ‎07-18-2020

@Alma1 have a look at help -> sample data -> Calculators -> Hypothesis test for two means and follow the workflow (or excecute the script below). For learning Purpose I would also recommend to construct a data table from the summary statistics and perform the t-Test from menu Analysis -> Fit y by x, and Read the explanations JMP gives. Names default to here(1); open("$SAMPLE_SCRIPTS\Calculators\TestTwoSampleMeans.jsl");

Georg · ‎07-14-2020

Dear all, how can I get a trigger from JMP, that user has finished interactive query, and subsequently close the source table? Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); dt << JMP Query Builder(); // how to close dt on finished query? // close(dt, nosave);

Georg · ‎07-10-2020

Has anyone done this, is there any example? I would like to use JMP's 3D plotting capabilities to understand Location of Atoms in a Crystal lattice, to plot some crystallographic planes etc.

Georg · ‎07-08-2020

@markbailey thanks for the answer, you're Right, it is not really a normal Distribution, but also not that far away I think. Motivation for me is to Read out of the fitted Distribution some local maxima, and mixed normal model does that. I.e. some local maximum means some higher Density of yield at a certain value leading to one isolated cause for that yield Problem. Supposed the yield Distribution consists of several Independent causes at certain Level, each normally distributed. Looking at the CDF gives the best visual Impression for what I meant. There I see that mixed model is better (the orange model better fits the red curve than the mint one does). And JMP algorithim with SHASH models the sharp Edge at 100 best. I was surprised by that discovery. Seems that values at 100 get more importance (because there is much area I did not see in the graph below). But to do it Right in future, I should probably remove the values "100" from my real Distribution and try to make the fit again.

Georg · ‎07-08-2020

I played around to understand nature of experimental Distribution and used the nice workflow in JMP Pro 15.0 at Win10 for it (continuous fit --> fit all). JMP showed SHASH Distribution as best fit, where I found mixed normal to fit better. I was able to reconstruct the Problem with a modelled Distribution, see script below. Perhaps negative AIC is the Problem? In the Manual (chapter 3 Basic Analysis, Distributions, p91) I found also that the weighted AIC for the best Distribution is most near to 1. It is the case for SHASH, but it visually and really is wrong, I think. Any Suggestion what the Problem is? Names Default To Here( 1 ); // Compose a distribution with 70 rows random normal, and 30 rows fixed values Vec = J( 1, 70, Random Normal( 70, 25 ) ) || J( 1, 30, 100 ); // this distribution 70/10 would let JMP take the right guess, but with too small difference in AIC? // Vec = J( 1, 70, Random Normal( 70, 25 ) ) || J( 1, 10, 100 ); // cut off values larger than 100 Vec[Loc( Vec > 100 )] = 100; // Put it into table dty = New Table( "yield_distribution", New Column( "yield", set values( Vec ) ) ); dty << Add Properties to Table( {New Script( "Distributions_SHASHvsNormal", Distribution( Continuous Distribution( Column( :yield ), CDF Plot( 1 ), Fit Normal 2 Mixture, Fit SHASH ), SendToReport( Dispatch( {"yield"}, "Quantiles", OutlineBox, {Close( 1 )} ), Dispatch( {"yield"}, "Summary Statistics", OutlineBox, {Close( 1 )} ), Dispatch( {"yield"}, "Fitted Normal 2 Mixture Distribution", OutlineBox, {Close( 1 )} ), Dispatch( {"yield", "CDF Plot"}, "Distrib CDF", FrameBox, {DispatchSeg( TopSeg( 2 ), {Set Script( Pen Size( 1 ); Pen Color( -2600622 ); Y Function( SHASH Distribution( X, 1.13512094644709, 0.0115544235279409, 100, 9.38305371818249e-80 ), X ); )} )} ) ) ) )} ); dty << run script( "Distributions_SHASHvsNormal" );

Georg · ‎06-30-2020

@Mickyboy I cannot reproduce your Problem, for me it worked, see attached JMP file (JMP15@Win10). Perhaps you Need to again set the axis range, sometimes many steps at one don't work.

Georg · ‎06-29-2020

What are your Export Settings? Looks like there is a Special character used as delimiter for columns, that is not shown properly in "note.exe". Have a look at File --> preferences --> Text data files --> Export settings Does the example under Scripting index for Big Class ("Save as") work properly?

Georg · ‎06-29-2020

I agree to @nascif_jmp , as a platform switch Always is a Chance to have Trouble. Why also not Performing the whole Job in jmp? By the way, the Shell call for a jmp Job works as simple as follows: Path2JMP\jmp.exe script.jsl and if the script starts with "//!", it is excecuted on Opening, and you can quit at the end. See Scripting guide --> getting started (or search for //!) //! Names Default To Here( 1 ); // here Comes the JMP Job ... Quit();

Georg · ‎06-29-2020

@crystal007 there is many excellent Information in the program on this, e.g. have a look at some examples in the statistic index (Help --> statistics index), or in other sample tables in the report press "?" and Point to the part of report you have Questions about in the Manual (multivariate Methods, chapter 4 PCA) ...

Georg · ‎06-25-2020

Thank you all for so much proposals, I'll try them out and will find a good solution.

Georg · ‎06-24-2020

@vince_fallerthanks, in my case a jmp table is preferred, I have a small table, that I Need to edit (by JMP). In another case, when I would have large tables, that are used by many users, also a jmp table would be better, because conversion is not needed, wouldn't it? Additionally the jmp table has more functionality (scripts, data types …), so I would Always prefer jmp table as filetype.

Georg · ‎06-23-2020

Thanks @ih for your solution, it is nice and well programmed, so I will try to work with it. In a first test I saw still some Timing issue (I suppose), because a reference was (not yet) valid. Introducing a wait for several seconds in the Statement "onRunComplete" then worked, but is not the solution. I think that's why I earlier decided to query available tables before referencing it. I will further test it.

Date Registered	‎09-05-2017 04:21 AM
Date Last Visited	7 hours ago
Total Messages Posted	70
Total Kudos Received	47

Online Status	Offline
Date Last Visited	7 hours ago