Welcome to the JMP User Community!

Latest Discussions

• extract year from a mdy variable

  I have variable collection.date, in m/d/y format, and I want to create another variable, yr, by extracting year from collection.date. I have tried using the year function in a formula but haven't had any success. Any suggestions?
  Thanks,
  mgm

  

  Discussions |

  Apr 1, 2009 6:19 AM

  3577 views | 1 replies

• If column exists?

  Hi-
  
  Would like to write a simple statement in script like,
  
  If column_name exists then
  do stuff
  End If
  
  Is it possible?
  
  Dave

  

  Discussions |

  Mar 31, 2009 1:32 PM

  4245 views | 1 replies

• How to show full column name when it is too long?

  Hi,
  
  I have a table, each of its columns usually is assgned with a prettly long name for easy interpretation.
  
  So after I generate or load it into JMP, each time I have manually adjust each column to make sure
  its full name can be shown properly.
  
  But this is too annoying when columns are too many.
  
  So if I can control its display by JSL, any idea I can make this automatic column width adjustment?
  
  Th...

  

  Discussions |

  Mar 17, 2009 2:57 AM

  3630 views | 1 replies

• JMP Calculator

  In JMP we can do calculation using the JMP calculator.
  The parameters in the formula are the columns table, attached is a simple formula subtracting y column from x column with LAG,
  What I want to know is if there is a way to use different lag for different rows.
  ((Lag( x, 2 ) - :y) / Lag( x, 2 )) * 100
  
  Thank you
  Yaakov

  

  Discussions |

  Mar 12, 2009 12:30 AM

  4486 views | 2 replies

• How to extract a numberical value from "Distribution" display box?

  Hi, all
  
  I met a problem in extracing a numeric value from a display box object.
  It is very tricky and could not figure it out.
  I have following table "Data.jmp", and try to fit its distribution using following JSL code:
  
  dt = CurrentDataTable();
  div = Distribution( Stack( 1 ),
  Continuous Distribution(Column( :Value ), Horizontal Layout( 1 ), Vertical( 0 ),
  Fit Distribution( Normal(Goodness of ...

  

  Discussions |

  Mar 11, 2009 9:03 AM

  3749 views | 1 replies