JMP User Community

Latest Discussions

calculation using data from 2 tables

Hi all,wandering if you can help...I'm trying to create new columns in a table from a calculation of a transposed summary but I keep getting errorswith defining some constants from the table.any idea what I'm doing wrong? src_tran = src_sum << Transpose( Label( :Label ) ); Current Data Table( src_tran ); src_tran << new column("N", Formula(If( Substr( :Label, 0, 1 ) == "M", Substr( Substr(...
Boaz

Discussions |
Jan 24, 2022 1:56 PM

1138 views | 2 replies
Calculation field subgroup count

Hello,This is probably a newbie question, but I can't seem to find the answer. I am looking for a way to program a calculation field that would give me for each individual the total numbers of the subgroup to which he belongs. The subgroup is determined by 3 variables: Year of birth - Gender - Employment.
Example:
Row #1: 1930 - Woman - Nurse [17]
#2: 1930 - Woman - teacher [74]
#3: 1930 - Man - Plumb...
claude_bellavan

Discussions |
Jan 24, 2022 11:04 AM

4642 views | 10 replies
Apply Mathematical formula only on Selected Rows (JSL)

How do I apply a mathmatical formula to selected rows only using JSL? Thanks for your help.
twillkickers

Discussions |
Jan 24, 2022 10:39 AM

8994 views | 5 replies
Window with custom text with background colour in JSL

I would like to create a window with user defined text (in this case "Parameter 1") and pass it to a journal in a H List box (this part I should be able to do).How to create such a bordered box/window/panel in JSL - I need control on the size of the box and preferably also on the background colour (say grey to start with)?
Neo

Discussions |
Jan 24, 2022 10:00 AM

1385 views | 1 replies
SQL query script problem with date format

Hello, I'm a biginner on JSL. I'm mixing a script with a SQL Query. My query conditionned by two date. But when I run it the assignement of my date deosn't work. The fild with the date is _TIMESTAMP and the format of the date is yyyy-mm-dd hh:mm:ss. When I run it with the dates inside the query of course it works. I need this script because I have to do the same thing for numerous tables. Here is ...
Teissduc16

Discussions |
Jan 24, 2022 9:39 AM

2230 views | 3 replies

Previous
Next

Latest Discussions

calculation using data from 2 tables

Hi all,wandering if you can help...I'm trying to create new columns in a table from a calculation of a transposed summary but I keep getting errorswith defining some constants from the table.any idea what I'm doing wrong? src_tran = src_sum << Transpose( Label( :Label ) ); Current Data Table( src_tran ); src_tran << new column("N", Formula(If( Substr( :Label, 0, 1 ) == "M", Substr( Substr(...
Boaz

Discussions |
Jan 24, 2022 1:56 PM

1138 views | 2 replies
How to change the graph frame thickness and color in Graph Builder?

I am trying to prepare publication quality figures using JMP and one of the things that my PI/our research group prefers are thick graph frames/axis ticks. This is fairly easy to change in Matlab, but I have yet to find a quick way to adjust the graph frame thickness (or color) in Graph Builder. Is this possible? If so, what's the best the way to do this? Thank You!
NCSURavi

Discussions |
Jan 24, 2022 8:32 AM

2611 views | 2 replies
R integration crashing

Hello,
I've been running R integration specifically for making graphics with ggplot. Today of a sudden I started getting this error:

The request could not be completed because the R child process terminated unexpectedly with exit status 0xc0000409.
Send data for "dt" failed

I can still send data to R with other add ins that I've created, but something is happening specifically only with ggplot graph...
MikeDereviankin

Discussions |
Jan 24, 2022 5:06 AM

1082 views | 2 replies
analyzing"count" data

We did a study in which we collected data on publications in my field over a five year period. For each publication we completed a 24 element checklist. The spreadsheet has one column with with integer values ranging from 0-24. I would like to compare how publications scored on the checklist by publication year (coded in a different column). What is an appropriate statistic for such a comparison...
dweinber

Discussions |
Jan 22, 2022 7:06 AM

2292 views | 4 replies
M1 Macbook Pro JMP Capabilities

Hi all,
I'm thinking about upgrading from my windows set-up and running a M1 Macbook Pro as my primary set up. I wanted to open up the discussion and see if any other JMP users were using the newest Macbook Pro and if they have run into any hurdles yet? I do a lot of R/Python integration. I do have a decent set up right now, but want to know if anyone else has tested out this connection and knows ...
MikeDereviankin

Discussions |
Jan 21, 2022 1:52 PM

790 views | 0 replies

Previous
Next

Latest Discussions

M1 Macbook Pro JMP Capabilities

Hi all,
I'm thinking about upgrading from my windows set-up and running a M1 Macbook Pro as my primary set up. I wanted to open up the discussion and see if any other JMP users were using the newest Macbook Pro and if they have run into any hurdles yet? I do a lot of R/Python integration. I do have a decent set up right now, but want to know if anyone else has tested out this connection and knows ...
MikeDereviankin

Discussions |
Jan 21, 2022 1:52 PM

790 views | 0 replies
How do I apply time fixed effects with multiple regression

I have financial panel data and would like to hold dummy time variables fixed as I regress the other independent variables to test my model's significance. Not sure how to proceed. Is this function only available in SAS? Thanks
RiDe

Discussions |
Jan 10, 2022 11:18 PM

706 views | 0 replies
separating labelled values from graph points

I have looked in the scripting help section and all over this community and haven't found a solution for my problem so hopefully someone can help. I have a graph containing two trend lines and a bar graph and want to label the values of each point but when I set the labels both values show up on each trend line and I can't figure out how to separate the labels. I tried stacking the labelled column...
Cdougz

Discussions |
Dec 31, 2021 7:38 AM

915 views | 0 replies
Expand Contours

Hi,

I understand that the contouring is done based on triangulation to data points, but is there a method for expanding them further to fit a custom SHP file I've imported into JMP? I've already set the alpha and the lowest value so the contour should cover the, 'most', area. Any other methods? Thanks!
MikeDereviankin

Discussions |
Dec 15, 2021 12:49 PM

712 views | 0 replies
Getting all Zeros for the AR(1) estimate/std error in a Repeated Measures Mixed Model Using JMP Pro

I am fitting a model of a continuous response against 7 fixed effects. When running the Standard Least Squares; my residuals plots/assumptions checks don't look too bad but the Durbin Watson test is suggesting an AR(1) structure in the residuals. This is expected for this particular analysis and is consistent with other data sets looking at the same response/factors. The Time Series platform also ...
lisa2442

Discussions |
Dec 14, 2021 7:32 AM

874 views | 0 replies