Welcome to the JMP User Community!

Latest Discussions

• How to find out where JMP is installed in a windows machine.

  Hi JMP Gurus,I'm currently using a Perl script to launch our JSL script. The Perl script looks for the default installation location of JMP in the program files folder. Since there are potentially 4 different versions of JMP running around our workplace, I ended up with the following implementation:1. Attempt to launch the standard version executable of JMP 12 in: C:\Program Files\SAS\JMP\12\jmp.e...

  javier_guzman0

  Discussions |

  Mar 29, 2016 1:59 PM

  10359 views | 1 replies

• Can you change y-axis scale independently from other y-axis groups

  Is there a way to change the y-axis scale for the different y-axis groups independent from one another? As you can see in the graph, the middle group densities are much greater than the other four groups. As a result, it is very difficult to see year to year variations in any of the other groups. I would like to increase the scale for the remaining groups, but keep the middle group at it's current...

  joshuas

  Discussions |

  Mar 29, 2016 7:00 AM

  20592 views | 3 replies

• Stack columns based on regex selection

  I am constantly stacking hundreds of columns which have common prefixes and end with a different number or suffix. What I would like to do is write a script to:Find columns based on a regex pattern, e.g. "BLUE_CARS_*_\d{1,2}", "HOMES_(SINGLE|DOUBLE)_WIDE", etc.Select those columnsStack the columns (and place in a new datasheet)For the life of me, I can't find (or Google search properly for) how to...

  tsandidge

  Discussions |

  Mar 28, 2016 11:40 AM

  14925 views | 8 replies

• Delaying (lag) a row value by column date

  Dear All,I would like to make a simple calculation but I can not.Attached jmp table is a subset of Hotel Occupancy Data Base.Simple logic for Record ID 27421 is;in 14 Apr 2016 250 Rooms arrive and check in,in 14-15-16 Apr 2016 those 250 Rooms stay at the hotel for 3 days long,in 17.04.2015 the 250 Rooms which arrived in 14 Apr 2016 Check Out (Leave the hotel).I need to calculate the RoomLeave Colu...

  saitcopuroglu

  Discussions |

  Mar 25, 2016 9:55 AM

  14875 views | 7 replies

• select matching cells

  by the end of the thing, my expected output should be 3 subset tables.So I want to do this: 1) Go to a specific column, 2) Go to the first row of the column, and select matching cells, and group them to a subset tabledt << Select Matching Cells;3) Then I want to skip the rest of the cell that I have matched, and move on to the next unique cell, and select the matching cells, and group them to a ne...

  zhouye0

  Discussions |

  Mar 25, 2016 3:36 AM

  10467 views | 1 replies