JMP User Community

Latest Discussions

How do I delete rows of variable column numbers when all are missing data

I have an auto-generated dataset and some of the columns, those that have a substring "X_Clean" in it, will have some null values. Sometimes there are 2, 3, 4 or even 5 different columns, depends on the dataset. I want to delete the rows only when ALL "n" of these "X_Clean" columns have null values but never if at least one of them is populated with a value. I was thinking of doing a FOR loop to...
MuttonChops

Discussions |
Feb 10, 2018 8:47 PM

8507 views | 4 replies
How to check if a list contents is all numeric without loops

Hi,

I am writing some code which imports data and I would like to do some data checking similar to MessyTables for python.

Data can be accidentally imported as character due to "NULL" or similar being present in the data. After removing the common instances of these I would like to check the data again to see if it is numeric.
The easiest way to do this is to use Try() and Matrix() after removing a...
stephen_pearson

Discussions |
Feb 10, 2018 1:17 PM

17853 views | 8 replies
How to Add Row Legend to Control Chart Report & Hide Data Table

Hello, Once i've created a control chart script, how do i:1) Add a Row Legend to the PLOTS window based on TOOL?2) Hide the data table, but keep the PLOTS screen visible?
dt = Open Database( "Database1",
"SELECT
MEAS1,
TEST_DATE,
TOOL
FROM Data_Table_1
where Test_Date > sysdate - 365
order by test_date asc
",
"dt"
);

dt << Color by Column( :TOOL, Color Theme( "J...
Tom_P

Discussions |
Feb 9, 2018 9:40 AM

6027 views | 2 replies
Why DF of pure error of LOF test change when terms are added or removed from the model?

Hi JMPers, I was modeling with fractional factorial design 2(7-4) with 3 center points.When I change the terms in the model, DF of pure error in the LOF test also changes. (10 to 14) In Minitab it doesn't change with the change of the model (same DF = 2 for 3 replicates of center points). I think that DF of pure error is calculated from the number of pure replication ...
kimmbb

Discussions |
Feb 9, 2018 8:06 AM

12057 views | 8 replies
Column with dates

Hello, I've these columns:I would like to build a graph with de "Difference" on the axis Y (continuous values).it doen't work because the format is "caracter". How can I do it? thanks for your help. Françoise
Françoise

Discussions |
Feb 8, 2018 10:41 AM

10291 views | 6 replies

Previous
Next

Latest Discussions

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

4235 views | 2 replies
JMP 13 JSL that passes variables to oracle SQL statement

I am working with a collegue that has a JMP 13 script to is defining variables using Modal windows. User selection then sets variables that we want to pass into a open database section of our script in the SQL statement. Data table is updated for which oven is selected in the Modal window. We then select the oven column to pass this value into our SQL statement. Example. OvenList={18,22}; n...
steve_reinhart

Discussions |
Feb 6, 2018 12:36 PM

6393 views | 3 replies
Tabbox

I am trying to create a tab box display with a bivariate plot. I have the script that already generates the bivariate fit.what is the jsl code for creating tabbox?
jaysiri

Discussions |
Feb 5, 2018 8:06 PM

2746 views | 1 replies
Sample size estimation for mixed model designs

Hello, I am somewhat new to the concept of mixed model analyses for repeated measures but I believe that they will be of great use to my projects. One thing that I am having trouble grapping with is how to go about estimating what type of sample size I should be aiming for. ANOVA and t-test sample size calculations are easy to follow but I don't even know where to start for mixed model repeated me...
bio_grad

Discussions |
Feb 5, 2018 12:36 PM

5345 views | 1 replies
.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

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

3912 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

2902 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

3513 views | 0 replies