JMP User Community

Latest Discussions

Update column with values when another columns contains specific value

Hi, I have two columns named 'Mailing country' and 'Mailing state'. Some of the rows under Mailing country particularly for USA does not contain any value. I would like to update Mailing country column with value 'USA' when Mailing state contains values corresponding to various state code in the US. I have close to 250,000 rows, so manually update is not possible. I am new to JMP and scripting...
Rini_Kar

Discussions |
May 18, 2020 3:24 PM

14098 views | 11 replies
Create and populates new columns based categories in an existing column

Hello, I'm trying to build a quick query in which a categorical column (test_article) is used to create a series of column which contains only a subset of the information. If the script works as intended, the table would end up with 2 new columns (PBS vs ...). test_articlemeasurementPBS vs 709547PBS vs 709139PBS1.23PBSPBSPBS1.456PBSPBS7095474.56709547EXCLUDE7091395.02EXCLUDE7091397091396.02EXCL...
Sburel

Discussions |
May 18, 2020 3:17 PM

2940 views | 4 replies
How can I edit Biplot Labels / How can I export editable biplot to Power Point

Dear Community, I have two questions regarding PCA biplot. 1. Is there a way to export biplot to Power Point that is editable. I have a very crowded plot and I like to change the position of the labels, change color, change font, highlight, etc... 2. Within JMP, how can I change font size & color of just the labels in the biplot? I want to have a separate font size and color for the labels (row la...
WineAroma

Discussions |
May 18, 2020 1:42 PM

4519 views | 3 replies
How to save data table(colored cells) to Interactive HTML?

Hi, When I saved 'dt_newin' as Interactive HTML and try to open the file (in chrome\explorer) the color in the columns disappeared.Is there a solution to this?Thanks dt_newin = New Window( "Data Tool", db); dt_newin() << journal; Current Journal() << Save INTERACTIVE HTML( "C:\Desktop\Report\Summary Data.html" ); Current Journal() << Close window( nosave );
Botzal

Discussions |
May 18, 2020 10:24 AM

3553 views | 5 replies
Can Virtual Join be done on 3+ Data Tables?

I have used virtual join on 2 tables with no issue.

When I try to bring in a third table it will not let me because a column can only have 1 linked reference.Without adding redundant columns, is it possible to virtual join 3+ data tables? Thanks for your help.
Kelly

Discussions |
May 18, 2020 9:45 AM

3920 views | 5 replies

Previous
Next

Latest Discussions

Sample Size for Weibull Distribution - Reliability

Hello,I have prior testing of n=22 samples, with 2 failure modes/locations. The Y of interest is lbf and ALL samples are tested to failure (no censoring). I want to use this data to determine the necessary sample size I must use for the same test to ensure that at least 95% of the selected population covered at a 95% lower confidence bound (Lower Spec limit). The aggregate data fits a weibull dist...
zjuv007

Discussions |
May 17, 2020 4:45 AM

3053 views | 1 replies
Make histogram and box plot in graph builder

In the distribution platform you can add a box plot to the histogram (attached pic 1).
Pic 1
How can I make a similar plot in Graph Builder? The reason that I am asking is I want to overlay it with a categorical parameter. I made those plots separately and attached them manually in Photoshop (see attached pic2). Pic 2 If such thing can be done much easier and faster in Graph Builder, which is usu...
shasheminassab

Discussions |
May 16, 2020 10:10 PM

5078 views | 3 replies
Display regression estimates' F-ratios?

Is there an option to display the F-ratio (square of the t-ratios) in the regression display of the *individual* estimates in Fit Least Squares? I know JMP displays the overall model F-stat, but I'm looking for the F-ratios for each independent variable alone.
MAS

Discussions |
May 16, 2020 4:01 PM

2820 views | 3 replies
script to find and replace portions of character entries in a column

In my data table, I have a column of data type Character with a column name of Size. The entries for the different rows in column Size are like 8 or so different variations of things like sglLrg500, sglLrg800, sglLrg150, etc. I would like to have a JMP script that can quickly replace sgl in each of the entries in Size with Sgl instead, so that sglLrg500 for example would become SglLrg500. I coul...
fbm73

Discussions |
May 15, 2020 12:05 PM

1956 views | 2 replies
How do I reference a column value as a reference line on a control chart?

Hi, I'm trying to create a script which generates control charts which plots net yields by WO that references a planned yield entry in the %Planned Yield. Since I'd like to create a chart for each product in my data table, and there is a different planned yield for each product, I need to create a reference to the %Planned Yield Column. I have created a script so that the control chart will genera...
ayuan6

Discussions |
May 14, 2020 9:33 AM

1605 views | 1 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

4487 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

2100 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

1936 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

1600 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

1550 views | 0 replies