JMP User Community

Latest Discussions

Crop Image and Insert Crop Into Data Table

I'm currently running a script that inserts a 1Mb image into a data table using the following simple script ( where :link to image is a network drive where the jpg is stored)Formula( Open( :Link to Image, "jpg" ) ),Due to the size of the image the data table is getting large ( I have ~1500 images) and have tried the crop function but cannot get the syntax correctone of the various ways I have trie...
d_barnett

Discussions |
Oct 12, 2016 6:33 AM

5182 views | 1 replies
Open Database() Errors

I've got a weird one today.....I've been working with several JSL scripts... each of them has several Open Database() Calls.. and if the Open Database fails for any reason.. I have always seen entries in the log file regarding the issue... I then borrowed code from log_execute_sql.jsl I found somewhere... and basically read the last 10 lines of the log fiel and display dialogs for users if an err...
klockk

Discussions |
Oct 11, 2016 4:30 PM

12094 views | 4 replies
unique variance for each variable in multiple regression

In the attached dataset and screenshot, I am trying to find the effect of prior academic achievement and SES on current achievement for students. How could I find the unique variance/semipartial correlation for each variance? I know it is not the square of standard beta for the variable. Any ideas? Thank you!

xiaoyaj0

Discussions |
Oct 10, 2016 5:30 PM

14497 views | 1 replies
How to check if values in one datatable exist in another datatable

All, I have 2 data tables (Table A and Table B) . Table A has a couple of 1000 rows while Table B has a couple of million rows . They have a common column lets say Col C - I want to get the rows of Table B which have matching values in Col C . for( i = 1, i <= N Rows( TableA ), i++, SelectedRows = TableB << Get Rows Where(TalbeB:ColC == TableA:ColC1 ); ); While this works to some ...
uday_guntupalli

Discussions |
Oct 10, 2016 1:33 PM

13643 views | 3 replies
Process Capability

Hello,Trying to add a list of the variables (“Process Variables”) in Process Capability plot.It works for single item from the list, but it does not work for whole list. lTest = Data Table("dtGoal") << get column names( numeric); Data Table("dtGoal") << Process Capability( Process Variables( eval(lTest[i]) ), // it works for any i// Process Variables( eval(lTest) ), // does not work _...
vladbondarenko0

Discussions |
Oct 7, 2016 8:49 PM

11342 views | 4 replies

Previous
Next

Latest Discussions

Crop Image and Insert Crop Into Data Table

I'm currently running a script that inserts a 1Mb image into a data table using the following simple script ( where :link to image is a network drive where the jpg is stored)Formula( Open( :Link to Image, "jpg" ) ),Due to the size of the image the data table is getting large ( I have ~1500 images) and have tried the crop function but cannot get the syntax correctone of the various ways I have trie...
d_barnett

Discussions |
Oct 12, 2016 6:33 AM

5182 views | 1 replies
How to save residuals from logistic regression?

I did logistic regression in the Fit Model platform, but could not find a place to save residuals. Any ideas? Thank you very much!
xiaoyaj0

Discussions |
Oct 6, 2016 6:37 AM

12388 views | 4 replies
How to record data preparation steps to data table

Hi,I have a series of scripts which help a user clean up the data and gathers some background information. It has already been answered how to save this data to the same folder as the data tables either from a platform or the log. I can also save limited data as table variable but not something like an associative array.If I want to ensure this meta-data is kept within the data table is the best ...
stephen_pearson

Discussions |
Oct 5, 2016 7:37 AM

4046 views | 2 replies
Opposite of Default Local

So, just some syntactical sugar.It would be really nice if there was an opposite of declaring local variables for functions.i.e. instead of:example= function({a,b}, {c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w}, c = a+b; d = c+a; //... x = v+w; y = x+b;);print(x,y);I could write:example= function({a,b}, {Default Local, x, y}, c = a+b; d = c+a; //... ...
msharp

Discussions |
Oct 4, 2016 6:58 PM

9002 views | 5 replies
I am having trouble getting any reliable background map to appear, including all WMS link I've tried and the NASA server. Can anyone please help me find a high resolution map of Scotland that I can use as a background map image?

I've been working on this issue for weeks now and still haven't made any progress. My survey data is long/lat tagged and will plot well in Graph Builder and bubble plot. I would really appreciate some help finding a high-resolution background image map of Scotland to use in my data presentations. The simple/detailed earth images are not clear enough; they show up quite pixelated and very hard t...
elliot_meador_s

Discussions |
Oct 4, 2016 6:50 AM

12726 views | 12 replies

Previous
Next

Latest Discussions

Odds ratios for multiway tables

On twitter earlier today, someone asked if the Cochran-Mantel-Haenszel (CMH) odds ratio (OR) test was available in JMP when the stratification variable is not the X in Fit Y by X. Anytime I need to go from two variables to more than two variables, the first place I look is Fit Model. The beauty of fit model is that not only can I use as many variables as I want, but I can consider interactions bet...
DonMcCormack

Discussions |
Aug 10, 2016 3:35 PM

4868 views | 0 replies
How to find ETA squared effect size for MANOVA?

Hello, Does anyone know how to calculate the eta squared value from a manova analysis in JMP? I know that the E and H matrices tab shows the sum of squares for each parameter, but which values do I use to calculate SStotal and SSeffect? In my model, I have 2 control variables (age and gender) and then a two way factorial. If only one of these variables (in addition to both control variables) is si...
nsalmano_stanfo

Discussions |
Aug 8, 2016 7:04 AM

3884 views | 0 replies
Is there an easy way to get the FWHM (full width half max) of a curve using JMP?

Dear JMP community,Is there an easy way to get the FWHM (full width half max) of a spectral curve using JMP? Finding the minima and maxima are fairly straightforward, but then calculating the FWHM seems to be much more laborious in JMP, especially if the data is sparse and we would like to interpolate to get more accurate intersections between the peak and the FWHM value. In my case, the peak is o...
mcjorge

Discussions |
Jul 22, 2016 8:13 AM

5150 views | 0 replies
Co-Kriging with JMP and Matlab

Hi!I was wondering if anyone already tried to work with Co-Kriging, using JMP together with Matlab. As JMP only fits Ordinary Kriging Models (Gaussian Process with Gaussian Correlation Function), I would like to send data (generated with Space Filling JMP Platform) from JMP to Matlab, fit the models there (Matlab), and bring the MODELS back to JMP, to use inside Profile Platform. Do you have any e...
samuelbbaco0

Discussions |
Dec 4, 2015 12:32 PM

3593 views | 0 replies
Interpreting canonical structure and scores in discriminant analysis

I'm trying to interpret the relative contributions of my variables in a discriminant function analysis of chemical data for three groups of rocks. In a stepwise, linear, common covariance discriminant function analysis I'm able to generate non-overlapping 95% confidence ellipses for my three groups with no incorrectly assigned data points using 6 variables. My understanding is that the scoring c...
amzipkin

Discussions |
Oct 20, 2015 3:25 PM

3570 views | 0 replies