JMP User Community

Latest Discussions

catch Sql Query error

HelloI want to update a database via the New SQL Query function:Names Default To Here( 1 ); obj = New SQL Query( Connection("DB connection string"), Custom SQL " UPDATE table SET Column_1 = 1 where Column_2 = '2' ") ); Error_Msg = Log capture( obj << Run;);I get the following error message:"" Error running SQL Query: [Server] Invalid object name tableLog Capture only get the empty "" str...
Mauro_Gerber

Discussions |
Jan 6, 2020 11:37 PM

10180 views | 11 replies
Open SQL database - user input (Dates) - Error converting data type varchar to datetime.

Hi,I'm trying to connect to a SQL database in a script using user input for dates.When I run the script I get the following error - "[Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type varchar to datetime." Please, how can I solve this problem?Thx nw = New Window( "test", H LIST BOX( Text box("Start Date"), a = numbereditbox(0),...
Botzal

Discussions |
Jan 6, 2020 11:30 PM

3443 views | 2 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

1505 views | 0 replies
EMP Gauge R&R - Reproducibility = 0%

Hi there! I've ran EMP Gauge R&R and the results show the total variation coming from reproducibility is 0%. However, when I look at the data there are considerable differences in the measured variable of the same samples between operators so I can't understand how the reproducibility variation is 0%: Can anyone help please? Thank you in advance, Alicia
Alicia

Discussions |
Jan 6, 2020 3:11 AM

12728 views | 9 replies
Get relative prediction variance values

Hello,I would like to make ternary plots showing the relative prediction variance of 3-component mixture DOEs.To do that, I would need to extract a high number of values (let's say 20,000) from the Prediction Variance Profile graph, and make a datatable with these values. This datatable would have 20,000 rows and 4 columns: X1, X2, X3 and the Relative Prediction Variance.Perhaps another way to do ...
dp30

Discussions |
Jan 6, 2020 1:23 AM

4944 views | 8 replies

Previous
Next

Latest Discussions

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

1505 views | 0 replies
ROC curve analysis: sensitivity at fixed specificity

Dear all,I'm a novice of JMP and I'm stunned with its great potential. I ask your help to solve my problem. I made a ROC analysis on a data set, and I need to calculate, based on ROC curve, sensitivity at fixed 80%, 95% and 99% specificity. The software doesn't seem to provide this option. I know I can approximate these values looking at the cut-offs in the ROC table, however it's only an approxim...
LgWagon

Discussions |
Jan 5, 2020 11:40 AM

2262 views | 1 replies
Saving an Empty Table with JSL

I'm opening several tables from a database, and then saving those into CSV files. The script works fine as long as the table has data, but empty tables (which I also want to save to show that they're empty) give me this error:

Data table is empty.

The file could not be saved.
Unable to save file.{2}

I can manually save the tables in JMP format, but not as a text export. Any ideas?
afterword

Discussions |
Jan 3, 2020 1:56 PM

5257 views | 3 replies
interactive html and local data filter in jsl

Hi,I want to save plots of the same variable but filtered for different values as interactive html.Here is an example:new_window = New Window( "NW", hlb = H List Box() ); for (age_index=1,age_index<=N items(age_list),age_index++, graph = Graph Builder( invisible, Size( 1357, 920 ), Variables( X( :index ), Y( :Height ), ),...
Leily

Discussions |
Jan 3, 2020 1:05 PM

4392 views | 3 replies
Module analysis and correlation networks

This might be more of a "wish list" post, but I am interested in the capacity of carrying out correlation network analysis in JMP with OMICS datasets (in my case, protein concentration data). There is a popular approach called WGCNA (weighted gene co-expression network analysis), described as follows (from https://horvath.genetics.ucla.edu/html/CoexpressionNetwork/Rpackages/WGCNA/):"Correlation ne...
abmayfield

Discussions |
Dec 31, 2019 7:40 AM

6454 views | 3 replies

Previous
Next

Latest Discussions

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

1505 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

1585 views | 0 replies
How can I run a .py python script and python scripts compiled as .exe from JMP

Hello, So I've written a JMP UI, and once I gather data from the user I have a button that dumps the form data to a CSV.Now I need to launch my python script and other .exe (as an administrator), my python scripts pick up the user input from the CSV and perform the next steps.Right now it's a .py but I may need to run it through py2exe and compile it into an exe later so a solution that supports...
xxvvcczz

Discussions |
Oct 30, 2019 6:44 PM

1958 views | 0 replies
Analysis of covariance (ANCOVA) for Split plot Design

Hi, I have a problem where I want to do ANCOVA and It is new for me.We have,Main plot data (2 treatments)Subplot data (10 treatments)Yield datawe want to add lodging (%) score as a covariate. How to do it? (I have seen some video tutorial from Youtube but its not easy to understand for me) Your cooperation will be highly appreciated.
Harun-Or-Rashid

Discussions |
Oct 29, 2019 9:03 PM

1318 views | 0 replies
Send Expects Scriptable Object in access or evaluation of 'Send' Error

I create a new window with variability chart, and put into journal. After that i want to save into pdf. But at the last line to save into PDF, it give me error like below. and nothing is saved into pdf. Need some advice which part i am doing wrong? ErrorSend Expects Scriptable Object in access or evaluation of 'Send' , report_R235 << /*###*/SavePDF( "C:\LimTY\NXP\Product\Pegasus\Characterization\...
OneNorthJMP

Discussions |
Oct 10, 2019 8:43 PM

1352 views | 0 replies