JMP User Community

Latest Discussions

How to get Legend Box information, like color and marker type

Dear JMP Community, (W10 Enterprise 64-bit, JMP Pro 15.0) I have a user that is using graph builder to generate a rather complex graph containing multiple bits of information. The market data is split by region, customer, etc. As a result, the scatter plot is color coded as well as having multiple markers. As an example, below is something kind of like what the graph might look like (using Big...
SDF1

Discussions |
Mar 19, 2020 9:47 AM

5614 views | 4 replies
Generating ordinal data

Hello!Does anyone know how I can generate ordinal data in JMP to simulate a sample?I mean I need to simulate a sample including ordinal measurements by generating synthetic ordinal data. Thank you in advance for your help.
Fatemeh_2020

Discussions |
Mar 19, 2020 6:47 AM

4616 views | 5 replies
Copy output from JMP 15.1 and pasting into Word 365

I used to be able to copy output for example tabulate results from JMP and easily paste in Word 16 I am now on Windows 10, JMP 15.1, office 365. Results in JMP look like: When pasted into Word I get 6 separate tables where each column becomes a separate table. I'm not pasting all of them in the example below. First 3 are:I have 4 options in Word.1.Keep source formatting which I have shown.2.Merg...
jkeighley

Discussions |
Mar 18, 2020 4:04 PM

3821 views | 3 replies
Join two tables by matching common column name

Hi,I have two tables as below.Table1 :NameSectionSubjectAdamAMathBobAscienceChrisBenglish Table2: NameSectionScoreAdamA80BobA90ChrisB84 I want to join both table in jsl and get the following output table but I don't want to give matching column names explicitly. Matching columns would be the columns with same column name in both table. Matching columns can vary. It can be 2 (as in shown example) ...
Rajat

Discussions |
Mar 18, 2020 9:09 AM

2979 views | 1 replies
Adding and deleting borders of graphs in graph builder

Hello, I want to tweak a graph to my wishes but I'm not as succesful as I want... The graph consists of 2 columns. I would like to get rid of the little grey line on top, seperating the titles of the columnsAnd I would like to have a black line closing the graph on the top Is there something in the preferences or may elsewhere that I just didn't find..? Thanks a lot! @martindemel
JL_LZH

Discussions |
Mar 18, 2020 2:40 AM

8871 views | 6 replies

Previous
Next

Latest Discussions

Generating ordinal data

Hello!Does anyone know how I can generate ordinal data in JMP to simulate a sample?I mean I need to simulate a sample including ordinal measurements by generating synthetic ordinal data. Thank you in advance for your help.
Fatemeh_2020

Discussions |
Mar 19, 2020 6:47 AM

4616 views | 5 replies
Import hidden Excel worksheet

How can I import data from a hidden Excel worksheet? If I use Open() with the option Worksheets("TechnicalData"), then it fails as long as the worksheet "TechnicalData" is hidden in my Excel file. As soon as I unhide the worksheet in Excel, the import works again. (Note: Why do I want to import a hidden worksheet? Because I need to import data from a "user friendly" excel sheet, which is not actua...
JWi

Discussions |
Mar 17, 2020 12:15 PM

2243 views | 1 replies
JMP script - Color or Mark by Column

I have a JMP table with a column called Order that contains letter values like A, B, C, D, E, etc., and another column called Number that contains number values like 1, 2, 3, 4, etc. Manually operating on this table, I could do the following:-- Right click at the upper left of the table and select Color or Mark by Column-- Select Order from the list of columns, then leave Colors = JMP Default and...
fbm73

Discussions |
Mar 15, 2020 4:16 PM

2691 views | 1 replies
how to find and replace all instances of specified characters within a given column

This is a very simple question. I have a given column in a JMP table, and I want a JMP scripting command that will find and replace all instances of specified characters within that column. For example, I have a column called GROUP, and certain rows in GROUP contain values like "A05 or "B17 and I would like to replace all " characters in GROUP so that the entries become A05 and B17 instead of "A...
fbm73

Discussions |
Mar 15, 2020 5:37 AM

8738 views | 4 replies
How to copy Directories from one place to another?

Hi,I have run into a problem all of a sudden. I wish to copy files and directories and I am not able to do that anymore.I use Copy File() and Copy Directory().Somehow Copy Directory() doesn't recognize my paths anymore or occasionally fails.So, I would like to know:1. How to copy a directory (say D:/copyme) inside another directory (D:/destination) ? So that I have D:/destination/copyme as the fin...
AD1

Discussions |
Mar 13, 2020 4:33 AM

3084 views | 4 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

2222 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

2034 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

1673 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

1608 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

1689 views | 0 replies