Welcome to the JMP User Community!

Latest Discussions

• Easy way to generate a scatterplot matrix using the GraphBuilder?

  I was wondering if there is an easy way to generate a scatterplot matrix in the graph builder. I would like to create something like this:My problem is, that I need to pull over each variable on the x-axis one at a time. If I select multiple variables the GraphBuilder will generate the - for my purposes no so useful - overlayplot:I'm using this kind of graph often when it comes to the analysis of ...

  shoffmeister

  Discussions |

  Jul 7, 2016 9:39 PM

  18239 views | 8 replies

• Averaging multiple observations

  Hello JMP Community,I am new to the JMP software, and had a question regarding multiple observations in my data. I am working with data dealing with patients. Obviously, I do not want to have one person show up multiple times in my data when I am trying to make certain types of comparisons. I was wondering if there was a way to average the multiples that I received for each patient, for example, i...

  acunar

  Discussions |

  Jul 7, 2016 6:58 PM

  14463 views | 5 replies

• How to make an SQL table Invisible?

  I have another "invisible" question. I made an SQL table (from Query Builder) and want to modify my JSL to make that table invisible. I've tried adding "Invisible" to many different places, but none have worked. Is there a different syntax for making a Query Builder table invisible? Here is my code - thanks in advance for the help!dt1=New SQL Query( Version( 130 ), Connection( "JMP" ), ["JMP_Table...

  isabellet14

  Discussions |

  Jul 7, 2016 6:54 AM

  9537 views | 2 replies

• Importing SQL using a temp table

  I am having a difficult time using Stored Procedures and Temp tables in JMP 11.2.1.  I simply get no returndb = Create database Connection("DRIVER=SQL Server;  SERVER=localserver\SQLEXPRESS;  DATABASE=Test");Execute SQL(db,   "  CREATE TABLE #Test ( ID int)  Insert INTO #Test (ID)  VALUES (1), (2), (3), (4), (5)  SELECT *  FROM #Test  DROP TABLE #Test  ",  ":-(");close database connection(db);This...

  vince_faller

  Discussions |

  Jul 6, 2016 2:52 PM

  16693 views | 14 replies

• customize the formatting of the target excel file when save a data table as a excel file.

  I would like to ask JMP community to help me out on a custom way to export JMP table to excel.Part of my script need to export a JMP table to excel file.Ideally, I would like to customize the formatting of the target excel file when exporting. (with desired column width, row height, color, etc.)But so far, I find that JMP will only carry the cell color to the target excel file. And I’ve been looki...

  zlsas

  Discussions |

  Jul 6, 2016 11:26 AM

  9551 views | 3 replies