JMP User Community

Latest Discussions

Using "Get Rows Where"

I need to use Get Rows Where to get the row with value that is just below certain value.In other words:I have a Date AI have a table with dates. I need to get the row where the date is the latest, but less than Date A Example:I have a date when person died.I have table with all event when somebody logged in into his account. There are dates before and after his death.I need to find the latest dat...
miguello

Discussions |
Feb 18, 2017 4:45 AM

7329 views | 3 replies
digits to appear as double digits

Hi The JSL script below is outputting a week number from a data in JSL. however it outputs the lower weeks as 1-9 in single digits however, I need these to appear in double digits ie 01 instead of 1, 02 instead of 2..etc. I am hoping someone knows a way to do this, any ideas would be great. JSL scriptST << New Column( "ww",Numeric,"Nominal",Format( "Best", 12 ),Formula( Week Of Year( :time ) ));
DKI

Discussions |
Feb 17, 2017 10:32 AM

8363 views | 3 replies
Saving files to created folder

Hi! Would like to save a table to a folder created with jsl (Line #7). I have created a variable for it so that I can use it when indicating the directory I want to save my table(Line #27). However, after running the script, the variable("output") does not return the dir path but just the value "1". Thus, I could not save to my intended directory. Am I missing someting here? Would appreciate any h...
Nalla

Discussions |
Feb 16, 2017 5:55 PM

8625 views | 3 replies
How to make this kind of graphs in JMP?

Hi, I'm new to JMP and have been trying to make some graphs similar to the following graphs (see picture) for hours just couldn't get it done. Basically, I conducted gluctose tolerance test on several people, so I have their blood glucose values in 0, 60, 120 and 180 minutes. What I did was to group these people into two groups, obese and non-obese. Now I want to make a graph that has two curves, ...
minamijupiter

Discussions |
Feb 16, 2017 5:11 PM

14090 views | 6 replies
Changing titles for oneway

My script below, first script, will not acknowledge any changes I make for set title. It keeps defaulting to "Oneway Analysis of PARAMETER_VALUE By Status" regardless of what I enter for set title.I have a script for distribution, second script, and I don't seem to have any problems with it so I'm not sure what is going on. Any ideas on what I need to change? Thank You Template_TM = Expr( TM =...
Herrera5238

Discussions |
Feb 16, 2017 9:44 AM

9771 views | 3 replies

Previous
Next

Latest Discussions

Using "Get Rows Where"

I need to use Get Rows Where to get the row with value that is just below certain value.In other words:I have a Date AI have a table with dates. I need to get the row where the date is the latest, but less than Date A Example:I have a date when person died.I have table with all event when somebody logged in into his account. There are dates before and after his death.I need to find the latest dat...
miguello

Discussions |
Feb 18, 2017 4:45 AM

7329 views | 3 replies
Make JMP Journal Transportable

JMP supports talks about "Building a JMP Journal Presentation". How can you create a journal that will still work when it is: Transported to another computer, possible switching between Windows and Mac, Viewable from a USB drive, no matter what drive/folder the host mounts the drive in.
kthompsn

Discussions |
Feb 15, 2017 10:45 AM

7731 views | 3 replies
Data Binding Associative Arrays

I recently had need to create some slightly complex data structures and started to play with associative arrays a little more. These are similar to dictionaries in other languages. Where they differ is that most languages to improve speed, when assigning an object in a dictionary to a variable it does a data binding. Essentially it makes it so both the dictionary and the variable refer to the s...
msharp

Discussions |
Feb 14, 2017 1:53 PM

4586 views | 0 replies
Automate a Gauge R&R with many measurement columns

I would like to know if you can take a "spec limit" file that is used to add limits to a capability study and use it to add limits to the column properties all at once to perform a gauge R&R without inputting them in one by one. I would like to get a precision to tolerance ratio and need the spec limits for all of the columns.
jjhartwi

Discussions |
Feb 14, 2017 11:41 AM

5547 views | 3 replies
Test column data type

Hi, Is there a simple way to test if the data type of a column is numeric and nominal? Thanks and regards, Jérôme
j_bonnouvrier

Discussions |
Feb 14, 2017 3:08 AM

6425 views | 1 replies

Previous
Next

Latest Discussions

Data Binding Associative Arrays

I recently had need to create some slightly complex data structures and started to play with associative arrays a little more. These are similar to dictionaries in other languages. Where they differ is that most languages to improve speed, when assigning an object in a dictionary to a variable it does a data binding. Essentially it makes it so both the dictionary and the variable refer to the s...
msharp

Discussions |
Feb 14, 2017 1:53 PM

4586 views | 0 replies
How to Maintain JMP Graphs Table Layout When Copy and Pasting into Word

For years I've had to build sets of graphs using the Fit Y by X platform. The graphs are simple: X-axis is always (1) a character, nominal column and (2) a numeric, continuous date/time column. The Y-axis is always numeric, continuous data (bins, registers, parameters). The result is a list of box plot on the left, time trend on the right. There could be many plots at a time. In JMP 12 (and I thin...
MIKE

Discussions |
Dec 14, 2016 8:48 AM

4912 views | 0 replies
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

5038 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

4127 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

5530 views | 0 replies