JMP User Community

Latest Discussions

How do I remove a column formula but retain the values (without scripting)

Hi, How do I remove a column formula but retain the values (without scripting)? I remember seeing an answer to this several months ago, maybe at the JMP summit, but I've forgotten and can't seem to figure it out. Thanks,Mike
mikedriscoll

Discussions |
Mar 8, 2018 7:08 AM

25163 views | 10 replies
transform comma into point

Hi everybody, I want to import data files containing values with decimals into JMP files in which commas are replaced by points. how can I do this in a simple way during the import process ? Thanks in advance Paul
paul_apicella

Discussions |
Mar 7, 2018 11:22 PM

15736 views | 6 replies
To fetch records between two date range

Hi, I have the following data table with the first 4 columns being the input and last 2 being the output required. I tried to join two tables to combine column 1-3 and column 4 by matching ID = ID and Adm.Date = Ref.Date. Now I want two output columns (Adm. Date_1 and Dis_Date_1) as shown below. I need the Adm.Date and Dis.Date populated for all the Ref.Date between range of Adm.Date and Dis.Date ...
Rini_Kar

Discussions |
Mar 7, 2018 10:40 PM

6132 views | 4 replies
How do I add prompt boxes for parameters when writing custom SQL expressions
Joeystringer

Discussions |
Mar 7, 2018 2:48 PM

7306 views | 6 replies
JSL- Is there a way to automatically interpolate 'x' values from from 'y' using regression equation?

I'm currently using JSL for the first time to automate data anlysis/reporting. My analysis involves:1. Importing the required data (done)2. Analysing the data (data)3. Using computed data to perform a bivariate analysis and fitting a line (done)4. Using the generated regression equation to predict 'x' for specific 'y' values: Here's where my problem lies. I'd like to have the capability of dynamic...
Ainaskid

Discussions |
Mar 7, 2018 1:06 PM

8361 views | 5 replies

Previous
Next

Latest Discussions

How do I add prompt boxes for parameters when writing custom SQL expressions
Joeystringer

Discussions |
Mar 7, 2018 2:48 PM

7306 views | 6 replies
Using Test Slices

I just had a curiousity about interpretting a test slice result. I have data collected that is repeated over multiple days but my main interest is what occured within each day which is why I use the test slice. Lets say I have this in the slice for a day: Level 1 -1 -1 -1Level 2 1 Level 3 1Level 4 1 If I am thinking of this correct...
Alec1293

Discussions |
Mar 7, 2018 7:34 AM

2926 views | 1 replies
Find R_HOME on mac

I'm running JMP 13 on Mac Pro. I've searched the discussions for this, but everything talks about setting environmental variables in windows - I've seen nothing about Mac. I have a couple of versions of R installed. In my Rprofile.site I've defined libpaths and libraries. When I bring things up in RStudion and check everythings works fine, including R_home (this is for R V 3.4.3). From RStudio:> ...
rwright

Discussions |
Mar 2, 2018 3:09 PM

5540 views | 2 replies
how to change the order of data presented on the x-axis

On graph builder, I'm trying to draw graphs showing relationship between particle size and different solvent ratios used.I NEED to display the ratio on the x-axis as 1:4 1:8 1:16 regardless of the particle size, but instead i can find some sorting ways using corresponding particle sizes (ascending or descending) Attached is the preview of the window i'm working on now , and the data sheet itself...
Abeerosama

Discussions |
Mar 2, 2018 1:45 PM

7786 views | 1 replies
New User Welcome Kit Discussion

The Welcome Kit is designed to track what you've watched and the activities you've completed. However you may need to adjust your browser security settings if it does prompt you to resume your state when returning. You can access the Welcome Kit here. Safari, Chrome and IE 11 work well for caching and storing Kit progress without adjusting your local browser security settings. Please share you...
ryandewitt

Discussions |
Mar 1, 2018 5:57 PM

28719 views | 32 replies

Previous
Next

Latest Discussions

.jsl scripts will lock files even while set to read and execute permissions only

I am having an issue where an add-in script which runs another script via the include(); function is locking the included script file while other users are running it. This renders me unable to update that script. I tried setting the permissions on the repository and the file as read and execute only but it still locks when other users access it.
nbullen

Discussions |
Feb 5, 2018 12:05 PM

2275 views | 0 replies
Sub-sampling data analysis in JMP

In Biology (Plant Sci. and Agriculture) usually we have sub-sampling data for replicates. It's very difficult to analyze these data in commonly use Stat S/W (SPSS/Minitab) because MSS(Error) is calculating wrongly. Without taking averages of samsamples, the easiest S/W for this is using JMP and I need some assistance for this. I've found very useful Youtube video about subsampling in JMP (CRD: S...
Kynda

Discussions |
Nov 15, 2017 2:32 PM

3767 views | 0 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

2650 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

2754 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

3360 views | 0 replies