JMP User Community

Latest Discussions

Save charts as ".jrp" file in JSL

Hi guysDuring my work I came across a requirement to save charts as report in JMP (".jrp" file) - a chart which created during a script run.After long day of trying all code combination for saving files in JSL it looks like there is no commend for saving in a "report" type - only journal (".jrn"), .pdf and others... Also, while searching in the forums I found that the last time someone asked simil...
ariel

Discussions |
Apr 18, 2020 1:52 PM

22474 views | 7 replies
Create a associative array from unique selected rows and row number

Hi All, I have table in which I have selected rows where subject is science or Math (using select where function). Now I want to create associative array which stores the row number of all selected with unique entries of a particular column.After that I want to start a loop for all keys of the associative array. Which will subset the rows from key[i] to Key[i+1] for each value. For Example: Row_Nu...
Rajat

Discussions |
Apr 17, 2020 5:34 PM

5514 views | 4 replies
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

4458 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

7479 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

4251 views | 3 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

4458 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

7479 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

4354 views | 6 replies
Bezier interpolation

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

Discussions |
Apr 16, 2020 6:38 PM

8423 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

2213 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

2019 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

1663 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

1602 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