JMP User Community

Latest Discussions

How can I automate random row selection?

Hello All,I'm pretty new to JMP and even newer to JSL. I'm trying to write a script that subsets a number of rows based on the following specifications: if the original table has 1-15 rows, then the subset of the original table is 2 rows, if the original has 16-25 then the subset of that table is 3 rows, if the orginal has 26-90 then the subset table is 5 rows, etc. Basically just a script to aut...
danielsh

Discussions |
Jul 16, 2013 8:25 AM

9262 views | 2 replies
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

12930 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

13449 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

9741 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

10047 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

6666 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

3723 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

3668 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

3024 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

3543 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

3559 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

4125 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

3587 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

6264 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

3229 views | 0 replies