Recoding column with both char and num
I am working on a dataset with > 1M rows, with a column 'Reported Results'. In this column, approx. 3000 rows contain a '<' or '>' (always followed by a value, e.g. <100), all other rows...
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesI am working on a dataset with > 1M rows, with a column 'Reported Results'. In this column, approx. 3000 rows contain a '<' or '>' (always followed by a value, e.g. <100), all other rows...
Hi, I am transitioning from running microarray data in JMP Genomics to JMP Pro. I routinely use the predefined JMP Genomics scripts such as: Analytical Processes/Workflows/Basic/Basic Express...
Hi. Does anyone know if there is a scripting method to add text on top of a plot? For example, I have a script to create a pareto plot and I'd like to add text over the plot, as shown in ...
I'm trying to consolidate this data table. I previously used Excel for it but it is >18,000,000 lines of data which is too big for Excel. I have multiple different values for the same ...
...ome groups. Here is my script, I am still working on it, I am using JMP Pro 17.0.0 on a MacBook: Names Default To Here( 0 ); Clear Log(); dt = Current Data Table(); If( Not( Is S...
I am working on a dataset with > 1M rows, with a column 'Reported Results'. In this column, approx. 3000 rows contain a '<' or '>' (always followed by a value, e.g. <100), all other rows...
Hi, I am transitioning from running microarray data in JMP Genomics to JMP Pro. I routinely use the predefined JMP Genomics scripts such as: Analytical Processes/Workflows/Basic/Basic Express...
I'm trying to consolidate this data table. I previously used Excel for it but it is >18,000,000 lines of data which is too big for Excel. I have multiple different values for the same ...
Hello all, I am new to posting on this forum, so excuse me on my etiquette. I am wondering if someone might direct me towards an add in , or another test that is similar to a non pa...
I've got a large dt (70k cols, character) that I'm digging through. Most cols have a wide range of values, but a noticeable population of them have only two nuisance values. I want to identify all th...
What determines which data table is seen as associated data for a new window? First drawn report and it's data table? Something else? Is there a way to change that associated table / determine on cre...
I have difficult to get the filepath correct. Error message says "Cannot open table in access or evaluation of ....(Filepath)"
...erformance of code (https://community.jmp.com/t5/Discussions/Differentiate-between-entire-column-and-current-row/m-p/677701/highlight/true#M86401) - to bugfix my code - to find out more about the nuts and b...
It seems the following command does not work for JMP MacOS. Use JMP Locale Settings( 0 ) Is there a general script to deal with the following scenario? Or do we need to put cond...
Hi, I noticed some strange behavior in Graph Builder which is caused by the fact that formatting like One example: If the top-most plot (#1) has some specific settings and this plot is removed, ...
Learn the basics of using JMP without leaving your desk. Sign up for complimentary Web training, liv...
This webinar is in English, 2:00 p.m. US Eastern Time. See the variety of interactive ways JM...
4 Day Course Monday, July 22| 9:00 a.m. - 12:30 p.m. ET Tuesday, July 23 | 9:00 a.m. - 12:30 p.m....
Learn the basics of using JMP without leaving your desk. Sign up for complimentary Web training, liv...