JMP User Community

Latest Discussions

Select All Columns and Delete Formula Property?

Comparable to Copy All Paste Special Values in Excel, how can I select all columns in Data Table and delete column formulas while preserving the values of each column in JSL Script?This previous discussion was a beneficial first step.JSL - How to remove formula from column?
aandw

Discussions |
May 20, 2020 6:06 AM

21164 views | 10 replies
Save data table in existing Excel spreadsheet as a new tab

Hi, I have a data table and save it with the "save" command dt1<< Save( Path||".xlsx" ); Now I would like to save another data table dt2 into the same Excelsheet but in a different worksheet tab Is there a way to realize this? Thanks
TWE

Discussions |
May 20, 2020 5:41 AM

2256 views | 2 replies
set data type for new column

Hi, How can I conditionally and programmatically set a data type for a new column? I have a workaround that covers numeric / character, and it could be extended for other types, but I'm trying to get the method below (marked 'not working') to work. The log shows it is not recognizing the type variable. I've tried a few things like parse() but have been so far unsuccessful.Names Default To Here( 1 ...
xeqapena

Discussions |
May 19, 2020 10:02 PM

1665 views | 2 replies
Select only tables which contain a specific string in the table to use as variable

Hello,I'm trying to concatenate a bunch of tables that are generated iteratively by a process.The name of those tables all start with the same prefix.I can easily concatenate all the open tables but I'm unable to find the correct syntax to only concatenate those tables with a specific prefix and leave the other ones alone. Any suggestions? Best Sebastien //The first script to concatenate only tab...
Sburel

Discussions |
May 19, 2020 2:20 PM

3598 views | 6 replies
Regression with Categorical (Character) Variables

Hi all, I recently finished a test that measured the pressure inside the combustion chamber just after firing/igniting a potato gun. I ran this test for three very different combustion chamber geometries. I gave each combustion chamber geometry a name: Alpha, Bravo, and Charlie. I elected to not use a nomial or ordinal characterization for this factor I understand that in all types of modeling, i...
mbdahl

Discussions |
May 19, 2020 7:24 AM

3521 views | 3 replies

Previous
Next

Latest Discussions

set data type for new column

Hi, How can I conditionally and programmatically set a data type for a new column? I have a workaround that covers numeric / character, and it could be extended for other types, but I'm trying to get the method below (marked 'not working') to work. The log shows it is not recognizing the type variable. I've tried a few things like parse() but have been so far unsuccessful.Names Default To Here( 1 ...
xeqapena

Discussions |
May 19, 2020 10:02 PM

1665 views | 2 replies
Regression with Categorical (Character) Variables

Hi all, I recently finished a test that measured the pressure inside the combustion chamber just after firing/igniting a potato gun. I ran this test for three very different combustion chamber geometries. I gave each combustion chamber geometry a name: Alpha, Bravo, and Charlie. I elected to not use a nomial or ordinal characterization for this factor I understand that in all types of modeling, i...
mbdahl

Discussions |
May 19, 2020 7:24 AM

3521 views | 3 replies
Creating a prediction interval with monte carlo simulation

Hi, I was wondering if anyone could help me. I have a set of data in two columns. Column one contains a Run ID while Column 2 contains data generated by the run. My end goal is to plot the 95% prediction interval of the confidence intervals produced by N, N-1, N-2, N-3... until you only have two datapoints per Run, where N = initial number of replicates. Therefore step by step, If for example...
HCK1977

Discussions |
May 19, 2020 4:54 AM

2578 views | 2 replies
Local data filter in a Dashboard with selection filter doesn't work

I am trying to build a dashboard with both a Selection Filter and Local Data Filter but it seems the Local Data Filter doesn't work. Any suggestion on how to fix the issue?
shasheminassab

Discussions |
May 18, 2020 11:20 PM

2558 views | 4 replies
.jsl Script call from Python

I prepared a data in python and call jsl script from python and use the output in python again. How can I do that.
Rajat

Discussions |
May 18, 2020 5:19 PM

13274 views | 8 replies

Previous
Next

Latest Discussions

How do I have two different chart types in a single graph using two axis?

While doing some research to answer this question, I found this article on the JMP community that helped me get started. How do I do a combination bar and line plot using Overlay Plot? Using the big class sample data example of height and weight I was able to create a bar chart for weight and a line plot for height on the same chart using the Overlay Plot. To do this, first clear the row s...
Bass_Masri

Discussions |
Apr 28, 2020 4:28 PM

4460 views | 0 replies
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

2072 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

1921 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

1582 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

1530 views | 0 replies