JMP User Community

Latest Discussions

Extract numbers from strings of unequal sizes

I have a column of strings with embedded numbers. I know how to determine if these strings contains the correct text I am looking for, but not how to extract the values that come after each of these. If the string sizes were equal, I could just use the munger function based on the location, but this cannot be done since string size is not consistent. E.g "The fix in is abcde +0.2, there is more te...
dcietek

Discussions |
May 22, 2020 1:27 PM

3617 views | 3 replies
Creating tabs in JSL

Hey guys, I'm a very new user and my question is very basic, can you please help me understand how do I create tabs with content? For example instead of textbox X, X tab that will show Y and Z textboxes with it content.vlistbox( textbox("X", <<font color(blue), <<set font size(10), <<set font style("bold")), textbox("Y", <<font color(black), <<set font size(10), <<set font style("bold"...
Stas

Discussions |
May 22, 2020 1:14 PM

6425 views | 8 replies
Vertical alignment in Lineup Box

Hi,If I add some display boxes (blue color in the attached image) to a lineup box with two cols,and the right display box is lower than the left, I get this empty gaps (red color in the attached image).What is the way to align the children of the lineup to Top?Thanks.
tom_abramov

Discussions |
May 22, 2020 12:18 PM

6683 views | 9 replies
Data table screen size set by JSL script is not always saved with .jmp file

I find that, when I set the window size of a data table with JSL, then save it out, there's at least one mode where the window size settings don't seem to have been saved with the .jmp file. Instead, it seems that the window size settings from the last manually saved settings, (i.e., via the UI), are used for (or saved with) the .jmp file. The following code is made up of snippets from my JSL sc...
SteveTerry

Discussions |
May 21, 2020 11:13 PM

4225 views | 4 replies
Saving incremented variable names in For loop to a list

I am trying to 1) Open a series of files that are listed in the list Unique_Files2) If the file doesn't exist, then a dialog box opens up with a message indicating the file exists3) If the file does exist, then open the file in JMP4) If the file does exist, then add the data table reference name to the list UniqueTables Every other part of my script seems to be working except being able to create ...
user8421

Discussions |
May 21, 2020 5:39 PM

6359 views | 9 replies

Previous
Next

Latest Discussions

Extract numbers from strings of unequal sizes

I have a column of strings with embedded numbers. I know how to determine if these strings contains the correct text I am looking for, but not how to extract the values that come after each of these. If the string sizes were equal, I could just use the munger function based on the location, but this cannot be done since string size is not consistent. E.g "The fix in is abcde +0.2, there is more te...
dcietek

Discussions |
May 22, 2020 1:27 PM

3617 views | 3 replies
Creating tabs in JSL

Hey guys, I'm a very new user and my question is very basic, can you please help me understand how do I create tabs with content? For example instead of textbox X, X tab that will show Y and Z textboxes with it content.vlistbox( textbox("X", <<font color(blue), <<set font size(10), <<set font style("bold")), textbox("Y", <<font color(black), <<set font size(10), <<set font style("bold"...
Stas

Discussions |
May 22, 2020 1:14 PM

6425 views | 8 replies
Custom DOE - Issues with Continuous Factors, Runs only at Extreme Value

I have a custom experiment I'm setting up. I have 5 distinct surfaces I'm testing on. A, B, C, D, E. I added a second factor, "load" as continuous from 5 to 15 I added a third factor "hold time" as 5 to 30 When I run "Make Design" Im surprised to see multiple runs of the same combination with all values at the extreme of the 2nd and 3rd factor. Is there a reason it doesn't have me test any inter...
csf

Discussions |
May 20, 2020 9:23 AM

4305 views | 5 replies
Why do i get "Convergence Questionable: check iterations" when running standard least squares mixed model?

Hi All, I am a biomed PhD student, and hypothesise that a particular cell type increases at with different length of drug treatments (e.g. comparing PBS control to d12 of treatment to d19 of treatment). I have used JMP pro12 and run a standard least squares model. I have performed two experiments to test this, and have set the experiment code as a random effect. The other effect is treatment. I a...
emmahoulder

Discussions |
May 20, 2020 6:51 AM

3844 views | 4 replies
set data type for new column

Hi, How can I conditionally and programmatically set a data type for a new column? I have a workaround that covers numeric / character, and it could be extended for other types, but I'm trying to get the method below (marked 'not working') to work. The log shows it is not recognizing the type variable. I've tried a few things like parse() but have been so far unsuccessful.Names Default To Here( 1 ...
xeqapena

Discussions |
May 19, 2020 10:02 PM

1819 views | 2 replies

Previous
Next

Latest Discussions

How do I have two different chart types in a single graph using two axis?

While doing some research to answer this question, I found this article on the JMP community that helped me get started. How do I do a combination bar and line plot using Overlay Plot? Using the big class sample data example of height and weight I was able to create a bar chart for weight and a line plot for height on the same chart using the Overlay Plot. To do this, first clear the row s...
Bass_Masri

Discussions |
Apr 28, 2020 4:28 PM

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

2261 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

2061 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

1687 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

1624 views | 0 replies