JMP User Community

Latest Discussions

How do I compute a 24 hour rolling average

I need to compute a 24 hour rolling average for each individual subject. I have the following columns: Subject IDTime stampMilk yeild Can anyone help direct me in the right direction?
JocelynJohnson

Discussions |
Apr 3, 2020 2:55 PM

2638 views | 2 replies
Append plots from for loop

Hi, I try to append all plots from for loop to one window but it show only the first one. Below is my script.Names Default To Here( 1 ); dt = Current Data Table(); list = dt << get column names( character ); New Window( "column selector", <<modal, Border Box( Left( 3 ), top( 2 ), V List Box( Text Box( "Group By" ), H List Box( H List Box( Panel Box( "Select Columns", lb...
yanee

Discussions |
Apr 3, 2020 11:34 AM

2500 views | 2 replies
Calculate a moving median

I am trying to calculate a moving median. I have used the moving average function before as well as the Summation function to calculate moving averages but can't figure out how to calculate a moving median based on a set number of lag rows. For example, for every row in my column, i'd like to query the previous 650 rows and calculate the median. I'm working in the GUI right now so any thoughts on ...
RVhydrA

Discussions |
Apr 3, 2020 5:32 AM

7982 views | 4 replies
Indiv Confidence Interval for more than 1 future data point

In the Fit Y by X platform I oftentimes fit a simple linear regression model and choose to visualize the Indiv Confidence Interval around the fitted line. If I'm not mistaken, in essence this interval represents a Prediction Interval which defines where future individual datapoints will be with a given amount of certainty. I assume the interval is calculated by default for just 1 future individual...
guyvanhove

Discussions |
Apr 3, 2020 5:25 AM

2989 views | 2 replies
Output picture size in pixels

Hi!I have a large series of plots that I need to output as png, emf and svg, and they have to be exactly 500x300 pixels. This has proven incredibly difficult to achieve. I know that I can specify the size of the graph builder using Size(), but that results in a plot that is significantly larger due to added axis titles, plot title, legends, margins and such.To explain what I'm doing: I add an OnOp...
Ingerid

Discussions |
Apr 3, 2020 1:36 AM

3017 views | 2 replies

Previous
Next

Latest Discussions

Graph Builder: How do I only display categories with values for each group x

here's what i've got:clearly i don't want to display all treatments for each experiment. D and E were not in experiment 1 and A-C were not in experiment 2. how do i display only treatments with values?-->treatmentexperimentvalueA10.97A10.39A10.49A10.44A10.38B10.73B10.72B11.02B10.07B10.09C10.23C10.2C10.1C10.22C10.07D20.29D20.18D20.13D20.57D20.86E20.68E20.34E20.46E20.71E20.5 help?
jac865

Discussions |
Apr 2, 2020 7:12 PM

1992 views | 1 replies
Is there a way to run a JSL script with an input?

I'm wondering if I can run a jsl remotely and give it a directory right away... I have a jsl script that uses a directory of a file and executes some commands. I would like to send it the directory of the file in a simple way where gui's wouldn't be involved (hopefully).this is how i execute a jsl script from my PC at the moment:os.system('cd "C:/Program Files/SAS/JMP/14/" && jmp.exe "directory_t...
mochar

Discussions |
Apr 2, 2020 5:04 PM

4667 views | 6 replies
Graph Builder legend issues

When I make a bar graph I have changed both bar colors to gray but made one pattern hash marked. However the pattern change is not reflected on the legend. How can I fix this? Thank you.
TreeStatsNoob

Discussions |
Apr 2, 2020 9:32 AM

5315 views | 10 replies
How to add a data table to web report?

I used the following example of create a project: project = New Project(); project << Run Script( dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); dt << Run Script( "Bivariate" ); dt << Run Script( "Distribution" ); ); Now when I use publish, I get the web report with Distribution and Bivariate plot. How do I add data table as well? Thanks for your help.
AT

Discussions |
Apr 2, 2020 4:38 AM

9484 views | 13 replies
How can I write a script to automatically group columns in new table?

Hello, I am currently writing a script to essentially join three "reference" tables together using the Join, Transpose, and Update functions. My script allows the final output table to be updated each time I add rows to the first "reference" table. I was wondering if it would be possible to edit my script to automatically group columns (i.e. the "Group Columns" function) in the final output table ...
bhdarst

Discussions |
Mar 31, 2020 10:53 AM

2382 views | 3 replies

Previous
Next

Latest Discussions

How do I calculate z-scores at different aggregation levels?

Hello, How do I use JSL to calculate Z-scores at different levels of aggregation? I am working with cancer mortality data (1999 - 2015) at the county-level. I need to calculate Z-scores to compare each county to the others within a state and all counties within the country. I cannot simply use the standardize function because it automatically takes an average of rates--which is invalid unless the...
Jmsouch

Discussions |
Feb 26, 2020 7:04 AM

2055 views | 0 replies
Calling Windows API ImageViewer.dll to display JPG files.

I am working with a very large database of image files and want to be able to display the file for the user for visual inspection from a script. I have been able to get the following code to load the DLL but get an error requesting a signature argument. Does anyone know how to get a signature string from the system to pass to the DLL. ERROR MESSAGE FORM LOG: Second argument to CallDLL must be a ...
DMeakin1

Discussions |
Jan 17, 2020 10:19 AM

1899 views | 0 replies
Running script from command line on MAC

Not a mac person. Does anyone know how to run a jsl script from command line on a mac? I specifically mean WITHOUT "//!" at the top of it. I have this but it only opens the file unless I have the "//!" open -g -W -a /Applications/JMP\ Pro\ 15.app/ $(pwd)/myscript.jsl
vince_faller

Discussions |
Jan 10, 2020 2:26 PM

1567 views | 0 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

1516 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

1598 views | 0 replies