JMP User Community

Latest Discussions

Multiple Response - unique values

For a column with modeling type multiple response, is there a command in JSL to get the unique values?

Or do I have to generate it manually?Open( "/C:/Program Files/SAS/JMP/17/Samples/Data/Big Class Families.jmp" ); unique_values=Associative Array(Words(Concat Items(:sports << get values() ,","),", ")) << get keys;
hogi

Discussions |
Jun 21, 2023 5:22 AM

975 views | 1 replies
Confused Query Builder or confused user?

As with JMP 17 I am finally able to run the Query Builder without it constantly crashing (there was an unresolved ticket with JMP Tech Support), I really started using it to relatively great effect. However, it is not making some of the selections I tell it to do. This means I have to copy the script and modify it manually to reflect my selections.See the below screenshot for example:"Esterified A...
Ressel

Discussions |
Jun 21, 2023 4:00 AM

1776 views | 4 replies
split data table without including excluded data

Hello all, I am trying to split a data table that has some bad data in it. I have exleded those bad data in the original table, but I don't know why those data are showling up in split table. My script is bellow:dt_daily << New Column( "Outliers Exclusion", Numeric, Continuous, Formula( If( :Mahal. Distances > 1.96, 0, 1 ) ), eval formula );dt_daily << select where( :Outliers Exclusion == 0 ) << e...
Anonymous

Discussions |
Jun 20, 2023 8:33 PM

4350 views | 6 replies
Creating New Rows based on Averages from Previous Rows?

Hello,Perhaps this is a quick fix, but I have a large data-set in JMP with many categories, one of which is a subgroup that each entry belongs to. I'm looking to take averages of the data collected across the entire subgroup and use it to create a whole new row. Is this possible using scripting? I am hoping for an optimized workflow where all it takes is a button to do this across different files....
WebArmadillo869

Discussions |
Jun 20, 2023 2:11 PM

1183 views | 2 replies
should i use principal component analysis or k-means cluster analysis?

Hi - I am trying to decide the best method of cluster analysis (e.g. principal component analysis, k-means, etc) to use for the following situation. I have a mapped dataset with 12,928 records, each corresponding to a well with sample results. Each row of data (each location on my map) has a well name, latitude, longitude, and results of compound A, compound B, compound C, compound D, compound E...
learning_JSL

Discussions |
Jun 20, 2023 12:25 PM

7881 views | 10 replies

Previous
Next

Latest Discussions

split data table without including excluded data

Hello all, I am trying to split a data table that has some bad data in it. I have exleded those bad data in the original table, but I don't know why those data are showling up in split table. My script is bellow:dt_daily << New Column( "Outliers Exclusion", Numeric, Continuous, Formula( If( :Mahal. Distances > 1.96, 0, 1 ) ), eval formula );dt_daily << select where( :Outliers Exclusion == 0 ) << e...
Anonymous

Discussions |
Jun 20, 2023 8:33 PM

4350 views | 6 replies
issue to insert date variable into customsql

Hi,I want to set the start and end datetime as variable then insert into customsql. in method one below, JMP Alert of converting issue. When I simply hard coded the start and end date as variable, it run without issue. I check both the start and end date type in both method, both are string(). Event the custom sql after substitute into are identical. I cannot find out why the method one not workin...
dadawasozo

Discussions |
Jun 20, 2023 11:48 AM

1483 views | 4 replies
How to set Scale Values in Graph Builder use Col Quantile function?

HI, I want set Scale Values in Graph Builder use Col Quantile function, but always something wrong. the red code have some problem. I need color scale as Quantile Graph Builder( Size( 839, 726 ), Variables( X( :Prober_X ), Y( :Prober_Y ), Color( :OpticalPower ) ), Elements( Points( X, Y, Legend( 6 ) ) ), SendToReport( Dispatch( {}, "400", ScaleBox, {Legend Model( 6, Pr...
Solarwing

Discussions |
Jun 20, 2023 9:32 AM

656 views | 0 replies
How To overlay a circle on existing graph builder plot

Hello, I'm taking a baby step of JSL. I'd like to overlay a 150mm radius circle on the below image, which is a graph builder generated defect map example of silicon wafer. I just figured out "Circle({0,0}, 150 )" command, but it doesn't seem to work when I implemented the command in JSL script of the plot. Could anyone help how to add a circle on it?
Albatross

Discussions |
Jun 20, 2023 5:52 AM

3478 views | 6 replies
JMP and Bayesian Inference

Hello, I was curious if JMP is compatible with Bayesian Inference and Statistics. I am currently working on a DOD sponsored project related to Bayesian decision theory and inference, related to Joint Test & Evaluation. Thank you.
808duck

Discussions |
Jun 20, 2023 5:43 AM

1206 views | 1 replies

Previous
Next

Latest Discussions

How to set Scale Values in Graph Builder use Col Quantile function?

HI, I want set Scale Values in Graph Builder use Col Quantile function, but always something wrong. the red code have some problem. I need color scale as Quantile Graph Builder( Size( 839, 726 ), Variables( X( :Prober_X ), Y( :Prober_Y ), Color( :OpticalPower ) ), Elements( Points( X, Y, Legend( 6 ) ) ), SendToReport( Dispatch( {}, "400", ScaleBox, {Legend Model( 6, Pr...
Solarwing

Discussions |
Jun 20, 2023 9:32 AM

656 views | 0 replies
New Series on JSL and Visual Code Studio

Just a heads up that we've been posting some additional JSL tricks on our LinkedIn Blog. We have a weekly series that's been running currently focused on our Visual Code Studio Extension for JMP. Week 1: https://www.linkedin.com/posts/predictum_automationjmp-series-use-vs-code-extension-activity-7062456347543359488-uzFu?utm_source=share&utm_medium=member_desktopWeek 2: https://www.linkedin.com/...
wjlevin

Discussions |
Jun 19, 2023 2:26 PM

1051 views | 0 replies
Overlaying histograms: Iterating a function through N number of columns?

@PatrickGiuliano , As a response to our latest discussion : Re: How to overlay histograms in JMP Thanks a lot for the response. Also, 1) I would like to get more guidance on ' possibilities of iterating the Overlap function for more columns ( N number of Columns), if possible. the code for : Y Function(N, x): can be iterated ? Y Function(N, x);
For(i = 1, i <= N Col(xm), i++,
ym[i] = Min(Normal D...
DecileDromedary

Discussions |
Jun 19, 2023 6:31 AM

590 views | 0 replies
problème importation base oracle avec Jump

bonjour, quand j'importe une base type oracle avec Jump, j'obtiens pour certaines valeurs des caractères spéciaux; voir image.alors que dans la base de données, les cellules sont vides. est-ce que celà vient du client Oracle sur mon poste?est-ce que celà vient de la base oracle sur le serveur,est-ce que celà vient du client Jmp? cordialement
Françoise

Discussions |
Jun 12, 2023 9:12 AM

648 views | 0 replies
Combine Rule

Referring to Rules: Stepwise Regression Control Panel (jmp.com) and Example of the Combine Rule : JMP Help Could somebody please further elaborate on the 2 tests when considering the entry for a term. It would also be immensely helpful if the explanation was based on stepwise backward selection. "Calculates p-values for two separate tests when considering entry for a term that has precedents. The ...
CorpVi

Discussions |
Jun 12, 2023 2:59 AM

773 views | 0 replies