Welcome to the JMP User Community!

Latest Discussions

• Can not open excel file

  I have a folder with dozens of excel files, all of them are 2010, all were made from the same template file.  However, on some of them I get the following error when I try to open them in my script"There was an error opening the file in the Excel Wizard. Files older than Excel 97 might fail to open. Using the Open All Sheets preference should work in this case.{320}"If I try to open the offending ...

  rleeper

  Discussions |

  Apr 28, 2017 6:24 AM

  13176 views | 2 replies

• How to store data in a list?

  Hi everyone, I face a problem on how to store the subset data table into a list, below is my code : dt = Open (<path of file>); p= {"G_40", "F_45", "E_57", "F_85", "H_90"}; For( i = 1, i <= N Items( p ), i++, dt << Select Where(Starts With( dt:ftf, p[i] ) ) ; tempDT = dt << Subset( output table name( "Subset" ), selected rows( 1 ), selected columns( 0 ), "invisible"); ); I plan to store tempD...

  jade

  Discussions |

  Apr 27, 2017 5:20 PM

  22933 views | 8 replies

• JMP12 Add-In Folder Moved (Local=>Roaming)

  As I'm migrating some of my JSL scripts from JMP11 to JMP12, they are Add-In's, I've noticed they would not work.  The root cause is that JMP12 is now using the \Roaming folder, where as JMP11 and before used the \Local folder.  Does anyone know why JMP12 Add-In's are now using the Roaming folder?  Same Windows 8 in each case, same PC: JMP11: C:\Users\<myname>\AppData\Local\SAS\JMP\AddInsJMP12: C:...

  djhanson

  Discussions |

  Apr 27, 2017 2:17 PM

  5439 views | 3 replies

• Calculate Moving Average Using Last 3 Time Periods

  I have a set of data with three columns; Customer, TimePeriod, and Quantity. TimePeriod is in the format of yyyymm. I'm trying to determine a formula to calculate a "rolling average" over the last 3 time periods, across all customers.   For example, In my row labeled 201704, I want a formula to return the average Quantity for all records from 201703, 201702, and 201701. The TimePeriod can occur mu...

  Risslemc

  Discussions |

  Apr 27, 2017 9:46 AM

  10565 views | 8 replies

• Save Analysis to Table Using Variable (in JSL)

  All,     Trying to figure out how to save an analyses to a data table using a variable . I tried multiple options : 
  
  1. Option 1 : Adding Col List to table as a variable   dt = Open("$SAMPLE_DATA/Big Class.jmp"); myvar = dt << Get column Names("String"); dt << Set Table Variable("ColNames", myvar); dt << New Script("Save Analyses Using Variable", Bivariate(myvar[2],myvar[4],Fit Line) );
  
  2. Using the...

  uday_guntupalli

  Discussions |

  Apr 27, 2017 7:58 AM

  6442 views | 1 replies