JMP User Community

Latest Discussions

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

6347 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

4588 views | 1 replies
How to group points in a plot and assign categories in data table (3 or more categories)

How can one categorize a visual data set into user defined categories in the original data table? To explain this further. Say I have a scatter plot, and I want to select certain group of points, and call it Category 1, then somewhere else, select another group, call it category 2, and so on. The goal is to make an interval plots of these 'categories' and see how the means etc vary. Currently,...
Kapoor

Discussions |
Nov 8, 2018 10:39 AM

17166 views | 9 replies
Saving journals as HTML

I would like to create an HTML report from a journal which contains various graphical outputs from JMP platforms.

I have created the journal using:

jrn1 = {cp7, cp4, cp6, cp8, cp9, cp2, cp3 } << Journal Window;

which works fine (cp* is various graphs, tables etc). If I then save this journal as HTML from the file menu, it saves the entire journal with all the graphs displayed correctly in the HTML pa...
matthewh

Discussions |
Nov 8, 2018 5:10 AM

15462 views | 6 replies
IF statements basic question

Hi, I am working with data that looks like this. I want to create an IF statement in a new column, saying that if the DOW (Day of week) is Mon, it should input the value in Column "T-28", if Tue, then input the value in "T-12" etc etc. How do i do this? IF(DOW=="Mon",???)
anjana

Discussions |
Nov 8, 2018 2:14 AM

14814 views | 3 replies

Previous
Next

Latest Discussions

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

3224 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

4780 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

4492 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

18581 views | 9 replies
JMP Alert: Column "Column Name" requires numeric values{4} in access or evaluation of 'Bad Argument'

I am trying to do a an if statement and am getting the error JMP Alert: Column "Column Name" requires numeric values{4} in access or evaluation of 'Bad Argument' where "Column Name" is the name of the column with the formula. Careful, my input column name looks like a formula but it's a column name. The input column is Numeric, continuous. What am I doing wrong? Here's the formulaIf( Num( Abs( :N...
BSwid

Discussions |
Nov 2, 2018 12:15 PM

10664 views | 6 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

2596 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

3253 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

3680 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

2511 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

3509 views | 0 replies