Welcome to the JMP User Community!

Latest Discussions

• JSL Script to Initialize Data as Date Sequence

  I'm trying to write some JSL code that will:
  
  1) prompt user for starting and ending dates for range of data to initialized
  
  2) create new table and have this table add the number of rows equal to end date - start date, initialize new column with dates that increment by 1 day per row.
  
  Does anyone have any suggestions on how to accomplish this? I've included my test code so far. Thanks.
  
  Ron
  
  
  Dialog(
  VList...

  terapin

  Discussions |

  Mar 4, 2010 1:27 PM

  6411 views | 8 replies

• Distribution Bin

  First of all, I want to greet all the people in the community.
  This is first time for me to use this kind of Community Tools.
  
  In the Distributions:
  1) where can I see the value of the bin?
  2) which is the formula used from JMP to calculate the bin for the firts visualization?
  
  Thank you.
  Simone

  

  Discussions |

  Mar 2, 2010 6:43 AM

  3677 views | 1 replies

• convert day of week from date string

  Hello,
  
  Newbie question.
  
  I have the following date string 14-Jan-2010 and I would like to get the day of week
  from this string. Should I use the formula editor or write a script.
  
  I tried using the he formula editor "day of week" but I get an error.
  The error might have to do with the format of the date string.
  
  I think I need to parse the string and then determine what day of the week it is i.e. Sun...

  MaryLoveless

  Discussions |

  Mar 1, 2010 2:46 PM

  10515 views | 1 replies

• Accessing Oracle tables via ODBC

  Hi All,
  
  I'm new to JMP and need to go into an Oracle database and turn about 50 tables into JMP tables using JSL.
  
  I've found and can use the OPEN DATABASE command, but have several questions:
  
  1) Once you've opened the database, how do you disconnect from it at the end?
  
  2) The OPEN DATABASE Command accepts an SQL statement and a JMP table name. How do you get data from 50 tables and put them into 50 J...

  

  Discussions |

  Feb 28, 2010 5:50 AM

  5332 views | 5 replies

• Automatically include the value of a variable in a title?

  In JSL, how can I automatically include the value of a column in a graph title? For example, if my data query only returns data for species_name ="Blue Crab", how can I automatically incorporate species_name into my graph title? In SAS, I would use a macro variable. How can JMP do this?

  mfisher

  Discussions |

  Feb 26, 2010 10:19 AM

  3810 views | 2 replies