JMP User Community

Latest Discussions

Multiple file import update data table in place

Hey,I'm using MFI to concatenate multiple .csv files from folder(folder gets new files dropped in it every day) for analyzing data in JMP. I have also prepared couple scripts for analysis and data cleanup but my problem is that every time I run script for MFI it opens up a new data table without my prepared scripts for analysis :(I wonder what is the way right way to update my current data table i...
morussk

Discussions |
Apr 17, 2020 9:36 AM

4457 views | 6 replies
DOE to test taster's ability to predict color of candy (for kids)

Dear JMP & Community, During this time of being stuck at home with kids and working on school projects, I thought of running a "taste test" with my son who recently claimed that he could tell the color of a chocolate candy based on the color of the candy shell (it's a candy similar to that of M&M). I'm not entirely sure how to set up the DOE because it doesn't quite fall under Choice or MaxDif...
SDF1

Discussions |
Apr 17, 2020 7:59 AM

7470 views | 11 replies
How to merge Text/Character ?

Dear Sir I try find the related discussion before, but it seems not easy.I would like ask how to merge Char.A + Char.B in new column, thank you. Char.AChar.BMergeA01A.01B02B.02C03C.03D04D.04E05E.05F06F.06G07G.07
StevenChan

Discussions |
Apr 17, 2020 7:49 AM

4246 views | 3 replies
how to use contains within match?

I have some text in a listA.I want to create another listB based on the value in listA.If the listA text contains apple then list B should be fruit;if list A has tomato listB should be vegetable;if listA has daisy listB should be flower.If none of these match then listB should have unknown.Also search needs to be case insensitive. Looking for something equivalent to case statement in JMP.I'm explo...
ENTHU

Discussions |
Apr 17, 2020 5:43 AM

4351 views | 6 replies
Any way to close all tables EXCEPT the table of interest?

Hi Guys,

Is there any way to close all the tables open in the JMP except the table of interest?

I tried using the close all(Data tables) command and it closes all of them. Also I don't want to individually close every table because I have several tables open.

Thanks.

Discussions |
Apr 16, 2020 10:12 PM

14420 views | 4 replies

Previous
Next

Latest Discussions

Multiple file import update data table in place

Hey,I'm using MFI to concatenate multiple .csv files from folder(folder gets new files dropped in it every day) for analyzing data in JMP. I have also prepared couple scripts for analysis and data cleanup but my problem is that every time I run script for MFI it opens up a new data table without my prepared scripts for analysis :(I wonder what is the way right way to update my current data table i...
morussk

Discussions |
Apr 17, 2020 9:36 AM

4457 views | 6 replies
DOE to test taster's ability to predict color of candy (for kids)

Dear JMP & Community, During this time of being stuck at home with kids and working on school projects, I thought of running a "taste test" with my son who recently claimed that he could tell the color of a chocolate candy based on the color of the candy shell (it's a candy similar to that of M&M). I'm not entirely sure how to set up the DOE because it doesn't quite fall under Choice or MaxDif...
SDF1

Discussions |
Apr 17, 2020 7:59 AM

7470 views | 11 replies
how to use contains within match?

I have some text in a listA.I want to create another listB based on the value in listA.If the listA text contains apple then list B should be fruit;if list A has tomato listB should be vegetable;if listA has daisy listB should be flower.If none of these match then listB should have unknown.Also search needs to be case insensitive. Looking for something equivalent to case statement in JMP.I'm explo...
ENTHU

Discussions |
Apr 17, 2020 5:43 AM

4351 views | 6 replies
Bezier interpolation

Hi, Is there a function to plot Bezier interpolation?
mitulshah

Discussions |
Apr 16, 2020 6:38 PM

8384 views | 11 replies
How to analyze the weather pattern data?

I wanted to know whether due to climate change, the precipitation in the last 16 years (2004 to 2019) had changed from the previous 15 years (1989 to 2003). Our hypothesis is that the weather patterns has changed and precipitation in the last 16 years had increased. Here is the annual average data for different years. Year Precipitation (mm) 1989 384 1990 446 1991 471 1992 491 1993 507...
manphoolfageria

Discussions |
Apr 16, 2020 7:06 AM

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

2206 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

2016 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

1660 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

1600 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

1681 views | 0 replies