JMP User Community

Latest Discussions

removing duplicate items in a table

Hi All,i have a table with ~20 columns and about 500 rows, two of these columns are Serial No. and Time stamp, and the rest is miscellaneous measurment data.in some instances i have rows of data that have the same Serial No. but all other values are different.my goal is to write a script to clean up the data table so that only rows with unique Serial No. are left.I want to first select items with ...
bk

Discussions |
Jul 15, 2013 9:39 AM

12932 views | 3 replies
JMP formula : Missing value

JMP formula : Missing valueHi there~ ^^Could you do me a favor? Do you have any idea with this? I think this is a simple question, but I dont know yet.I want to select "Missing continous value" in formula.I wanna change missing continous values to "Unknow" with character value.
Steve_Kim

Discussions |
Jul 10, 2013 3:49 PM

13455 views | 2 replies
How to find and delete rows in a data table containing a text (or elements in a list)

I have a list containing a combinations of letters ... e.g A B C D...Column1ABCDABACADABCABD..... so forth or as a list e.g. mylist = {A, B, C, D, AB, AC, AD, ABC, ABD....}.While it is possible to find those cells starting with "AB" using Edit-Search-Find from the table menu, it is strange I cannot find a way to do this using JSL script.I would imagine something like:loc (mylist,"AB?") for a list ...
woongkim79

Discussions |
Jul 9, 2013 10:29 AM

9746 views | 2 replies
Can JMP open .zip archive contents?

Hello,I have a .zip archive with some tab delimited data saved as text files inside. I am wondering if there is a way JMP can open one of these text files as a data table directly from the .zip file. Based on the documentation I'm reading it sounds like this might be possible:http://www.jmp.com/support/help/Utility_Functions.shtml --> see Open() and the Zip arghttp://www.jmp.com/support/help/Ot...
poweruser87

Discussions |
Jul 3, 2013 7:58 AM

10052 views | 2 replies
How to set Fit Y by X Group to Vertical Layout

Hi,I am struggling with scripting a Fit Y by X Group to display graphs vertically instead of horizontally. Any suggestions? Example script is below. I am using JMP10.Thanks!/*bigClass = Open( "$SAMPLE_DATA/Big Class.JMP" );one = bigClass << Oneway( Y( :height, :weight ), X( :age ),);// How can I change the Oneway layout to vertical?(one << Report)[Outline Box( 1 )] << Horizontal( 0 );*/
rab2013

Discussions |
Jul 1, 2013 9:52 PM

8633 views | 2 replies

Previous
Next

Latest Discussions

Script Recall Button

I have a script that prompts user with a column dialog box to select columns for X-var, Y-var, etc. I want to add a "Recall" button so that when user clicks it, it will fill in the choices from last time automatically, like most of the JMP platforms do.

Can this be accomplished using column dialog box (using something like button("recall")), or could it only work for nonmodal dialog box? Also, is ...

Discussions |
Jun 21, 2013 2:01 AM

6671 views | 6 replies
Tables Tabulate Grouping Columns

I have a huge data sheet that I'm trying to simplify for easier understanding. I'm trying to group all the same dates together into one. I included two pictures of the successful before and after when I go to "Tables" -> "Tabulate" -> moves the INSPDATE to "drop zone for rows" and click on "Add Group Columns." That was the successful one. However, when I tried to do the same thing to anoth...
jfrosty7

Discussions |
Jun 18, 2013 10:13 AM

3726 views | 2 replies
How to do Zero Defect Sampling using JMP 10?

before there was a template (zds.jmp). But I can't find it anymore for this new version.How do you do ZDS now?Thank you!
archerwin

Discussions |
Jun 4, 2013 11:04 PM

3670 views | 1 replies
JMP Scripting

Hello I am new to JMP Scripting and wandering if there is way to use regular expressions ?I have huge tables and trying to stack them with JMP.So any help on how would i ...Data Table( "temp" ) << Stack( columns( :Name( "ABC0(1)" ), :Name( "ABC0(2)" ), :Name( "ABC0(128)" ) ), Source Label Column( "Label" ), Stacked Data Column( "Data" ), output table("npt"));I have DATA = ABC0 to 127 and (1 to ...
baba

Discussions |
May 31, 2013 11:46 AM

3029 views | 1 replies
Non Parametric density

Hi,

When I generate a bivariate plot and then request the Non Parametric density, how do I go about getting percentiles back into my data table, based on the quantile density contours?
I’d like to add one column to my input table that would tell me, for each observation, in which contour it falls.

Thanks,

G
adjgiulio

Discussions |
May 21, 2013 1:26 AM

3548 views | 2 replies

Previous
Next

Latest Discussions

How to do a clean uninstall of JMP9 on a Mac?

Wondering if this is as simple as dragging the application package to the trash. The OCD in me would like to also get rid of associated library and preference components. The manuals and online resources don't give any direction. And since I have JMP10 installed, I don't want to rip out resources shared with the new version.
uw_viromics

Discussions |
May 17, 2013 6:26 PM

3560 views | 0 replies
Mean Diamond Confidence Intervals

I'm doing a simple Oneway Analysis, ~10 groups each with # of data points ranging up to 20.I noticed that there are 2 95% CIs that are calculated:1. One set for each group in the Means and Std Dev report below the chart, where CIs are calculated off of the Std Dev of each individual group2. One set for the Anova, where the Std Dev of all groups are assumed to be the same (calculated off of the S...
gugiyu

Discussions |
Apr 23, 2013 2:39 PM

4127 views | 0 replies
Sensitivity and specificity calculation

Hi every one, Is there any suggestion to directly calculate sensitivity and specificity directly from JMP 9? I read some where there is some plug in or small app needs to be downloaded to JMP for this purpose Any ideasthanksAdil
adil

Discussions |
Mar 1, 2013 12:32 PM

3592 views | 0 replies
Chossing between Steel-Dwass All Pairs vs Dunn All Pairs for Joint Ranks

Hello,I have a time series (five time steps) of samples from a population of the same ~60 individuals, each sample being a haphazardly chosen (i.e. not completely random) subset of the 60. The sample sizes each time ranges from about 15 to up to 50, and the measurement I do for each individual in a sample is a continous variable that goes from 0 to 1.Since the sample sizes are different each ti...
avamk

Discussions |
Mar 1, 2013 11:54 AM

6267 views | 0 replies
3 Parameter Weibull

Is there any way to do a 3p Weibull in JMP and check to see whether it fits the data better than a 2p Weibull? I'm looking for something similar to Weibull++ ability to determine the best fit for a given data set.
gda

Discussions |
Feb 19, 2013 1:34 PM

3232 views | 0 replies