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

Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesHi 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
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 ...
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...
Hey JMP scientists, I’m working on some cell based assay development projects where I’m using DOEs to try to optimize the parameters I can control in the experiments. Setting up the layouts for 96 and 384 well plates to get a reasonable level of replication and avoid edge effects is kind of a pain. Are there some good strategies that don’t involve randomizing the entire plate with a robot? (alt...
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...
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:> ...
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...
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...
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.
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...
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 ...
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...
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 ...
Jump into Graphing Date: Tuesday, September 16Time: 1:00 – 2:30 p.m. ETDuration:&nbs...
Elaborate on Elaborate: Advanced Interactive Reporting & AI-Enhanced Development In this...
Una introducción práctica para nuevos usuarios, usuarios con licencia de prueba o cualquier persona...
REGISTER HERE *** Note that this webinar starts at a different time than the other Fall 2025...