date calculation
Hi, In Excel, I use the date function to get the date (d/m/y) from the year and the day of year (ex.: =DATE(2025;1;32) . How can I get the same formula in JMP? regards
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesHi, In Excel, I use the date function to get the date (d/m/y) from the year and the day of year (ex.: =DATE(2025;1;32) . How can I get the same formula in JMP? regards
dt=Open("$SAMPLE_DATA/Big Class.jmp");
scriptContent = dt << Get Script("Oneway");
d9 = New Table("A");
d9 << New Script("Oneway", scriptContent);
Thanks Experts!
Its original python library is located at C:\Users\Administrator\AppData\Roaming\JMP\JMP\Python\Python311\Scripts
How can it be moved to I:\0userR\JMP\JMP\Python\Python311\Scripts
It does not affect the application data of other software.
Thanks Experts!
Hi everyone, I'm Ajay Hinduja from Geneva, Switzerland, currently working on analyzing customer data for a travel website, and I’d love your input. How do I cluster frequent flyers or hotel guests using JMP? Regards Ajay Hinduja Geneva, Switzerland
With JMP 17, the Files in Directory script command appears not to work if there are leading numbers, or numbers in the file name. The Watch window returns various errors unless all file names are number free.
<jsl> folderPath = "C:\Users\first.last\documents";
<jsl> fd = Files In Directory( folderPath,1,1 );
<jsl> w = Watch ( fd );
Is this fixed in a different release? Suggestions?
Its original python library is located at C:\Users\Administrator\AppData\Roaming\JMP\JMP\Python\Python311\Scripts
How can it be moved to I:\0userR\JMP\JMP\Python\Python311\Scripts
It does not affect the application data of other software.
Thanks Experts!
Hi everyone, I'm Ajay Hinduja from Geneva, Switzerland, currently working on analyzing customer data for a travel website, and I’d love your input. How do I cluster frequent flyers or hotel guests using JMP? Regards Ajay Hinduja Geneva, Switzerland
When looking for unique values in a column, `summarize()` is often used. However, the values outputted by `summarize()` are sorted, and the output in following JSL would look like this: {"64", "67", "74",..., "172"}. I would like the output to be arranged in the order they appear in the column, for example: {"95", "123", "74",...}. What modification should I make to achieve this result?
Names D...
Hi All, I have a data set (x and y) that I need to approximate to the 2nd degree polynomial (ax2+bx+c) and report "a" value in the "a"-column. Is there a potential script for this? Please see JMP table attached. Thank you All!
Does anyone have a jsl snippet of code that can remove the 5th percentile from a dataset? I've tried using the table summary.
Might be able to do it with the distribution chart.
Hello, I am a user of JMP Live.
I am currently utilizing a simple function within JMP to leverage the Auto Refresh feature in JMP Live for dashboard purposes. However, while the function operates correctly on my PC, it does not work properly on JMP Live.Even though I have disabled "Suppress Eval" before executing Data Publish, when I later download the data, the column where the function should be ...
Integrating tools like JMP and MATLAB offers a streamlined approach to engineering analysis, making workflows more efficient and reducing the need for redundant script rewriting. By leveraging JMP’s powerful data analysis and visualization capabilities alongside MATLAB’s robust computational tools, engineers can seamlessly combine the strengths of both platforms. This integration allows for the ra...
I'm trying to run R code in JMP to create a plot. I succeeded in importing the plot in png format, but failed to adjust the size of the plot.
I can adjust the "plot_from_R" in png format with the set size(); function in jsl, but it is not proportional and distorted.
How can I import plot_from_R in the size I want?
R Init();
R Submit(
"\[
windows(300,100) #it doesn't work
plot(function(x) dnorm(...
from: https://www.jmp.com/support/help/en/18.1/?os=win&source=application#page/jmp/advanced-expressions-macros-and-lists.shtml# If you assign the expression x+y to a, quoting it as an expression with Expr, then whenever a is evaluated, it evaluates the expression using the current values of x and y and returns the result.
Exceptions are the utilities Show, Write, and Print, which do not evaluate e...
This works: Extract Expr(:height << set name( "new" ), :height ); But this one doesn't *):Extract Expr(myDataTable:height << set name( "new" ), myDataTable:height );Fortunately there is this dirty trick of Extract Expr (it automatically resolves every defined variable **) - which allows this workaround:x = Expr( myDataTable:height);
Extract Expr(myDataTable:height << set name( "new" ), x ) *) why...
Una introducción práctica para nuevos usuarios, usuarios con licencia de prueba o cualquier persona...
JMP Live offers JMP users collaborative analytics software to share analyses from JMP to a secure, c...
French Mastering JMP Transformez des données brutes en informations exploitables grâce à l’éditeur d...
EMEA Mastering JMP Experimenting with microbial and mammalian systems brings a multitude of data; bi...