JMP User Community

Latest Discussions

Is there any way that I can remove the label numbers in the graph?

Hello all, I am using label in my script to help me filter data. The script is showing bellow: dt_daily << New Column( "Outliers Exclusion (Energy % from Controls)", Numeric, Continuous, Formula( If( !labeled( Row State() ) , "Clean Bad Data", "Show Bad Data" ) ), eval formula ); Close( dt_subdaily ); Close( dt_dailysplit ); Wait( 0 ); New Window( "Energy % from Controls", dt_daily << Grap...
Anonymous

Discussions |
Jun 26, 2018 6:12 AM

5945 views | 2 replies
RE: Extracting File Names

Hi, I was just wondering if there was any way to extract the file name of an excel file or data table using JSL.Any help would be appreciated.
Jaz

Discussions |
Jun 26, 2018 5:59 AM

9557 views | 4 replies
RE: JSL Time Data Type

Hi, I was just wondering if there was a way for JSL to tell how much time it has been since a particular start point. For example, is there a function that could output the time difference between the start time 00:00:00 and 00:00:01? Or a function that could add one second onto 00:00:00 to make it 00:00:01. Just curious as it would save me some time. Also, is there a function to convert HH:MM:SS ...
Jaz

Discussions |
Jun 26, 2018 3:24 AM

8470 views | 5 replies
Passing Date value to Oracle SQL

I have a frustrating problem. I want to write a script to use a JMP date code, to query an Oracle database.For instance:StDt = today() - in weeks(4);.If I manually do it using Query Builder, I get something like the code below. What syntax do I need to replace the integer date code with to do this? The documentation is pretty sparse on this topic. Query1 = New SQL Query(
Version( 130 ),
Connection...
mwechtal

Discussions |
Jun 25, 2018 2:27 PM

5754 views | 3 replies
Struggling with extracting the second largest values for each column

I have been trying to extract second largest numbers from JMP tables. So far, I have only been manually doing it usingSort descending( Eval List( {:X1, :X2, :X3}));How can I just pass the entire table rather than individual column names?
amy

Discussions |
Jun 25, 2018 1:06 PM

8689 views | 5 replies

Previous
Next

Latest Discussions

Is there any way that I can remove the label numbers in the graph?

Hello all, I am using label in my script to help me filter data. The script is showing bellow: dt_daily << New Column( "Outliers Exclusion (Energy % from Controls)", Numeric, Continuous, Formula( If( !labeled( Row State() ) , "Clean Bad Data", "Show Bad Data" ) ), eval formula ); Close( dt_subdaily ); Close( dt_dailysplit ); Wait( 0 ); New Window( "Energy % from Controls", dt_daily << Grap...
Anonymous

Discussions |
Jun 26, 2018 6:12 AM

5945 views | 2 replies
Passing Date value to Oracle SQL

I have a frustrating problem. I want to write a script to use a JMP date code, to query an Oracle database.For instance:StDt = today() - in weeks(4);.If I manually do it using Query Builder, I get something like the code below. What syntax do I need to replace the integer date code with to do this? The documentation is pretty sparse on this topic. Query1 = New SQL Query(
Version( 130 ),
Connection...
mwechtal

Discussions |
Jun 25, 2018 2:27 PM

5754 views | 3 replies
basic JMP vs JMP Clinical

Hello,I got a question whether the basic JMP version has enough capability to analyse Adverse Events or only JMP Clinical would be the option?Thank you,Konrad
konradkk

Discussions |
Jun 22, 2018 5:38 AM

5452 views | 6 replies
Journals Vs. GUI

Hi, I was just wondering about the difference between journals & GUI's. I've attempted to create a journal but it asks me to save it everytime I run it, this is a very basic question but why does it ask me to save the window when I haven't actually created or changed anything? Overall, in what cases would you create a journal and in what cases a GUI? I am trying to create a user interface from m...
Jaz

Discussions |
Jun 22, 2018 5:27 AM

4019 views | 1 replies
inverse probability of treatment weighting

Hello, I'm doing research on prostate cancer survival outcomes using Cox hazards regression (Fit proportional hazards model in JMP) and was wondering if JMP has the capability to do weighting such as Inverse probability of treatment (IPTW) weighting? Thank you
hhuang1

Discussions |
Jun 21, 2018 10:50 AM

3058 views | 1 replies

Previous
Next

Latest Discussions

repeated-measures ANCOVA: How to perform the analysis when the parallel slope assumpt. doesn't meet?

Hi all,I need to perform the ANCOVA for a repeated-measures design. I tried to adapt the Julian's ANCOVA procedure showed on the https://www.youtube.com/watch?v=mApbp1RDy-U to my study case (repeated-measures design). Initially, I did the following actions: 1. In the Fit Y by X dialogue: I selected VAR_Y as "Y, Response" and VAR_X as "X, Factor";2. For "Group by" I selected the variable Timepoint;...
Reinaldo

Discussions |
Jun 18, 2018 6:31 AM

3434 views | 0 replies
Time Series - Prewhiten

Hello Everyone, My question pertains to understanding what the terminology in JMP's prewhiten platform means.Also, understanding how that helps me determine an appropriate Transfer Function that I can use to test whether x causes y. JMP's prewhiten output shows three different ACF's labeled "Prewhiten Corr", "Noise AutoCorr", & "Noise Partial AutoCorr".
What is the Prewhiten Corr, Noise AutoCorr, &...
nopon649

Discussions |
Jun 7, 2018 11:10 PM

2470 views | 0 replies
Fit Spline By Group: Save Spline Coefficients to Column?

Hi all--having an issue. I am using Fit Y by X to fit 5,000 separate regressions. I hold control, select red drop-down arrow, and Fit->Flexible, Fit->Spline and select, say, 0.1. This fits a spline to all 5,000 graphs with lambda of 0.1. I have 28 X values in each of 5,000 graphs, and I understand there are 4 different spline coefficients (A, B, C, D). I understand if I just had 1 regression...
M0gAl0g

Discussions |
Jun 5, 2018 3:19 PM

3027 views | 0 replies
Why does Profiler not stop

All,
I have a script I am trying to profile and improve on. When I run the script without the profiler, it runs and ends within 4 minutes. When I try to profile the script, even after a good 5-6 minutes, it does not stop. Wondering why this is happening and if there is a way to use profiler and not run into this. I am using JMP 13.
uday_guntupalli

Discussions |
Apr 27, 2018 7:12 AM

1850 views | 0 replies
P value, L-R Chi Square, Prob Chi Square in Choice results

Hello everybodyI am going to undrestand the P value, L-R Chi Square, Prob Chi Square in Choice results. But different interpretations of these values can be found in the web. It seems that the true interpretation is related to null hypothesis and confidence intervel.The results of the study are as the attached pictures.Could any body inform me what exactly these statistics are saying and base on w...
aryasohrabi

Discussions |
Mar 17, 2018 2:22 AM

3991 views | 0 replies