JMP User Community

Latest Discussions

pat match

Hi, I have a text string that I need to match, and I've been trying pat match() but don't have the grasp of it. The text is a filename. I need to identify all files with a certain pattern: "AB0007 25092019 0822.txt":2 capital letters. "AB" actually always.4 digits and a spaceddMMYYYY (or just 8 digits) and a space4 digits".txt" I've been trying but failed with many versions, latest:file="AB0007 25...
peder

Discussions |
Oct 8, 2019 3:08 AM

3922 views | 2 replies
Unbalanced Panel Data

Hi
I have a list of stocks and their respective indicators and annual return across several years. I would like to do a panel data analysis but my panel data were heavily unbalanced. Can I ask

1) how JMP deals with those missing data when I run the fixed effect mixed model?

2) Where can I find information on how to interpret the mixed model results? Especially on the repeated measures results.
Zephyr

Discussions |
Oct 7, 2019 1:37 PM

3155 views | 2 replies
How to show a decimal digit (DO NOT round numbers on a histogram)?

How to show a decimal digit (DO NOT round numbers on a histogram)? Pls. look pic.
Ted

Discussions |
Oct 7, 2019 9:28 AM

6696 views | 3 replies
For loop question

Hi everyone, First time I'm writing here, though I have read in this forum a lot. I do have some experience in JSL scripting, but I still haven't dealt with for loops. I have this data table which has 5 columns: entity, date1, date2, value1, value2 (value2 column initially contains missing values only). The table is sorted by Entity (ascending) and date1 (descending). I want to loop through all ro...
Yotam

Discussions |
Oct 7, 2019 6:51 AM

8174 views | 7 replies
Merge row in header titles

Hi,Using jsl I have imported an Excel file consisting of several sheets into jmp. In one of the sheets there is a header and a subheader and in jmp I would like to be able to join the subheader (1st row) in the header so that all information is contained in the header.Can that be done?Or can that be defined in the import somehow?Br Julie
JulieSAppel

Discussions |
Oct 7, 2019 5:11 AM

3534 views | 3 replies

Previous
Next

Latest Discussions

Unbalanced Panel Data

Hi
I have a list of stocks and their respective indicators and annual return across several years. I would like to do a panel data analysis but my panel data were heavily unbalanced. Can I ask

1) how JMP deals with those missing data when I run the fixed effect mixed model?

2) Where can I find information on how to interpret the mixed model results? Especially on the repeated measures results.
Zephyr

Discussions |
Oct 7, 2019 1:37 PM

3155 views | 2 replies
How to show a decimal digit (DO NOT round numbers on a histogram)?

How to show a decimal digit (DO NOT round numbers on a histogram)? Pls. look pic.
Ted

Discussions |
Oct 7, 2019 9:28 AM

6696 views | 3 replies
For loop question

Hi everyone, First time I'm writing here, though I have read in this forum a lot. I do have some experience in JSL scripting, but I still haven't dealt with for loops. I have this data table which has 5 columns: entity, date1, date2, value1, value2 (value2 column initially contains missing values only). The table is sorted by Entity (ascending) and date1 (descending). I want to loop through all ro...
Yotam

Discussions |
Oct 7, 2019 6:51 AM

8174 views | 7 replies
Using log of variables in linear regression?

I am a new student using JMP and have a question.I have a dataset with several variables that are heavily skewed as evidenced by their distributions. One is my dependent variable and the others are all independent variables.I create new columns using the Log_variable for the dependent variable and one of the primary independent variables. Both of their distributions improved significantly towards...
jk577648

Discussions |
Oct 6, 2019 5:50 AM

6582 views | 4 replies
How to make one way anova with mean, std, n as input

Hi, I am completely new to JMP. I have googled several guides to one way anova, but they all seem to be based on data sets with all the data points for each category. Whereas I have already reduced my data sheet to the mean, standard deviation and number og points in each sample I am analyzing. Can these be used as input to anova?
CPHAst

Discussions |
Oct 3, 2019 6:49 AM

1908 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

2169 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

1413 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

1371 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

1466 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

1721 views | 0 replies