JMP User Community

Latest Discussions

Script to add leading characters (leading zeros in this case)

What's the syntax to have a column operate on itself?

This is the best I could come up with and it doesn't work. dt = current data table(); column(dt, "Architecture") << Set Each Value( Repeat("0",3-Length(Char("Architecture")))||Char("Architecture")); Column Architecture has values like 1, 2, 123, XXX, etc. Length is not standard.Want a script that will run on the table and covert the column to s...
BSwid

Discussions |
Sep 20, 2019 6:33 AM

7966 views | 5 replies
Weekly and seasonal forecast

Hi AllI have daily patient ED cases data for past 3 years. The initial trend run it is obvious that it has seasonality ( high in summer and low in winter) .At the same time it also has weekly trend ( high on Monday)How can we deal with two level of adjustment? I want to incorporate both ( seasonal and weekly) to suggest for optimal staffing models.Please advise. Thank you
Chuiee

Discussions |
Sep 20, 2019 5:38 AM

6073 views | 9 replies
How to calculate confidence intervals for multinomial proportions?

I have the following data:20%
30%
40%
10%Let's say for the type of a some product: a. b, c, d (respectively)
How to calculate confidence intervals for each proportion?P.S. In this imitation example, we consider (for simplicity) that absolute numbers are also: 20, 30, 40 and 10 (total number: 100)
Ted

Discussions |
Sep 20, 2019 1:33 AM

36672 views | 9 replies
Manually enter row title on Tabulate platform?

On the Tabulate platform, is there a way to change the names of columns as they are displayed in the table? I do not want to change the actual column title in the data table itself; I just want to change the words that are displayed on the Tabulate report. I made a simple example table to show what I mean: I simply want to type over the column title with more descriptive words. Similar to how ...
Chris_Rodrigues

Discussions |
Sep 19, 2019 12:45 PM

2795 views | 1 replies
User Entered Values to Column values using JSL

I am new to JSL Scripting.I am trying to populate a column using entries from a panel box.In part of my code below, I am trying to get the value entered ,34, to populate a column named Price Code. However, when I run this code an empty column is returned.I have tried using Get Values (Num) in place of Set Values(Num) and I still get an empty Price Code column. dataTable = New Table( "Data Table",...
adel922

Discussions |
Sep 19, 2019 7:13 AM

13561 views | 17 replies

Previous
Next

Latest Discussions

Replace Third Character from Left in a String in JSL

I would like to take a column with a string in it, and in each row, replace the third character from the left with a "9." How might I go about this using JSL?
twillkickers

Discussions |
Sep 18, 2019 2:36 PM

2312 views | 1 replies
Multiple Contingency Tables - How do I get the name of the filter category

I am creating a report based on a very large set of Contingency tables created by using Fit Y by X, by factor Z. Example:A Data Table has three columns X, Y, ZWhen I select Analyze, Fit Y by X, By factor Z, I get all contigency tables, where each table is for each Z factor. The only row in each contingency table I want is the row% so I deselected display of the other three rows before selectin...
JensRiege

Discussions |
Sep 17, 2019 1:01 PM

3903 views | 4 replies
Estimating slopes and intercepts in ANCOVA

I am feeling particularly dumb today and hope someone can help me feel smarter. When running an ANCOVA with separate slopes, I would like to get estimates of the slopes and intercepts of each group along with the t-tests of significance. In SAS, I can run GLM and specify the model like this (using the JMP "Drug" data table):model y = Drug Drug*x / noint solution; I cannot find anything in JMP th...
abh1

Discussions |
Sep 17, 2019 12:48 PM

5131 views | 7 replies
Reproducing the Variability / Attribute Gauge Chart as a script

I’m in the midst of creating a Custom Starter for JMP like the one described here: https://community.jmp.com/t5/JMP-Add-Ins/JMP-Custom-Starter-Six-Sigma-DMAIC-Menu-Add-in/ta-p/29384 My question is a bit involved, so please bear with me. I have a problem re-creating one of the JMP standard menu items, namely the “Variability / Attribute Gauge Chart” found in the Analyze: Quality and Process menu sy...
kevinatkodak

Discussions |
Sep 17, 2019 9:55 AM

6870 views | 6 replies
integration of JMP into Jupyter notebooks

Context: initial model development is with JMP Pro-14. Further model development and processing is done with Python using Jupyter notebooks. At a relatively high frequency, JMP graphical interface is preferred to the static graphics provided by Python libraries. I know that JMP score code can be exported as Python and as such integrated into notebooks. Are there any other touch points with Jypter...
robert_reviere

Discussions |
Sep 16, 2019 1:36 PM

2340 views | 1 replies

Previous
Next

Latest Discussions

Extract Report Data and Export it to Excel

I am totally new to the JMP community and have a limited coding background. I am working with Life Distributions (Weibulls mostly), and I would like to create an Add-in that can do the following tasks once I have selected the best distribution fit: 1. Save specific report data from distribution (see the data tables in red) 2. Export the data into an excel sheet 3. Have the add-in button available ...
jemairsmartes

Discussions |
Sep 11, 2019 10:27 AM

2155 views | 0 replies
How to Add Profit Matrix to Neural Net Confusion Matrix

Hi all, I'm using a neural net to predict whether or not a customer will prefer to buy retail items at a markdown or if they are likely to buy full-price (i.e., "bargain buyers" vs. traditional shoppers). I'd like to incoporate the opportunity cost of a false positive (giving discounts to what would otherwise be a full-price shopper) using a profit matrix, but changing values on the matrix in the ...
GhostBen

Discussions |
Aug 5, 2019 8:00 PM

1399 views | 0 replies
Capability Animation - How to see the LSL/USL Value?

I just discovered this nifty tool called the Capability Animation, where you can play around, dragging the spec limits and mean shifts, and it simulates your capability indices. But, I cannot see the actual LSL/USL values as I drag them! Does anyone know how to make this happen?
Antonio80

Discussions |
Jul 9, 2019 1:31 AM

1361 views | 0 replies
Unable to allocate enough memory in access or evaluation

Hi,I'm trying to use the Multivariate platform to perform a correlation between 6 time points (rows) across 73500 columns. My final goal is to output a 73500x73500 correlation matrix. When I try to run it, I immediately receive this pop out message:Unable to allocate enough memory in access or evaluation of 'List' , {/*###*/Estimation Method( 0 ), Matrix Format( 2 )} What's the issue? I'm using J...
ns

Discussions |
Jul 8, 2019 9:04 AM

1452 views | 0 replies
How to Post JSON data to a site via API functionality: "Unsupported Media Type"

Hi There, I am trying to perform a POST request to post some JSON data to a server, but unfortunately as of now I keep getting a 415 error. The goal of this script is to upload a JSON formatted file (or something of the like) to the server for other users to download/read. I noticed that there are very few POST examples with JSL, but quite the abundance with GET, which I have no problems with. I w...
liqinglei419

Discussions |
Jul 2, 2019 6:33 AM

1707 views | 0 replies