JMP User Community

Latest Discussions

Create multiple charts with different reference lines

Hi,I would like to accomplish the following task using JSL code:I have an example file (attached) with 4 columns: date (numeric), y_val (numeric), limit (numeric), group (character).The "group" column contains 3 distinct values: A,B,CEach group has a unique value in "limit" column. For example, all group A rows have a value of 67 in the "limit" column. The task:1. I would like to create 3 charts (...
YotamS1

Discussions |
Jan 11, 2023 12:22 PM

1757 views | 4 replies
JSL move files

Can JSL be used to file files with specific name from 1 folder, and move that file to another folder?
Not sure if anyone has tried it.Thanks
Stokes

Discussions |
Jan 11, 2023 11:47 AM

1140 views | 1 replies
Replace missing values with 0

Hello,I'm trying to replace all missing values in a data table with 0. The below script doesn't work. I use JMP 13. Is there any other way to do this? dt = Current Data Table(); nc = dt << get column names( Numeric ); For( i = 1, i <= N Items( nc ), i++, nc[i][dt << get rows where( Is Missing( nc[i][] ) )] = 0 ); Thanks!
nshivan

Discussions |
Jan 11, 2023 6:09 AM

22041 views | 13 replies
CROSS VALIDATION - VALIDATION COLUMN METHOD

When using the validation column method for cross validation , we split the data set into training , validation and test sets. This split ratio is specified by the user. Is there any guideline /reference to decide on the split ratio (such as 60:20:20 / 70:15:15 / 50:25:25 / 80 :10:10). Is it chosen also based on the total number of observations -N ?
sreekumarp

Discussions |
Jan 11, 2023 5:31 AM

6420 views | 10 replies
Replacing a blank row with another row data with an if statement

Hi, I have an original set of data (table1), and I am trying to script it to the result in table 2. If any number that is below 300, will print "type1" string into "result1" column. If any number is above 300, will print "type2" string into "result2" column. Numbertype1type2result1result2100a1a2 200b1b2 150c1c2 275d1d2 555e1e2 424f1f2 572g1g2 783h1h2 125i1i2 Table1: Original data N...
kuanaunwei

Discussions |
Jan 11, 2023 4:58 AM

1676 views | 3 replies

Previous
Next

Latest Discussions

JSL move files

Can JSL be used to file files with specific name from 1 folder, and move that file to another folder?
Not sure if anyone has tried it.Thanks
Stokes

Discussions |
Jan 11, 2023 11:47 AM

1140 views | 1 replies
Multiple comparisons error

Hello, I was wondering if someone who has encountered the same error could help me. I ran a repeated measures ANOVA with unstructured correlation structure and now I want to test for multiple comparisons for those interactions that gave a significant value. However, I am unable to do so because an error message keeps popping up. I'm unsure if I'm doing the analyses wrong. Please help!
HotellingWombat

Discussions |
Jan 11, 2023 3:24 AM

1053 views | 2 replies
Graph builder background map boundary lines disappear

I am working on a geographic map of South Dakota where I want points of individual fields to show up within each South Dakota County. I turn on the background boundary map for US Counties and they all show up for SD and all other states. I then go to customize and click on Shape: US counties and clip US States shape for South Dakota. However, when I do this the lines around the SD state boundary h...
Jasclark4

Discussions |
Jan 10, 2023 6:05 PM

1790 views | 2 replies
How to perform FFT on time series data

Hello All, I have a few questions for the JMP community. 1a. Is it possible to batch process multiple files(.csv's) in JMP? If so how would I go about this?1b. Is it possible to perform FFT on time series data? If so are there other frequency domain analyses than can be performed in JMP? If any of this information is covered some place else I'd appreciate it if you could point me to its location. ...
Damian

Discussions |
Jan 10, 2023 7:29 AM

5513 views | 3 replies
JMP formula for Percentile.INC

What is the JMP formula for Percentile.INC? I have an excel sheet that is not matching up with jmp.
UpliftElk866

Discussions |
Jan 10, 2023 7:21 AM

818 views | 1 replies

Previous
Next

Latest Discussions

Data puzzles via Hanukkah of Data is underway

If you're looking for some data wrangling puzzles, the Hanukkah of Data series of daily puzzles is underway at https://hanukkah.bluebird.sh/5783/. They're on day 2 of 8 now. As far as I can tell, you can do them whenever and there's no competitive part. I'm doing them in JMP, of course!
XanGregg

Discussions |
Dec 19, 2022 11:21 AM

811 views | 0 replies
Slope and Intercept Collector error "matrix must be non-singular in access or evaluation of 'Inv' , Inv/*###*/(x` * x)"

HI all,I have a question about an error I'm getting when using @stan_koprowski's slope and intercept add-in. I've posted my question on the add-in's thread but due to the much lower exposure compared to discussion posts, I thought that it might be a good idea to ask here as well. I made a mock data table with three groups and several observations in each group. When I run the add-in I am getting t...
Lavik17

Discussions |
Dec 19, 2022 10:20 AM

953 views | 0 replies
C Stack Usage Error When Sending Code to R

Hello, I'm trying to invoke some commands in R using the R Submit function in JSL and am getting the error below. Is this an issue with JMP17 and R integration? It only happens when I invoke a specific package using JSL so it's hard for others to replicate w/o installing R and the package as well. I'm using JMP 17.0 and R 4.2.0. Never saw this error with JMP 16. "Error: C stack usage 4123778 is to...
vigslayer

Discussions |
Dec 15, 2022 8:14 PM

987 views | 0 replies
How to fix X Axis Settings for Operating Characteristic Curves

I'm playing around with different scenarios on an Operating Characteristic curve in which the fraction defective is very small (screen shot below). Every time I run a scenario, the x-axis automatically changes to a range that is way too wide to be useful and I have to change it back manually.Is there a way to make the x-axis setting constant? (I'm using Jmp Pro 16.1)Thanks!
The_Annie

Discussions |
Dec 15, 2022 2:29 PM

876 views | 0 replies
Response Screening Effect Size - logistic

Related to the previous post How to get "Effect size" column with Response Screening functionality , I am also wondering how effect size in the response screening platform is calculated, specifically for categorical Y vs continuous X. JMP help shows: "When Y is categorical and X is continuous, the effect size is the square root of the average ChiSquare value for the whole model test." Running b...
wgardnerQS

Discussions |
Dec 14, 2022 12:54 PM

944 views | 0 replies