JMP User Community

Latest Discussions

Filter in query builder contains 102 different strings

In SAS 9.1 I a had a script querying a medication table with a list of over 100 different medications.If the list was especially long I would create a spreadsheet in Excel and import the list into the work space, write a script matching where a.description = b.description.Neither function appears in JMP. I cannot bring in an Excel file, cannot bring in another table, ONCE THE CONNECTION TO THE ORA...
MeatPopsicle

Discussions |
Apr 12, 2018 6:06 AM

4893 views | 5 replies
determination of sample size

Dear All, my sample population of each batch is 810.000 tablets for pharmaceutical product. I analyse 7200 sample for each batch. I want to reduce my sample size. Is there a statistical approach for this? I try to use Menu, DoE, Design Diagnostics, sample size and power, one sample mean part of jmpI do not change alpha value. my Std Dev is 0.3mg. My lower/upper spec is 1.3mg lower/higher than mea...
nac

Discussions |
Apr 12, 2018 5:40 AM

5262 views | 3 replies
How to append charts into a report with tabs

Hi, everyone I have face one problem here, how can i divide the the chart into different tab?
Now i have 5 tabs with different product names,and each of the product has its own chart. VC << Variability chart( Y(:Name( "I_P3G_G_PSVT_0.6/0.06" ) ,:Name( "I_P3HG_G_PHVT_0.6/0.06" ),:Name("NEW_I_P3G_G_PSVT_0.6/0.06") , :Name("NEW_I_P3HG_G_PHVT_0.6/0.06"), :Name("Gross Yield") ), X( :Name( "Lot" ),...
blue1994

Discussions |
Apr 12, 2018 3:52 AM

15539 views | 8 replies
Including covariates in Jmp pro

Dear collegues–I would like to know the correct way to include covariates in a correlation analysis using JMP pro 14. Please see bellow is a spreadsheet contain two variables (var1 and var2) and one covariate. I aim to:1. Run correlation analysis between var1 and var2 within each group by including the regressor. I know how to fit x/y to run the correlation, nut I want to know how the correlation ...
Johnanderson

Discussions |
Apr 12, 2018 12:37 AM

2807 views | 1 replies
Pass and Fail Condition

Hi Guys, I have the following table and would like to know how shall I set the formula(or JSL) where in this case, based on ID and MAIN_RAD, I would like to check on the value of SUB_1 to SUB_3. The condition is if at least 2 of the SUB has a value of more than 20 then it will be considered as FAIL otherwise PASS. For instance as you will notice, for M101X at MAIN_RAD 1, the SUB_3 is more than 2...
adam

Discussions |
Apr 11, 2018 9:30 PM

4841 views | 2 replies

Previous
Next

Latest Discussions

Filter in query builder contains 102 different strings

In SAS 9.1 I a had a script querying a medication table with a list of over 100 different medications.If the list was especially long I would create a spreadsheet in Excel and import the list into the work space, write a script matching where a.description = b.description.Neither function appears in JMP. I cannot bring in an Excel file, cannot bring in another table, ONCE THE CONNECTION TO THE ORA...
MeatPopsicle

Discussions |
Apr 12, 2018 6:06 AM

4893 views | 5 replies
determination of sample size

Dear All, my sample population of each batch is 810.000 tablets for pharmaceutical product. I analyse 7200 sample for each batch. I want to reduce my sample size. Is there a statistical approach for this? I try to use Menu, DoE, Design Diagnostics, sample size and power, one sample mean part of jmpI do not change alpha value. my Std Dev is 0.3mg. My lower/upper spec is 1.3mg lower/higher than mea...
nac

Discussions |
Apr 12, 2018 5:40 AM

5262 views | 3 replies
Including covariates in Jmp pro

Dear collegues–I would like to know the correct way to include covariates in a correlation analysis using JMP pro 14. Please see bellow is a spreadsheet contain two variables (var1 and var2) and one covariate. I aim to:1. Run correlation analysis between var1 and var2 within each group by including the regressor. I know how to fit x/y to run the correlation, nut I want to know how the correlation ...
Johnanderson

Discussions |
Apr 12, 2018 12:37 AM

2807 views | 1 replies
custom expression Today() minus seven days in query builder

Attempting to obtain all releases by date (reldate) 7 days ago from ORACLE through ODBC Connection table.Code below returns the attached error image: SELECT DISTINCT t1.PIN, t1.PCP, t1.LASTNAME, t1.COMDATE,
t1.RELDATE, t1.JLOCAT, t1.SEX, t1.RELTYPE,
t1.RELAUTH, t1.RELCUST
FROM schema.table t1
WHERE ( ( ( t1.RELDATE >= (Today() - In Days( 7 )) ) 2nd question:Once I get this query straight, does ...
jumboshrimps

Discussions |
Apr 9, 2018 7:52 AM

6502 views | 1 replies
Reference line from axis to specific value

hi,i am new user to JMP and I was using Graph Builder for for developing a graph. However, I could not have specific value for x axis and y axis. Currently I have option to keep minimum Scale and maximum scale with a increment. eg.: Minimum: 0Maximum: 24Increment: 5Then axis will be 0, 5, 10, 15, 20 and 25.But I want like below:0, 1, 2, 3, 6, 9, 12, 18, 24. Can someone help? Thanks.
pprabhu

Discussions |
Apr 9, 2018 6:57 AM

3985 views | 4 replies

Previous
Next

Latest Discussions

P value, L-R Chi Square, Prob Chi Square in Choice results

Hello everybodyI am going to undrestand the P value, L-R Chi Square, Prob Chi Square in Choice results. But different interpretations of these values can be found in the web. It seems that the true interpretation is related to null hypothesis and confidence intervel.The results of the study are as the attached pictures.Could any body inform me what exactly these statistics are saying and base on w...
aryasohrabi

Discussions |
Mar 17, 2018 2:22 AM

3811 views | 0 replies
Convert separate DATE and TIME columns in formats YYYYMMDD and HHMMSS into a single column

Hello, I manage an addin for my company where all data is imported into JMP via command line utilities owned by our automation team. My addin translates a users request into a formatted command and issues the command in the background. The data is returned back as a text file on the users system. My addin can then load the data from the text file. The issue that I have is that the columns vary bas...
Picard

Discussions |
Mar 15, 2018 1:57 PM

2631 views | 0 replies
pseudo r square in JMP choice model platform

Hi,I am using JMP's choice model platform to analyse some Discrete Choice Experiment (DCE) data. I am trying to find the pseudo r square but the platform does not provide it. Is there a way to calculate pseudo r square based on the results JMP presents under the choice model platform? I know pseudo R square comes up as entropy RSquare under JMP's fit model platform, nominal logistic fir for respon...
DG

Discussions |
Mar 11, 2018 6:27 AM

2257 views | 0 replies
chnging colors on PCA plot

Hi,I seem to be able to change the color of the circle around the PCA plot but not the arrows which remain red no matter what I do. I changed the circle by Right Clicking on the plot --> Customize --> Circle and selecting the black color. I did the same using the option of Customize --> Arrow but nothing changes.Any advice would be appreciated.Thanks a lot.Helga
helga55

Discussions |
Mar 9, 2018 2:20 PM

3498 views | 0 replies
.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

2274 views | 0 replies