JMP User Community

Latest Discussions

clone a column

Hi All, I want to clone a column in the data table (make a new identical column in all but it’s name). Is there a more sleek (and robust) way of doing this or do I need to extract the values and all properties and assign them to the new column as such:dt3 = Open( "$SAMPLE_DATA/Cars.jmp" );// add a column property dt3:Make << Set Property( "Value Colors", {"Acura" = -13977687, "Au...
ron_horne

Discussions |
Apr 15, 2020 4:20 AM

19318 views | 12 replies
Question with natural log

I'm trying to set a variable to a natural log, but I do not know how to go about it.
juggernauttt

Discussions |
Apr 14, 2020 1:24 PM

4083 views | 2 replies
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

3383 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

6678 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

7107 views | 3 replies

Previous
Next

Latest Discussions

Question with natural log

I'm trying to set a variable to a natural log, but I do not know how to go about it.
juggernauttt

Discussions |
Apr 14, 2020 1:24 PM

4083 views | 2 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

2353 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

2182 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

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

2206 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

1660 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