Welcome to the JMP User Community!

Latest Discussions

• 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

  14465 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

  9553 views | 3 replies

• Date does not replicated into JMP from Excel

  Hi All,Need help !Not very familiar with JMP & still learningAfter copy the data from excel & pasted into JMP, the date cannot get it correctly.Anyone can help to guide me ? Thank you

  tohalan

  Discussions |

  Jul 6, 2016 10:21 AM

  6840 views | 2 replies