JMP User Community

Latest Discussions

Optimize "for each row"

Hello, I have this script on the Big Class table. On large tables, it takes too much time. Is there some other quicker way? AgesList = {13,14}; for each row(dt, if(Contains(AgesList ,dt:Name("Age"))>0,dt:Name("height")=-1)); Thanks.
tom_abramov

Discussions |
Jan 7, 2020 5:58 AM

3650 views | 2 replies
Row selection by value labels

I would like to script a row selection by the value labels in a column. As an example, the Big Class data set has a value label where F=Female and M=Male. As far I can tell, I cannot write JSL to do a column selection by "Female". Does anyone know how to do this in JSL? My bigger issue is that I have several values that have the same label, but instead of trying to select all of those values i...
bfoulkes

Discussions |
Jan 7, 2020 5:12 AM

4381 views | 4 replies
Latent Class Analysis: there was a problem fitting the specified model.

Hi all,I want to perform the Latent Class Analysis. When I do this, I can get the results, but there is a message; 'there is a problem fitting the specified model. It is likely that the specified model is not identifiable. Try fitting a model with 0 or fewer clusters'. In this case, Can I consider the presented results valid?If not, what should I do? I enter the number 0 in 'Nemuber of Clusters', ...
Jun1

Discussions |
Jan 6, 2020 11:44 PM

6343 views | 8 replies
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

10178 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

Previous
Next

Latest Discussions

Latent Class Analysis: there was a problem fitting the specified model.

Hi all,I want to perform the Latent Class Analysis. When I do this, I can get the results, but there is a message; 'there is a problem fitting the specified model. It is likely that the specified model is not identifiable. Try fitting a model with 0 or fewer clusters'. In this case, Can I consider the presented results valid?If not, what should I do? I enter the number 0 in 'Nemuber of Clusters', ...
Jun1

Discussions |
Jan 6, 2020 11:44 PM

6343 views | 8 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
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

5256 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

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