JMP User Community

Latest Discussions

Left function behavior

I'm having an odd behavior with Left(). Consider the following:Left( "A", 2, " ") I anticipate the result will be "A " (i.e. padded on the right with a space). And indeed this is what I get.However, When I use the same expression in a column formula like this:Left( :Input, 2, " ")and I have "A" as the value in Input, I am just getting "A" in the result column (i.e. no right space).Am I missing som...
john_madden

Discussions |
Nov 11, 2018 4:16 AM

7734 views | 4 replies
Exporting data from jmp to excel without excluded rows

Hi, Is there any add-in for jmp that helps exporting data to excl without exclueded rows? Thanks,Ne
NeF

Discussions |
Nov 9, 2018 1:52 AM

7380 views | 4 replies
matched pairs- conditional logistic regression using Choice Model platform

HI, I am a beginner in JMP (not familiar with JSL, would prefer an interactive explanation). I have data for a case-control study with 67 matched pairs. Each case is indivicually matched to a control (1:1). I need to use Conditional logistic regression to find out whether a particular outcome (column name: 'primary') is significantly different in cases vs controls, after controlling for several f...
Srishti

Discussions |
Nov 8, 2018 2:14 PM

12315 views | 2 replies
Is it possible to convert timestamp date to date in Database Query JSL?

Hello, I have been searching all over to no avail. I have a new database that I am pulling from and all dates located within are timestamped. I am hoping to get some help on being able to query in this database using just a date and not timestamps using JSL. The column I am using to query is a Numeric Continuous Date column that it's format is m/d/y h:m:s (Width 30 Dec 6) and informat is m/d/y h:m...
Sully

Discussions |
Nov 8, 2018 12:57 PM

6286 views | 3 replies
User Defined Function with Specified Column Name (JSL)

I am trying to create a user defined function where you can specify a column name as one of the inputs. For example, I would like to use the below code to create a function that selects rows where the specified "ColumnName" equals the input "Value":TestFunction = Function( {TableName, ColumnName, Value}, {}, TableName << Select where(:ColumnName == Value); );However, when I try and run this functi...
twillkickers

Discussions |
Nov 8, 2018 11:19 AM

4552 views | 1 replies

Previous
Next

Latest Discussions

Exporting data from jmp to excel without excluded rows

Hi, Is there any add-in for jmp that helps exporting data to excl without exclueded rows? Thanks,Ne
NeF

Discussions |
Nov 9, 2018 1:52 AM

7380 views | 4 replies
Help with graphing ELISA data

Hey guys, I just started using the JMP pro 14 software on a mac and an still trying to figure out how to use the software. I'm trying to get my ELISA data to resemble the attached graph. I cant seem to figure how out to group my data in such a way and am wondering if its even possible.
DBeta

Discussions |
Nov 7, 2018 4:57 PM

3153 views | 1 replies
is there a way to color a contour plot with a category of data?

I'm creating a contour plot with 3 groups of numerical data. I also have categories that these different data are grouped into. Is there any way to create a custom color scheme that follows the categories of data in the groups assigned so that I can see where the categories sit in this contour of the three numerical series?
Maureen

Discussions |
Nov 6, 2018 11:10 PM

4721 views | 2 replies
column with formula in a post query script

hi, With a JMP query builder, and with the post query script, I create a new column with something like this: dt << NewColumn("BMI", Numeric, Continuous, Formula(:weight/:height^2)); but, my problem is: when I update from database the jmp file, I create a new column "BMI 2". and with an another update: a new column BMI 3. I would like to have only one column BMI at each update from database....
Françoise

Discussions |
Nov 5, 2018 7:41 AM

4440 views | 2 replies
How to save each graph from graph builder into an image file with the title from the List array

Hello all, I have trying to find a away of saving my results into a pptx. template and realized that I should first save each result into a file to then compile into a template report.According the following post:https://community.jmp.com/t5/Discussions/the-graph-size-exported-to-pptx-Save-Presentation/m-p/72135#M35554 However, I have not been able to find a away of naming my files according to th...
ivomdb

Discussions |
Nov 5, 2018 3:45 AM

18354 views | 9 replies

Previous
Next

Latest Discussions

I want to use LASSO and Group LASSO in JMP

I'm involved in a project where we are applying lasso to build a logistic regression model from a "black box" set of predictors. I need to get JMP Pro before trying out JMP's implementation. I'm doing all the analysis in R at present. Does JMP Pro also include group lasso? I've found through using JMP Cluster Variables (CLUSVAR) that I can naturally group my predictors prior to group lasso. F...
gene

Discussions |
Nov 2, 2018 7:43 AM

2561 views | 0 replies
Contingency table and mosaic plot are not same orientation

// For a contingency table report, swap the x and y // currently can swap the mosaic plot only Names Default to Here(1); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); myr = Contingency( Y( :Age ), X( :sex ) ); // Have to have a Contingency Analysis report open // Can add test to make sure it is open in the future myr = Current Report(); // taking apart CrossTabBox was easier using XML than JSL...
Vball247

Discussions |
Oct 29, 2018 2:18 PM

3235 views | 0 replies
how to change the type and color of lines in graph

I am trying to show line of fit in graph builder for several sets of data. The data table have many columns, I want to show the column(i) vs column(1).Every column can be grouped by A1 & a, also can be grouped by B1 & b, but except column(1). The follow is the chart about column(2) vs column(1): I use the follow script to change the type of lines:Dispatch( {}, "400", ScaleBox, {Legend Model( 8,...
Yu

Discussions |
Sep 25, 2018 2:34 AM

3644 views | 0 replies
Mean separation letter from test slices

Hello!

How do I get the mean separation letter in for each level of a factor when interaction is significant? For example, if I have A*B interaction and I want to get the mean separation of B at each level of A, how do I get the LSD letters in JMP? I can do test slices and that will use the DF of the full analysis, but this does not shows which mean of B differs. If I do multiple comparison: How ca...
jfranc19

Discussions |
Sep 14, 2018 2:35 PM

2467 views | 0 replies
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

3443 views | 0 replies