JMP User Community

Latest Discussions

Export data table to Excel using scripting

Dear community members, I encountered a problem with the JMP EXCEL export to xlsx files and the reimport to Filemaker PRO. Saving a JMP data table as an xlsx file and trying to import it FileMaker results in the correct number of imported rows and columns, but no data is being transfered. Open the xlsx file in EXCEL and saving the file again in excel solves the problem. Any suggestions what could ...
shs

Discussions |
Nov 14, 2017 7:00 AM

10289 views | 7 replies
PCA Model Validation Techniques

PCA can be used to build a model that describes a set of observations. Using the multivariate platform it is possible to perform jacknife and T2 outlier analysis to check if any of the observations are extreme relative to the multivariate mean.In what situation might a weights column be used to build the model?If you use a PCA model how do you maintain it? If I have a new observation(s), I can app...
stephen_pearson

Discussions |
Nov 14, 2017 6:53 AM

5837 views | 3 replies
Schedule JMP Scripts to run Automatically in Windows 10.

I currently (Using Windows 7 and JMP 13) run a few scripts each morning using the windows scheduler, which works a treat.I now have a new computer which has Windows 10, when I run the same scheduler, it opens the JSL script but will not run automatically. Does anybody have a simple soluation to this problem ?
ivan_j_moore

Discussions |
Nov 14, 2017 6:14 AM

12699 views | 3 replies
Combining entries of N columns into single column based on unique entries

Hi,I have N columns, which have character data that I want to consolidate into a single column. For a given row many of the columns can be blank or contain repeated/same values ( as compared to the entry in another column ). I know there is the function under Cols --> Utilities --> Combine Columns & this will generate a new column with all the fields side by side & delimited. I need advise on ho...
mpanggabean

Discussions |
Nov 13, 2017 9:15 PM

15069 views | 6 replies
Running Count of Repeated Values JSL Script?

I would like to script a running count or cumulative sum of repeated values within a column.For example, first appearance should equal 1, max value of count by value specified should equal the cumulative sum of the value within the column.colorcount_colorRED1RED2BLUE1YELLOW1RED3Ideally, the output for :count_color would not need the data table to be sorted by :colorThanks.
aandw

Discussions |
Nov 13, 2017 5:05 PM

16693 views | 6 replies

Previous
Next

Latest Discussions

PCA Model Validation Techniques

PCA can be used to build a model that describes a set of observations. Using the multivariate platform it is possible to perform jacknife and T2 outlier analysis to check if any of the observations are extreme relative to the multivariate mean.In what situation might a weights column be used to build the model?If you use a PCA model how do you maintain it? If I have a new observation(s), I can app...
stephen_pearson

Discussions |
Nov 14, 2017 6:53 AM

5837 views | 3 replies
How can I move the x-axis on top of graph?

Hi, I'm trying to create a trace element concentration profile and need to have the x-axis (concentrations) at the top of the graph so that it can show how the concentration varies down-core .. Is there any way to do this?
maribliss

Discussions |
Nov 13, 2017 6:55 AM

5270 views | 2 replies
Conceptual question about the profit matrix

This issue has been discussed previously, but I keep finding myself confused about how to use the profit matrix. My question is conceptual in nature, so let's just use some simple numbers. Suppose I have data on customer churn and I build a predictive model for churn (the particular technique does not matter for this question). My decision errors are not symmetric, however, so I want to modify ...
dale_lehman

Discussions |
Nov 10, 2017 6:02 AM

2805 views | 0 replies
Calling RESTful Web Services from JMP

Is there a way to invoke a restful web service from JMP? If so, are there any code examples that can be shared?RESTful Web Services from within JMP
bernie

Discussions |
Nov 8, 2017 4:27 PM

14080 views | 2 replies
tabulate function wrap text

Hi all, Is there a way to wrap text/ Fixed width in Tabulate data table. Now I have so many parameters that table becomes long that it's shrinking the size of the graphs(which is of fixed width)? Thank you so much.
vishwasanj

Discussions |
Nov 8, 2017 1:45 PM

3800 views | 1 replies

Previous
Next

Latest Discussions

Conceptual question about the profit matrix

This issue has been discussed previously, but I keep finding myself confused about how to use the profit matrix. My question is conceptual in nature, so let's just use some simple numbers. Suppose I have data on customer churn and I build a predictive model for churn (the particular technique does not matter for this question). My decision errors are not symmetric, however, so I want to modify ...
dale_lehman

Discussions |
Nov 10, 2017 6:02 AM

2805 views | 0 replies
Confirmation of Repeated Measures Analysis, when sphericity if voilated

Hi Everyone, I would like confirmation on the appropriate analysis to run on a repeated measures design.Experimental design:Independent variable: Nutrient treatment (Control, Low, Med, High),Dependent variable: basal diameter, 5 replicates (plants)Repeated measurements were taken at Weeks 0, 1, 4, 7, 10, & 12Split data-> Fit Model-> Y: basal 0, basal 1, 4, 7, 10, 12, Add: Nutrient treatmentPers...
uamiller

Discussions |
Oct 23, 2017 8:07 AM

2906 views | 0 replies
Cox Proportional Hazard - adjusting risk ratio with std dev

I'm working with someone who is using SAS and I'm trying to do the same analysis in JMP. When I questioned their hazard ratio they said it was adjusted by the standard deviation. They commented:In order to obtain results in units of 1 standard deviation – you simply get the standard deviation value for parameter of interest and introduce it in the PH regression statement, for example:proc phreg ...
Maureen

Discussions |
Aug 22, 2017 1:18 PM

3519 views | 0 replies
JSL How do I wrap the title text of a OutlineBox?

Hi all, I often use the Set Title() message to overwrite the OutlineBox titles of charts, distributions, etc. My first issue is that the OutlineBox does not support the Set Wrap() message. Is there any replacement I could use? To work around the missing Set Wrap(), I started inserting newlines "\!n" in the tiitle text. After doing this, I have noticed a second issue: Whatever number of newlines I ...
AlexanderKrebs

Discussions |
Jun 13, 2017 5:38 AM

4574 views | 0 replies
Printing worksheet with cell colors

Hello JMP Community, I'm currently using JMP version 10.0.0 and having trouble printing my data table with cells highlighted in certain colors. Is there a way to print keeping the colors or to even export the file keeping the cells highlighted?

Thanks.
ferdt58

Discussions |
May 16, 2017 9:14 AM

2286 views | 0 replies