JMP User Community

Latest Discussions

Query Builder with Excel file with Excel Filter

hi, i use a query builder to import an excel file. but if someone put a filter in the excel file, the query import less lines. how to make a query builder which import all the lines even the hideen lines in excel? best regards
Françoise

Discussions |
Feb 27, 2018 9:23 AM

6858 views | 5 replies
text box new line

Hi JMP expert, Is there a function in JSL to display text box in new line? Below script still want display the text in horizontal direction. Thanks nw = New Window("Reports", <<Journal,
hlb = H List Box(
    lub = Lineup Box(
      tb1 = Text Box( "Zone1:Cpk<1.33 && DSA>1.5" ) ,
      tb2 = Text Box( "Zone2:Cpk<1.33 && DSA<1.5" ) ,
      tb3 = Text Box( "Zone3:Cpk>1.33 && DSA>1.5" ) ,
      tb4 = ...
OneNorthJMP

Discussions |
Feb 27, 2018 7:47 AM

9536 views | 4 replies
How to set Axis Labels for Graph box in JMP application?

Hi all, I am using JMP application for plotting a test result. I am using the below script lines to set values to the graph, Results1 << Set Title ("WFM"); Result Graph << Set X Axis ({Min(0), Max(Res_x_max), Format("Best", 9)}); Result Graph << Set Y Axis ({Min(Res_y_max), Max(Res_y_min), Format("Best", 9)}); Result Graph << Set Graphics Script (Marker (Res_x,Res_y)); My problem is I want to ...
Saravana

Discussions |
Feb 26, 2018 2:02 PM

2101 views | 1 replies
copy column cell to different column

hi I'm trying to copy all row that is gender "male" from column "age" to column "gender"this syntax doesn't work.appreciate any help!age is a character column (Young, adult etc.)dt <<Select Where(:gender== "M"); :age << Get Value; :gender << paste;
AdamChoen

Discussions |
Feb 26, 2018 4:41 AM

5240 views | 2 replies
Comparing Names of column from two different data table

Hello,I am writing a script where user will select particular column name from one data table using panel box. Then selected column will be compared against column name from a different table and select the column when it matches. I am facing a problem related to {"x"}. When i am selecting column from panel box and storing in variable, it is getting stored as selected_cols= {"BIN"}. Now when i a...
RK1

Discussions |
Feb 23, 2018 4:52 PM

5030 views | 2 replies

Previous
Next

Latest Discussions

How to set Axis Labels for Graph box in JMP application?

Hi all, I am using JMP application for plotting a test result. I am using the below script lines to set values to the graph, Results1 << Set Title ("WFM"); Result Graph << Set X Axis ({Min(0), Max(Res_x_max), Format("Best", 9)}); Result Graph << Set Y Axis ({Min(Res_y_max), Max(Res_y_min), Format("Best", 9)}); Result Graph << Set Graphics Script (Marker (Res_x,Res_y)); My problem is I want to ...
Saravana

Discussions |
Feb 26, 2018 2:02 PM

2101 views | 1 replies
System.Reflection.TargetInvocationException

Hello, has anybody else encountered the error below before? If yes, how did you troubleshoot? I desperately need a quick resolution.JMP has experienced a problem and must now terminate:System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation.Additional information about the problem will be written to "C:\Users\Z656540\Documents\JMPManagedExcept 2015-0...
ellen_cain

Discussions |
Feb 23, 2018 8:05 AM

6400 views | 3 replies
HELP!? How to add sample size and % above USL and below LSL in graph builder?

I have plotted 2 data sets in graph builder that looks like this: The USL and LSL were automatically placed via the spec limits I set in the column properties and adding refrences lines to graph. I then additionally added a Marginal USL (MUSL) manually in graph builder. To this graph, I would like to add a label or note with the count/sample size for each data set as well as the % of points ab...
jofu

Discussions |
Feb 21, 2018 10:23 AM

4879 views | 4 replies
Add a new value to rows of an existing column

Hi, I am new to JSL . I am trying to write a code do achieve the following. I have 4 different JMP table. I am comparing each row of column 1 of Table 1 with column 1 of the remaining three table. If any entry/row of Coulmn 1 /table 1 matches with column 1 of Table 2 , It assigns Character say- Group1 to the row in table 1/ Column 4. Similarly if any row of column 1/tale1 matches with column1 of ...
joydeepb83

Discussions |
Feb 20, 2018 9:01 PM

4510 views | 2 replies
Prediction formula null values

Hello, After saving my prediction formula from GenReg, I'm seeing about 80 percent of my dataset has null values (.) in the predicted values column. I suspect it has something to do with several "levels removed" in some of my significant predictors. Any advice on how to handle this or how to pivot from this in order to arrive at a higher yield (of predicted values) would be appreciated. Thank you...
samalar

Discussions |
Feb 20, 2018 6:15 AM

5255 views | 4 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

2077 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

3481 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

2390 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

2496 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

3130 views | 0 replies