Welcome to the JMP User Community!

Latest Discussions

• Calculating duration between two dates from different years

  I am using JSL scripting to run one of my reports that can calucate the duration between two dates. My report has a Start Date in column 'A' and End Date in column 'E' , I want to calcuate the following:1. Duration between those two days excluding weekends2, Duration between those two days , start date is 10/31/2012 and end date is 02/20/2013, and when I used the forumla "Formula(Day(:E - :A) )" ,...

  fr2007

  Discussions |

  Apr 5, 2013 1:30 PM

  21603 views | 13 replies

• Open Multiple Data Files Recursively

  I would like to find some code that will open files in a Windows directory recursively.Let say my path is:  c:\charlie\dataI want JMP to find all the *.txt files in this and lower directories and open them all.Ultimately I will merge them but for now I just want to open them all.I have tried (with no luck):path = "C:\charlie\data\data1";file_list = Files in Directory("C:\charlie\data\data1");for (...

  chfields

  Discussions |

  Apr 5, 2013 9:24 AM

  13612 views | 5 replies

• How to calculate regression slopes by subject in table with many subjects each measured at different ages?

  Renal function is measured as Glomerular Filtration rate (GFR) and loss of function in renal disease is estimated as the (negative) slope of GFR by advancing age. In studies of kidney disease, it is often the objective to test for baseline predictors of the slope of GFR by age or time. The attached table shows typical data for 10 subjects with each having GFR measured at two or more ages. Can anyo...

  tomparker

  Discussions |

  Apr 3, 2013 11:03 AM

  9594 views | 2 replies

• Graph Builder - bar chart how to show summary table?

  Hi, using Graph Builder I'm making a bar chart with a legend.  Each Xvalue bar shows a breakdown by the legend categories (so they add up to a sum for the total bar of course).Question: is there any way to make a summary data table below it displaying the X value by legend breakdown?  I'm thinking by using Table Box and its elements.  I've tried various things even with Summarize, but it's not as ...

  djhanson

  Discussions |

  Mar 27, 2013 3:39 PM

  3470 views | 1 replies

• How to control dimension when graphs wrap?

  Hi, I have a data table with discrete and numeric variables. The discrete variable is basically a serial identifier. The numeric variables are time series style: On of the variables is the time from start of data sampling, the other variables are properties the vary with time. In a typical plot prepared by graph builder, I create first a graph showing a continous variable versus time. Then I drag ...

  poulravn

  Discussions |

  Mar 26, 2013 3:45 AM

  5091 views | 4 replies