JMP User Community

Latest Discussions

JSL split function keep column name in header when splitting a single column

Hi all, I have a section of jsl code which takes my data table and splits a variable amount of columns (code attached below). //Variable Table splitting operation dt_split = new << Split( Split By( :SamplePos, :File ID ), Split( Eval List( EmitCols ) ), //Here is the line where I choose a variable amount of columns within the data table to split Group(:Cycles), Output Table( "Split_Table" ), R...
inqmnd

Discussions |
Apr 14, 2020 7:25 AM

3384 views | 1 replies
How to reference a table variable inside a table variable

After creating the first two variables, I'd like to make my angleRefY and my angleRefX variables be offset from zeroX and zeroY by a static number. I've tried to do this a few different ways as you can see below. The only way that produced a number was this script, but then the variable becomes 6 instead of QQ+1, so they still aren't linked.dt << Set Table Variable("TT", dt:QQ + 1);Does anyone kn...
MarkJohnson

Discussions |
Apr 14, 2020 6:13 AM

6682 views | 6 replies
Adding Duplicate Rows

Quick question,I am working on moving columns from one data table over to another. The rows don't match up, the place where I am moving the columns has 4 times more rows. Is there a way that I can duplicate every row three times to make the copying and pasting easier?Thanks!
katelyn

Discussions |
Apr 14, 2020 12:10 AM

7109 views | 3 replies
How to choose multiple color coding in a heatmap?

Hi, I am trying to plot a heatmap with some data as shown in the image below.x and y are the grouping variables and d, a are the coloring variables.I only see the effect of one coloring variable at a time.Is it possible to have each cell of the above plot (vertically/horizontally)divided into two where one cell refers to colors based on d and other based on a? Is there any other solution that I ca...
AD1

Discussions |
Apr 13, 2020 12:44 PM

2355 views | 2 replies
Batch Processing

I have multiple folders (4), each folder with multiple files (4), each file with multiple sheets (12), each sheet with a matrix of about 80x20. Speaker sound pressure level vs frequency. I am looking to extract the data in JMP, put it back on the same folder for each file, for each sheet, and run a simple x by y correlation matrix, where x=the first 10 files and y=the second 10 files, files BUT PI...
Guillermo

Discussions |
Apr 13, 2020 12:39 PM

2184 views | 2 replies

Previous
Next

Latest Discussions

How to choose multiple color coding in a heatmap?

Hi, I am trying to plot a heatmap with some data as shown in the image below.x and y are the grouping variables and d, a are the coloring variables.I only see the effect of one coloring variable at a time.Is it possible to have each cell of the above plot (vertically/horizontally)divided into two where one cell refers to colors based on d and other based on a? Is there any other solution that I ca...
AD1

Discussions |
Apr 13, 2020 12:44 PM

2355 views | 2 replies
Batch Processing

I have multiple folders (4), each folder with multiple files (4), each file with multiple sheets (12), each sheet with a matrix of about 80x20. Speaker sound pressure level vs frequency. I am looking to extract the data in JMP, put it back on the same folder for each file, for each sheet, and run a simple x by y correlation matrix, where x=the first 10 files and y=the second 10 files, files BUT PI...
Guillermo

Discussions |
Apr 13, 2020 12:39 PM

2184 views | 2 replies
create new column with assigned value by another column value

I have a column with date, and want to create a new column, need assign with {A, B, C, D, E} by judging another column unique date.Judge by "rundate" cell value(refer to below pic), kindly help on how to generate a script:1. assign new column Cell[1] == "A", i++, if "rundate" Cell[i] = "rundate" Cell[i++], keep assign new column Cell[i++]=="A".2. if "rundate" Cell[i] < "rundate" Cell[i++], means ...
qspringleaf

Discussions |
Apr 13, 2020 9:53 AM

2386 views | 2 replies
Control chart of continuous temperature data

Hello, I have conducted a stress experiment in chickens. I've monitored the leg temperature over a period of 7 days. For example, I introduced a loud sound to see what happens with the leg temperature (we expect it to drop after stressor induction). I have extracted the temperature 2 minutes before stressor induction and 2 minutes after stressor induction. So I have a vector of 7001 datapoints, si...
SW1993

Discussions |
Apr 13, 2020 7:15 AM

2960 views | 3 replies
highligting the markers of particular rows in Bivariate plot

Hi Trying to highlighting the markers of particular rows in Bivariate plot.I manuall created the plot and saved the to script window and manually selected 'Theme' column as row legend. But the problem is I don't see those steps above in the script when I looked it! Here is what I meandt = Open( "$sample_data/Hollywood Movies.jmp" ); dt = currentdatatable(); // Don't know I need this here anyway...
joshua

Discussions |
Apr 13, 2020 12:44 AM

2836 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

2211 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

2016 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

1661 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

1600 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

1681 views | 0 replies