Welcome to the JMP User Community!

Latest Discussions

• Calculate moving average for By-Groups

  I'm trying to calculate a moving average for a data-set containing several rounds of the continuous data. That is, I want a calculated average for every data-point, including the first and last. The average should be 7 steps in either direction, except for either end, where non-existing data beyond the 7 step window should simply ignored. Of course I don't want data form different By-Groups to be ...

  JesperJohansen

  Discussions |

  Jul 22, 2013 10:53 PM

  10427 views | 4 replies

• password protection in a data table

  Hello all,I was wondering if there is a way to password protect a data table in JMP 10. Any input would be much appreciated. Thanks!

  danielsh

  Discussions |

  Jul 22, 2013 8:07 AM

  5948 views | 5 replies

• Renewing the License

  I don't know if this is possible, I couldn't find anything in the JMP documentation on this, BUT what I'm wondering is, can I write a script to call the renew license() command but pass along to it where the license file is without users having to navigate to it?  I tried renew license("C:\Program Files\SAS\JMP\10\license name.txt") but it complained there were too many arguments.  I also tried a ...

  Anonymous

  Discussions |

  Jul 22, 2013 8:06 AM

  14581 views | 1 replies

• How to extend the IF command in a formula? Equivalent of select;when;when;otherwise;end;

  Hi, I want to be able, in a scripted formula, to assign a text string to column depending onthe values of another column.For instance:A  B1  Low2  Low3  Low4  Medium5  Medium6  Medium7  High8  High9  High10 HighHow does the formula lok for this?  If(:A<=3,"Low",:A>=3 and :A<7,"Medium",:A>=7,"High") does not work.I Base SAS there is a command, select(); when();when(); ; ; otherwise;end; It is the e...

  poulravn

  Discussions |

  Jul 22, 2013 6:49 AM

  16925 views | 5 replies

• Copy/Paste without Formula Efficiently?

  Could someone tell me the best way to copy/paste an entire column values into a new column efficiently (I have more than a million rows)?The method i'm currently using is to get all values, store them to a list, and then set the values to a column, but I noticed that this is much slower than if you select the column in the table, and click paste on the column.The reason I'm trying to do this is th...

  euge

  Discussions |

  Jul 17, 2013 4:05 PM

  10279 views | 1 replies