JMP User Community

Latest Discussions

Output data table into pdf being truncated into few pages

Hi JMP expert, I want to export my data table into a journal and save into a pdf. But i found that my data table is being truncated. I want the data table to display in full in PDF. Please advise. Thanks. Here is my JSL script and input file
OneNorthJMP

Discussions |
Feb 19, 2018 9:34 PM

16003 views | 3 replies
HOW to delete the same data in the table？

dear， every time i go to menu which “row” to detele the same data ， i want to delete the same data in the table automaticly， and i don t know to how to write JSL how i do to write ？
TONYMA

Discussions |
Feb 19, 2018 5:46 PM

14173 views | 13 replies
Return a Specific Row With Multiple Criteria - For Beginners

I'm not new to JMP but I'm pretty much brand new to the scripting of this sort. I have a table with ≈8mm rows and 80 columns. Ive just updated it with 3 additional columns and 2,000 rows. I need to return a specific "Formation" from the 2,000-row update for each of the 8mm rows from the original table. I need to do so under a couple criteria. IF "well.name" = "Well.Name" AND "BitDepth" < "Fo...
jlrouquette

Discussions |
Feb 19, 2018 1:05 PM

20266 views | 28 replies
How do I script a recode into new column function?

Hi, I've been searching for an answer for this for a few hours, but oddly can't find one. I have data that represents the serial numbers of the answers a person has given each question. I need to recode the serial number into ranks, but keep the original answers. I need to do that for 90 questions (where each answer has a different serial number). What is the best way to do that? The only way I co...
Miki

Discussions |
Feb 19, 2018 12:41 PM

10213 views | 8 replies
Tabulate a variable column list

I am using the following to generate a column list, which varies but always has an "X_Clean" in the name:col_list = dt<<get column names(string); for(i=nitems(col_list), i>0, i--, if(!contains(col_list[i], "X_Clean"), remove from(col_list, i); ) );Now I'm trying to create a tabulate box but I'm unsure how to reference this col_list in the Analysis Columns. dtLUB= vlistbox(dt<< Tabulate(...
MuttonChops

Discussions |
Feb 19, 2018 7:48 AM

6228 views | 2 replies

Previous
Next

Latest Discussions

Overlay markers on multiple graphs

These are the graphs that I'm working in. I'm new to JMP and I've been trying to figure out how to make all three of these graphs have the same attributes that the bottom one has from the legend. I need all three graphs to use the same overlay markers and colors. Any help would be appreciated!
ebluhm

Discussions |
Feb 14, 2018 10:37 AM

2479 views | 1 replies
Axis in Loading plot of PCA in JMP

Hi, I am relatively new to PCA analysis as well as to JMP. How can I change the PCA loading values on the x and y axis of the plot that JMP rovides when you do a PCA analysis? Right now the default is PCA1 on x axis and PCA 2 on y axis. I would like to plot PCA3 on y axis and get a similar plot with the vectors showing in diff directions, labels etc.
helga55

Discussions |
Feb 13, 2018 1:39 PM

6941 views | 4 replies
using right y axis on graph builder and color coding

Hi, I am building a graph with graph builder. I have 4 variables that I am showing on the y-axis, two on the left axis and two on the right axis. I am using points, and would like the points to be color coded based on another variable (which happens to be color). The color coding is working only for the variables using the left axis. Is there a way I can color the right axis variables? Thanks!
tova

Discussions |
Feb 13, 2018 5:51 AM

5064 views | 2 replies
Create a formula for temporary variable

Hi all, im still new to JMP scripting. I need help to create a formula to make the value as a variable but with its own name. What i mean is as below. So, i want to create a formula that can make column 4 below as a variable for distribution graph. it is like Plastic = 0.424542 the problem right now is the formula name will be in the same which is t4 = :TYPE;:MIN;. So if i want to plot the min v...
mhalwi

Discussions |
Feb 11, 2018 3:04 AM

22044 views | 15 replies
Hive SQL Query builder - Performance issues

Hi Guys,I'm running JMP 13 and have used the cloudera hive ODBC driver to sucesfully connect the JMP query builder to our hadoop hive server. I am able to view the tables ok, but once i click on one of the tables it automatically sends a "select * from table" query to the hadoop cluster which completely hangs up my JMP due to the enormous size of the table its trying to pull without my consent. Is...
scott_87

Discussions |
Feb 7, 2018 10:11 PM

4234 views | 2 replies

Previous
Next

Latest Discussions

.jsl scripts will lock files even while set to read and execute permissions only

I am having an issue where an add-in script which runs another script via the include(); function is locking the included script file while other users are running it. This renders me unable to update that script. I tried setting the permissions on the repository and the file as read and execute only but it still locks when other users access it.
nbullen

Discussions |
Feb 5, 2018 12:05 PM

2470 views | 0 replies
Sub-sampling data analysis in JMP

In Biology (Plant Sci. and Agriculture) usually we have sub-sampling data for replicates. It's very difficult to analyze these data in commonly use Stat S/W (SPSS/Minitab) because MSS(Error) is calculating wrongly. Without taking averages of samsamples, the easiest S/W for this is using JMP and I need some assistance for this. I've found very useful Youtube video about subsampling in JMP (CRD: S...
Kynda

Discussions |
Nov 15, 2017 2:32 PM

3911 views | 0 replies
Conceptual question about the profit matrix

This issue has been discussed previously, but I keep finding myself confused about how to use the profit matrix. My question is conceptual in nature, so let's just use some simple numbers. Suppose I have data on customer churn and I build a predictive model for churn (the particular technique does not matter for this question). My decision errors are not symmetric, however, so I want to modify ...
dale_lehman

Discussions |
Nov 10, 2017 6:02 AM

2800 views | 0 replies
Confirmation of Repeated Measures Analysis, when sphericity if voilated

Hi Everyone, I would like confirmation on the appropriate analysis to run on a repeated measures design.Experimental design:Independent variable: Nutrient treatment (Control, Low, Med, High),Dependent variable: basal diameter, 5 replicates (plants)Repeated measurements were taken at Weeks 0, 1, 4, 7, 10, & 12Split data-> Fit Model-> Y: basal 0, basal 1, 4, 7, 10, 12, Add: Nutrient treatmentPers...
uamiller

Discussions |
Oct 23, 2017 8:07 AM

2899 views | 0 replies
Cox Proportional Hazard - adjusting risk ratio with std dev

I'm working with someone who is using SAS and I'm trying to do the same analysis in JMP. When I questioned their hazard ratio they said it was adjusted by the standard deviation. They commented:In order to obtain results in units of 1 standard deviation – you simply get the standard deviation value for parameter of interest and introduce it in the PH regression statement, for example:proc phreg ...
Maureen

Discussions |
Aug 22, 2017 1:18 PM

3511 views | 0 replies