JMP User Community

Latest Discussions

Hopefully JMP16 will refine these recommendations.

I am glad to see that JMP15 has been produced.
To make the JMP victory smoother, here are some tips:
1. When JMP changes the new language in stock selection, it will revert to the original language. All the previously set Settings have disappeared, only the default Settings have been restored.
lwx228

Discussions |
Sep 24, 2019 7:30 AM

2725 views | 4 replies
Iterate through rows and select matching rows script then average

Hello, I am trying to write a script that uses one column to select matching cells there and then use those selected rows to find the average of the numbers in the column next to it but am not quite sure how to do that. Here is an example table of what I am working on (the last average cloumn is what I need a script to do):Matching Column:Numbers:Average of grouped numbersa23a43b24b44b64c36c66c96...
KdeWitt

Discussions |
Sep 24, 2019 7:25 AM

4020 views | 3 replies
CV, GCV & smoothing parameter (alpha) in p-spline?

Hi everyoneplease; how to calculate CV, GCV & smoothing parameter (alpha)in penalized spline regression? regards;
Raaed

Discussions |
Sep 24, 2019 4:35 AM

4076 views | 4 replies
how to loop through by variable while plotting variable plots

Hi,I am trying to plot multiple variable charts where Y axis is different columns containing MIP in the column name.I have a column called step name and I need these plots for different step names.Eg: MIP1 for stepA and stepB and so on.I can use "By" variable while creating the plots.But how do I extend this to multiple steps. dt = Open( "C:\REPORT.csv" ); a = "MIP_"; col = dt << get column names...
ENTHU

Discussions |
Sep 23, 2019 9:32 PM

2917 views | 3 replies
What is the difference between Open Database() and New SQL Query() when accessing databases?

Hi, I am trying to pull down a view from an Oracle database. The Data Base Name is ACTPROD.WORLD, Schema is ABASE, and Table is RPT_H25_3MONTHS_VIEW Using Database -> Open Table, JMP created the following script:Open Database( "DSN=ACTPROD.WORLD;UID=;PWD=;DBQ=ACTPROD.WORLD;DBA=W;APA=T;EXC=F;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;BTD=F;BNF=F;BAM=IfAllSuccessful;NUM=NLS;DPM=F;MTS=T;MDI=F;CSR=F;FWC=...
BrianG

Discussions |
Sep 23, 2019 12:15 PM

4213 views | 4 replies

Previous
Next

Latest Discussions

Hopefully JMP16 will refine these recommendations.

I am glad to see that JMP15 has been produced.
To make the JMP victory smoother, here are some tips:
1. When JMP changes the new language in stock selection, it will revert to the original language. All the previously set Settings have disappeared, only the default Settings have been restored.
lwx228

Discussions |
Sep 24, 2019 7:30 AM

2725 views | 4 replies
CV, GCV & smoothing parameter (alpha) in p-spline?

Hi everyoneplease; how to calculate CV, GCV & smoothing parameter (alpha)in penalized spline regression? regards;
Raaed

Discussions |
Sep 24, 2019 4:35 AM

4076 views | 4 replies
how to loop through by variable while plotting variable plots

Hi,I am trying to plot multiple variable charts where Y axis is different columns containing MIP in the column name.I have a column called step name and I need these plots for different step names.Eg: MIP1 for stepA and stepB and so on.I can use "By" variable while creating the plots.But how do I extend this to multiple steps. dt = Open( "C:\REPORT.csv" ); a = "MIP_"; col = dt << get column names...
ENTHU

Discussions |
Sep 23, 2019 9:32 PM

2917 views | 3 replies
What is the difference between Open Database() and New SQL Query() when accessing databases?

Hi, I am trying to pull down a view from an Oracle database. The Data Base Name is ACTPROD.WORLD, Schema is ABASE, and Table is RPT_H25_3MONTHS_VIEW Using Database -> Open Table, JMP created the following script:Open Database( "DSN=ACTPROD.WORLD;UID=;PWD=;DBQ=ACTPROD.WORLD;DBA=W;APA=T;EXC=F;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;BTD=F;BNF=F;BAM=IfAllSuccessful;NUM=NLS;DPM=F;MTS=T;MDI=F;CSR=F;FWC=...
BrianG

Discussions |
Sep 23, 2019 12:15 PM

4213 views | 4 replies
How to evaluate model accuracy on holdout set

Hello, I am using JMP 13 and I can not seem to find a way to automaticaly evaluate my model's accuracy on the holdout set. I am buliding a linear regression model.So I would like to preserve the model (with the contained effects and estimates sizes), which was bulit on the training set, but calculate accuracy predictors (R^2, R^2 adjusted and RMSE) on the holdout set. In the moment the only soluti...
Danijel_V

Discussions |
Sep 21, 2019 4:34 AM

2561 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

1398 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

1358 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

1706 views | 0 replies