JMP User Community

Latest Discussions

How do I change all columns in a data table to continuous. I built the table from a csv file so all subsets are character

I need to change all the columns in a table to continuous. In a script
gene

Discussions |
Sep 10, 2015 12:20 PM

12098 views | 1 replies
Extend Select Where

Can we get this fixed in the Scripting Guide?//Scripting Guide page 336dt = Open( "$SAMPLE_DATA\Big Class.jmp" );dt << Select Where( age < 15 & sex == "F" );//ordt << Select Where( age == 14 );dt << Extend Select Where( sex == "F" ); //does nothing//Not in guide, but below workswait(10);dt << Select Where( sex == "F", Current Selection ("extend")); //extends selection
msharp

Discussions |
Sep 8, 2015 1:56 PM

4045 views | 1 replies
Mosaic plot - show percents

hi All,mosaic plots are very useful and i use it a lot.is there a way to get the labeling to show percents automatically (as a preference change)? is there a way to show the percents with zero decimal places?unfortunately I find myself writing this manually using annotations.
ron_horne

Discussions |
Sep 7, 2015 8:50 AM

7480 views | 3 replies
How do I merge/join multiple JMP data tables with the same variables within a script?

I know there is a way to this, but maybe someone may have an answer somewhere here. Is there way to join a multiple data tables with similar numeric and categorical data by fiscal year with a single script? Example is a script I am trying to use. Data Table( "confirmed_enrollment_FY2006" ) << Join( With( Data Table( "confirmed_enrollment_FY2007", "confirmed_enrollment_FY2008", "confirmed_e...
jenkins_macedo

Discussions |
Sep 7, 2015 8:25 AM

14063 views | 1 replies
Table Wide Find and Replace in a Script

I have a several large data tables (+100,000 records) that were created by a colleague in Europe.When the tables were created the EU numbering format was used, i.e. the "," is the decimal point.I need to do a table wide substitution to replace the "," with a "." in order for the table to work with existing scripts.I can get the column names with a get column names() statement, but I can not figure...
dhmeakin

Discussions |
Sep 6, 2015 10:34 AM

20100 views | 7 replies

Previous
Next

Latest Discussions

Extend Select Where

Can we get this fixed in the Scripting Guide?//Scripting Guide page 336dt = Open( "$SAMPLE_DATA\Big Class.jmp" );dt << Select Where( age < 15 & sex == "F" );//ordt << Select Where( age == 14 );dt << Extend Select Where( sex == "F" ); //does nothing//Not in guide, but below workswait(10);dt << Select Where( sex == "F", Current Selection ("extend")); //extends selection
msharp

Discussions |
Sep 8, 2015 1:56 PM

4045 views | 1 replies
Mosaic plot - show percents

hi All,mosaic plots are very useful and i use it a lot.is there a way to get the labeling to show percents automatically (as a preference change)? is there a way to show the percents with zero decimal places?unfortunately I find myself writing this manually using annotations.
ron_horne

Discussions |
Sep 7, 2015 8:50 AM

7480 views | 3 replies
Multiple Column Switchers

Is there a way from preventing the same column from being picked when running multiple column switchers? dt = open("$SAMPLE_DATA/Candy Bars.jmp"); biv = dt << Bivariate( Y( :Saturated fat g ), X( :Sugars g ), SendToReport( Dispatch( {}, "Bivar Plot", FrameBox, {Frame Size( 593, 564 )} ) ) ); cs1 = biv << Column Switcher( :Saturated...
msharp

Discussions |
Sep 1, 2015 11:01 AM

5956 views | 4 replies
Running JSL Script After Creation of a File

sophiaw

Discussions |
Sep 1, 2015 9:56 AM

2637 views | 0 replies
How do I make a prediction model based on my old experiment data?

I am new to JMP software ( version 11.2.0). I have a question on prediction model. Before having JMP, I ran 2 experiments shown below. ISOD is the response, and temperature & aging time are both continuous. Using these 2 tables, can I make a prediction model for ISOD yield in temperature range 100 to 180 & aging time 1 to 20 together? For an example, what will ISOD be at like 150 C with 15 days o...
sushiz

Discussions |
Aug 28, 2015 3:11 PM

7178 views | 6 replies

Previous
Next

Latest Discussions

Running JSL Script After Creation of a File

sophiaw

Discussions |
Sep 1, 2015 9:56 AM

2637 views | 0 replies
Clash?

saitcopuroglu

Discussions |
Aug 18, 2015 6:43 AM

2414 views | 0 replies
Incorporating Reference Lines into legend for multiple bivariate graphs.

Hello everyone!I would like assistance in order to incorporate reference lines at certain numbers of the Y axis, horizontal lines, directly into the legend.This is my current script
Bivariate(
Y( :Cat),
X( :Dog),
Histogram Borders( 1 ),

Where(:Recipe == "B_XX" & (:Tool == "A_XX")),
Elements( Points( X, Legend( 1 ) ) ),
SendToReport(Dispatch(
{},
"2",
ScaleBox,
{Add Ref Line( 140, Solid, "...
saswatmishra50

Discussions |
Jul 13, 2015 1:00 PM

3280 views | 0 replies
Fit Y by X plot discrepancy (Oneway vs Bivariate)

Hi, I see a discrepancy in the plotted Y variables when plotting similar columns in the Oneway vs Bivariate plots. Bivariate plots the Y values correctly (left side below). Oneway seems to jitter the points on the Y-axis, which seems strange to me. I realize that my horizontal axis here is a numeric, and that bivariate makes more sense* but I'm just looking for a simple x-y scatter and I like the ...
mikedriscoll

Discussions |
Jul 10, 2015 9:04 AM

4232 views | 0 replies
how to invisible local data filter

Hi all,Till now I was using "Panel Box" and "Close" local data filter command for the invisible but functioning local data filter. Something like below closes the data filter it is visible by jmp graph but invisible by the HTML5 output (magical).nw[Panel Box( 1 )][Outline Box( "Local Data Filter" )] << Close( 1 );nw[Panel Box( 2 )][Outline Box( "Local Data Filter" )] << Close( 1 );
This time I use ...
saitcopuroglu

Discussions |
Jun 9, 2015 7:00 AM

2948 views | 0 replies