JMP User Community

Latest Discussions

Compare Rows by Group

Hi,I'm trying to write a script comparing rows by group but am having trouble figuring out how to do this In the table below, I'm trying to select rows that meet both of the following conditions within a group (i.e. by "Subject Number" column):Value in "Target # Days from Previous" column is greater than the row with a value of zero (in example below highlighted rows 71 through 82 have values g...
christine_kim0

Discussions |
Mar 25, 2020 6:55 AM

9123 views | 3 replies
Automating curve alignment based on a midpoint?

I am trying to figure out the best way to script aligning geometric shape data I am collecting from a sensor. The part we are measuring is 'bottom aligned', and we get 250 equally spaced points starting from a fixed z-height. The problem is that parts are not all exactly the same height, and the goal is to understand the differences in features near the top, relative to a flange that helps secur...
andersonmj2

Discussions |
Mar 24, 2020 7:41 PM

5133 views | 6 replies
Display a File Open Dialog Box for the user to select a Excel file

I created a SQL script using JMP SQL Builder New SQL Query( Version( 130 ), Connection( "JMP" ), JMP Tables( ["Limits" => "Source(Open( \!"C:\Jay\JMP\JMP Scripts\Python Scripts\JMP scripts\New folder\New folder\SQL 2\Limits.xlsx\!", Worksheets( \!"Limits\!" ), Use for all sheets( 1 ), Concatenate Worksheets( 0 ), Create Concatenation Column( 0 ), Worksheet Settings( 1, Has Column...
Jackie_

Discussions |
Mar 24, 2020 11:57 AM

6937 views | 5 replies
How to Journal platforms in a new window?

Hi, I have a simple question that I cannot figure out.I have created a simple UI with different ui elements and containvarious platforms (distributions, etc.). I know that to make these static,I need to journal them. All plots are embedded in the new windowwithin different outline, V Line and H line boxes and use differentfilters from the same data table. The new window resides in a jsl script fil...
AD1

Discussions |
Mar 24, 2020 9:21 AM

2431 views | 2 replies
Saving a table box window with HTML links as HTML Report

Hello, In JMP12, I have a scripted table box with hyperlinks that I want to save as an HTML report (or any other type of report that will keep the hyperlinks active). I get an error from JMP while saving the report with no error description in the log except "unknown". Is there anything I am missing? See the sample script below: path = Get Default Directory(); alist = {"a", "b", "c"}; nlis...
noviJSL

Discussions |
Mar 24, 2020 5:22 AM

3509 views | 3 replies

Previous
Next

Latest Discussions

Automating curve alignment based on a midpoint?

I am trying to figure out the best way to script aligning geometric shape data I am collecting from a sensor. The part we are measuring is 'bottom aligned', and we get 250 equally spaced points starting from a fixed z-height. The problem is that parts are not all exactly the same height, and the goal is to understand the differences in features near the top, relative to a flange that helps secur...
andersonmj2

Discussions |
Mar 24, 2020 7:41 PM

5133 views | 6 replies
Saving a table box window with HTML links as HTML Report

Hello, In JMP12, I have a scripted table box with hyperlinks that I want to save as an HTML report (or any other type of report that will keep the hyperlinks active). I get an error from JMP while saving the report with no error description in the log except "unknown". Is there anything I am missing? See the sample script below: path = Get Default Directory(); alist = {"a", "b", "c"}; nlis...
noviJSL

Discussions |
Mar 24, 2020 5:22 AM

3509 views | 3 replies
TXT file import issue

Dear JMP users, I am facing a problem while importing a TXT file. I am using the Following jsl instruction:Open("U:\Lib\PRODUCTION\Report_Prod.txt");I had no problem until a couple of weeks when it came that some data were missing. I could not understand why as data were visible in the file when importing the .txt file into Excel.Today, I finally tried to import using "Load Text File" jsl instruct...
J_Bonnouvrier1

Discussions |
Mar 24, 2020 4:55 AM

6767 views | 5 replies
How to replace the text in JSL thru User Interface(a dialog window)

Hi,I've been using SQL in my JSL, and declared 4 variables and set required value.(see below script)What I want is to create a new window as user interface.. when run this JSL, pop up the window first to allow user to input different values for the variables.For example: 1st run JSL, user input: x,y,z,n for the 4 variables, to achieve the effect like below:set @spec = 'x'
set @opn = 'y'
set @Loss = ...
steven_gong

Discussions |
Mar 24, 2020 12:15 AM

2654 views | 3 replies
How Do I Make a Data Column Numeric Continuous

I've been stumbling over this and haven't been able to find the proper syntax. In my data I have a column titled "InstHead_Serial", which is always a numeric value of 6 numeric characters, with no decimal. I want to treat the data as numeric in my analysis, but when it gets pulled in from our database it is character type data. I've been trying many permutations of the command below to conve...
Tom_Watson

Discussions |
Mar 23, 2020 5:48 PM

11888 views | 4 replies

Previous
Next

Latest Discussions

How do I calculate z-scores at different aggregation levels?

Hello, How do I use JSL to calculate Z-scores at different levels of aggregation? I am working with cancer mortality data (1999 - 2015) at the county-level. I need to calculate Z-scores to compare each county to the others within a state and all counties within the country. I cannot simply use the standardize function because it automatically takes an average of rates--which is invalid unless the...
Jmsouch

Discussions |
Feb 26, 2020 7:04 AM

2222 views | 0 replies
Calling Windows API ImageViewer.dll to display JPG files.

I am working with a very large database of image files and want to be able to display the file for the user for visual inspection from a script. I have been able to get the following code to load the DLL but get an error requesting a signature argument. Does anyone know how to get a signature string from the system to pass to the DLL. ERROR MESSAGE FORM LOG: Second argument to CallDLL must be a ...
DMeakin1

Discussions |
Jan 17, 2020 10:19 AM

2034 views | 0 replies
Running script from command line on MAC

Not a mac person. Does anyone know how to run a jsl script from command line on a mac? I specifically mean WITHOUT "//!" at the top of it. I have this but it only opens the file unless I have the "//!" open -g -W -a /Applications/JMP\ Pro\ 15.app/ $(pwd)/myscript.jsl
vince_faller

Discussions |
Jan 10, 2020 2:26 PM

1673 views | 0 replies
how to add confounding variable

I am working with a multi level data. Data is attached.In this dataset, I have 8- X variable: cumulative risk (continuous), all other risk (dichotomous). 3- Y variables: insurance and practice (dichotomous) and time (continuous)I have one confounding variable Age (continuous). I will have to add random effect to X variable. But I am confused how to add confounding variable to this analysis. Can an...
billi

Discussions |
Jan 6, 2020 9:39 AM

1608 views | 0 replies
Difference between std error in "Parameter Estimates" and "Least Squares Means Table"?

I am running mixed effects models and have noticed that the standard error for an effect in the "Parameter Estimates" table is different from the standard error reported in the Least Squares Means table for the same effect. How are they calculated differently? Thanks!
Ranae

Discussions |
Nov 26, 2019 11:44 AM

1689 views | 0 replies