Index
Using JMP
Symbols
^. See insert button on keypad
! (Not) function 468
!= (not equal to) function 464
.emf 359
.eps 359
.gif 359
.pdf 359
*= (Multiply To) function 496
/= (Divide To) function 496
& (And) function 467
& (And) function and conditional clauses 468
+= (Add to) function 496
< (less than) function 464
<= (less than or equal to) function 464
= (Assign) function 495
== (equal to) function 464
> (greater than) function 464
>= (greater than or equal to) function 464
| (Or) function 467
Numerics
1, 2, and 4-byte integers 171
A
A tool. See annotate tool
Abbrev Date function 489
Abs function 449
Add All Windows 373
Add Database Query 373
Add Document 372
Add files opened by scripts to the Recent Files list 405
Add Filter Columns 282
Add Folder 373
add ranges, missing values 180
Add SAS Stored Process 373
Add to (+=) function 496
Add URL 373
Add Window 372
adding
columns 119
graphics and graphics scripts 341
maps and boundaries 331
rows 119
statistics columns 273
add-ins
managing 397–398
opening as text 73
Aggregate 284
Aggregate functions (SQL) 110
allowing short numeric formats 171, 413
analysis roles 194
Analyze
toolbar 382
And (&) function 467
And (&) function and conditional clauses 468
annotate tool 335
annotations
creating 335
setting the default font 428
apostrophes in imported data 72
appending tables. See concatenating tables
Application
toolbar 383
ArcCosH function 453
ArcCosine function 452
archive files in project 372
ArcSine function 452
ArcSinH function 453
ArcTangent function 452
ArcTanH function 453
arguments
definition 264
opening and closing 257
arithmetic buttons on keypad 245
arrange
windows 51
Arrhenius function 451
Arrhenius Inv function 451
arrow
cursor tool 48
double arrow tool 48
As Row State function 491–492
Assign (=) function 495
Assignment functions 495–496
assignment table property 309
asterisk icon 43, 178
attaching tables. See concatenating tables
Auto-complete parentheses and braces, in script editor 432
Auto-hide menu and toolbars 424
automatic recalc option 295
Automatically generate ODS results 435
Auto-save the report to 406
Average 285
axis
adjusting 290, 322
copying and pasting settings 327
customizing 322
divider lines and frames 330
gridlines 328
increments 324
labels 325
minimum and maximum values 322
numeric format 325
scale 323
scrolling 321
specifications for columns 181
tick marks 328
B
background colors 320
backwards compatibility 403
bars, histogram colors 320
base e 449
Bernoulli trials 485
best numeric formats 172
Beta Binomial Distribution function 478
Beta Binomial Probability function 478
Beta Binomial Quantile function 478
Beta Density function 469
Beta Distribution function 469
Beta function 450
Beta functions 450
Beta Quantile function 469
BETWEEN statement (SQL) 109
Big Class.jmp 257
Binomial Distribution function 478
Binomial Probability function 478
Binomial Quantile function 478
Blink button in row editor 143
Blob to Char function 459
boxes around formulas 256
braces in script editor, auto-complete 432
Break function 469
brush tool 310
building formulas 239
buttons
copying 389
creating 385
show and hide 393
C
Cartesian join. See joining
Categorical Color Theme 409
Cauchy distribution 484
Ceiling function 449
cell formulas 121
Char function 453
Char to Blob function 459
Char to Hex function 457
character data types 170
Character functions 453–459
Character Pattern functions 459–462
character sets
save text as Unicode preference 403
select during text import 71
characteristics, rows and columns 156
ChiSquare Density function 469
ChiSquare Distribution function 470
ChiSquare Quantile function 470
Choose function 466
circle with strikethrough icon 157
clauses 264
cleaning data 134
closing
JMP Starter window 37
levels in a report 290
closing JMP Starter window 29
coding, column property 184
Coefficient of Variation 276
Col functions 480, 487
Col Maximum function 480
Col Mean function 480
Col Minimum function 480
Col N Missing function 480
Col Number function 480
Col Quantile function 480
Col Rank function 481
Col Shuffle function 487
Col Standardize function 481
Col Std Dev function 480
Col Sum function 480
Collapse Whitespace function 453
Color function 491
Color Of function 495
Color Presets 410
Color selection, in script editor 433
Color State function 491, 493
Color Theme 182
Color unknown object messages, in script editor 432
colors
background in graph 320
backgrounds 320
by row state 159
histogram bars 320
markers 312
rows and columns 159
shapes added to reports 336–338
column switcher 294
columns
adding 119
adjusting widths 39
axis specifications 181
characteristics 156
compress 195
control limits 185
deleting 119
design roles 186
duplicating 141
excluding 156
excluding and hiding 156
fonts used in headings 427
formulas 178, 239
hiding 157
joining 220
labeling 158
locking 166, 169
measuring units 186
moving 141
names 39, 133
notes 179
order of data in reports 185
panel 42–43
preselected analysis roles 194
properties 178, 191
reordering 139
response limits 185
row state 175–176
Sigma values 186
sorting 139
source column 218
spec limits 185
splitting 210
stacking 205
transposing 214
validating data 179–180
value labels 180
Columns Viewer 126
columnwise statistics functions 479
Combine 284
combine reports 292
Combine States function 491–492
communications settings 114, 429
Compare column 132
Comparison functions 462–464
compress columns 195
Compress file when saved option 41
Compress Selected Columns 42
compressing
data tables 41
Concat function 453
Concat Items function 458
concatenating tables 217
Conditional functions 464–469
Connections, database. See database connection
Contains function 453
Continue function 469
Continuous Color Theme 409
continuous modeling types 170
Continuous Scale command 317
control limits 185
Convert SAS custom formats 436
Copy As SAS Formula 255
Copy Formula button, using when
creating a subset 201
joining tables 201, 207, 211, 222
copy menu and toolbar items 389
Copy/Drag Graphic Formats 423
copying
axis frame settings 327
graph contents 327
row states 176
text 361
copying toolbars 382
CosH function 452
Cosine function 452
Count 286
Count (in a formula) 448
Count column 137
Count function 447
creating
menu items and buttons 385
menus 384
source columns (when concatenating tables) 218
creating data tables 114
crosshairs tool 320
Cube 285
Cumulative Sum 287
currency formats
columns 173
cursor forms 48
customization sets
changing 380
importing 394
customizing
axes 322
graph elements 339
menus and toolbars (Windows) 379
results 357
See also preferences
toolbars (Macintosh) 395
toolbars and menus (Windows) 379
D
data
grid 39
missing 135
recoding 134
data feed. See communications settings
Data Filter 298
data filter
conditional 303
Data Filter Auto Clear 414
Data Filter Check Box Display 414
Data Filter Include Check 414
Data Filter Select Check 414
Data Filter Show Check 414
data table
compressing 41
extended file format 41
Data Table Background Color 415
Data Table Clear Selection 166
Data Table Grid Color 415
Data Table Header Grid Color 415
data tables
compare 152–155
compressing 146
concatenating 217
creating 114
data grid 39–49
editing 133
elements of data tables 39
joining 220
locking 41, 146
names and notes, placing on reports 406
names, changing 145
opening 49
panels 40
preferences 412
properties 41, 309
saving 347
sorting 202
splitting 210
stacking 205
subsetting 199
summarizing 269
transposing 214
updating 231
Data Tables List toolbar 382
data types
character formats 170
date and time formats 172
numeric formats 172
row states 170, 176
specifying 170
data view
created from rows panel 44
database connection 103–107, 352
datafeed. See communications settings
Date 286
Date Difference function 490
Date DMY function 488
Date Increment function 490
Date MDY function 488
Date Time functions 487–490
dates and times
formats 172–173
inserting on report window 406
Day function 488
Day of Week function 488
Day of Year function 488
decreasing font sizes 292
Default Field Width 414
defaults
JMP window 402
defaults. See factory defaults
delete button, on formula editor keypad 246
delete expression 246
deleting
columns 119
functions 255
menus 392
rows 119
toolbars 392
derivatives 251
descriptive statistics. See statistics columns
deselecting parts of a report 291
Design of Experiments. See DOE 184
design roles 186, 195
Design, table variable 147
Desirability function 483
desirability values, as column properties 186
diamond icon, on a report 291
Dif function 448
Difference 285, 287
Difference (reverse order) 285
Digamma function 451
disclosure icon. See diamond icon
discontiguous selection 122, 126
Discrete Probability functions 477–479
Display Language 423
distribution
column property 186
setting column property to automatically fit curve 186
Divide To (/=) function 496
Dock the Window List 424
DOE (Design of Experiments)
coding 184
toolbar 382
Double Declining Balance function 496
downsaving 403
DPI, report graphics 357
dragging and dropping
in data table 141
into formulas 255
into other programs 361
drawing speed of markers 312
drawing tools 336–338
dropping
columns when splitting tables 211
columns when stacking tables 206
duplicates when joining tables 223
Dunnett P Value function 470
Dunnett Quantile function 470
duplicating cells and columns 141
E
Edit Notes 374
editing
column names 133
formulas 254
names of data tables 145
names of report tables 309
reports 290
table variables 148
tables 133
WHERE clauses 111
efficient evaluations 250
elements and element browser in formula 264
eliminating missing rows (when stacking tables) 206
EMS 354
Encapsulated PostScript File 354
End of Field and End of Line options 71
Ends With function 456
end-to-end merging. See concatenating tables
Enhanced Metafile 354
EPS support in reports 354
equal to (==) function 464
equation editor. See formula editor
errors, ignoring in formulas 253
evaluating columns’ formulas
viewing evaluations in formulas 253
when creating subsets 201
when joining tables 222
when splitting columns 211
when stacking columns 207
examples, formulas 257
Excel
versions 2007+ 62
Excel files
opening 62
Excel Import Wizard 62
Excel versions 61
Excel, selecting worksheets when opening 403
Excluded function 493–494
Excluded functions 491
excluded rows, showing in a data view 44
excluding
columns when splitting tables 211
columns when stacking tables 206
duplicates when joining tables 223
rows and columns from analyses 156
Exp function 449
exponent button on keypad 246
exporting
column names to text files 348
data tables 347
reports 353
extended attribute support 436
Extra space at bottom of document, in script editor 432
extracting data from image 334
F
F Density function 470
F Distribution function 470
F Power function 476
F Quantile function 471
F Sample Size function 476
factor
for mixture experiments 184
Factorial function 450
factory defaults
min and max axis values 322
fast marker
drawing speed 312
threshold 409
fat plus tool 48
Fibonacci series 448
field widths
of tick mark labels 329
File_Edit toolbar 382
files
opening 403
saving without Unicode 403
filling columns with data 177
filtering columns 282
filtering data 298
Finance Functions 496
Find/Length expression 454
finding and replacing values 137
fit
column property to draw automatically when analyzing distribution of column 186
Floor function 449
fonts
changing in data tables 39
changing size in data tables 292
For function 468
For quantile statistics option when summarizing tables 272
Format 436
Format function 489
Formula 284
formula editor 239–262
formula element browser 244
formulas
arguments, opening and closing 257
boxes, hiding and showing 256
cell expressions 121
constants, adding 243
creating 178
types of formulas 239
data table elements, adding 240
editing 254
entering into cells 121
evaluating 249, 252, 414
examples 257
expressions 254
fonts 256, 428
functions, adding 246, 447
glossary of terms 263
JSL view 253
keyboard shortcuts 263
opening and closing arguments 257
operators, adding 244
orientation in formula editor 257
shortcuts, keyboard 263
tutorials 257
viewing 253, 256
Frame Border 411
Frame Color 410
frame sizes of plots or graphs 319
Freq (Frequency). See preselected role
Full Quadratic Model function 496
function browser 246
function types
Add to (+=) 496
And 468
Assign (=) 495
Assignment 495
Beta 450
Character 453
Character Pattern 459
Col 480, 487
Color 491
Color State 491
Combine States 491
Comparison 462
Conditional 464
Date Time 487
Discrete Probability 477
Divide To 496
Excluded 491
Hidden 491
Hidden State 491
Hue State 491
Is Missing 463
Marker 491
Match 261
Multiply To (*=) 496
Numeric 449
Parametric Model 496
Post Decrement (--) and Increment (++) 496
Probability 469
Random 483
Row 447
Row State 490
Shade State 491
Statistical 479
Transcendental 449
trigonometric 452–453
functions
adding 246
aggregate (SQL) 110
columnwise statistics 479
deleting 255
glossary of terms 264
peeling 255
Row States 491
Future Value function 496
G
Gamma Density function 471
Gamma Distribution function 471
Gamma function 450
Gamma Poisson Distribution function 477
Gamma Poisson Probability function 477
Gamma Poisson Quantile function 477
Gamma Quantile function 472
general preferences 399
Generate ODS statistical graphics 435
GIF 354
global variables, storing a report table 309
GLog Density function 474
GLog Distribution function 474
GLog Quantile function 474
glossary of formula terms 263
Go To command 125
Go To Row command 122
grabber tool. See hand (grabber) tool
Graph
toolbar 382
Graph Background Color 410
Graph Border 408
Graph Builder preferences 417
Graph Format 436
Graph Height 408
graph marker theme, default 409
graph preferences 408
graphics
adding to buttons 387
adding to reports 339
saving reports as graphics 359
scripts 341
Graphics Format 435
Graphics Formats 424
graphics, dragging into graph 332
graphs
copying and pasting contents 327
customizing elements 339
greater than (>) function 464
greater than or equal to (>=) function 464
grid. See data grid
gridlines 328
GROUP BY command (SQL) 110
grouping variables
using when sorting tables 204
using when splitting tables 210
H
hand (grabber) tool
using in formula editor 254
using in reports 290
using to scroll axes 321
HAVING command (SQL) 110
Hex function 457
Hex to Blob function 459
Hex to Char function 457
Hex to Number function 457
Hidden function 493–494
Hidden functions 491
hidden rows
showing in a data view 44
Hidden State function 491
Hide Overlapping Labels 408
hiding
columns 157
menu tips 403
results 291
rows 157
thumbnails of reports 424
toolbars 379
hierarchical data filter 303
Highlight Outline Headers option 424
histograms, bar colors 320
Home
toolbar 383
Home Window 33
horizontal
alignment in reports 290
formula display 257
Hot Dogs.jmp 261
Hour function 488
Hover Help 406
HTML
importing 75
HTML 5, save output as 355
Hue State function 491, 493
Hypergeometric Distribution function 479
Hypergeometric Probability function 479
I
I want to connect to a SAS Environment 435
I want to connect to a SAS Metadata Server 435
I will manually connect to SAS workspace servers 435
I-beam cursors 48
icons
asterisk 43, 178
circle with strikethrough 157
column characteristics 43
column properties 43
compress 146
diamond (disclosure) 291
list check 43
lock 43, 146
mask 43, 157
modeling types 43
plus 43, 179
preselected roles 195
range check 43
red triangle 293
yellow tag 43, 158
ID column. See Source Label Column
If function 465
IfMax function 467
IfMin function 467
ignoring
errors 253
missing values (when updating tables) 232
images
dragging into graph 332
extracting data 334
Import generated SAS data sets into JMP 435
importance values, entering 186
importing
data 61–77
Excel files 62
HTML 75
ODBC 352
SAS files 79–81
text files 67
text from the Script window 75
toolbar and menu customizations 394
using a database 103
using SQL statements 106
In Days function 488
In Hours function 488
In Minutes function 488
IN statement (SQL) 109
In Weeks function 488
In Years function 488
Include marginal statistics option 271
Include Non Matches option 223
Include Responses Not in Data 414
increasing font sizes 292
indent guides, showing in script editor 432
Informat function 489
initial
data values 177
input formats 172
insert button on keypad 245
Insert function 457
Insert Into function 457
insertion points 48
instruments, connecting 114, 429
Interactions Model function 496
interactive HTML, save output as 355
Interest Payment function 496
Interest Rate function 496
internal name 383, 386
Internal Rate of Return function 497
international numeric formats 175
Internet
file formats 354
opening Internet files 75
Interpolate function 468
Interquartile Range (summary statistics) 276
Is Missing function 463–464
Item function 456
J
JMP Projects 370–374
JMP Starter 29
hiding on startup 402
JMP tutorials 29
JMP.PFS 401
Johnson Sb Density function 476
Johnson Sb Distribution function 476
Johnson Sb Quantile function 476
Johnson Sl Density function 476
Johnson Sl Distribution function 476
Johnson Sl Quantile function 476
Johnson Su Density function 476
Johnson Su Distribution function 475
Johnson Su Quantile function 476
joining
by matching columns 223, 228
by row number 223
tables, methods 220
using Cartesian join 223, 226
Joint Photographics Expert Group (JPEG, JPG) 354, 359
journals
creating 362
JPEG, JPG 354, 359
JSL code folding 433
JSL scripts
adding 148
copying 151
creating from a report 357
deleting 42, 151
editing 42, 151
fonts 428
formula editor 253
graphics scripts 341
new 41
running 42, 151
saving in data tables 41
suppressing automatic execution 412
viewing in formula editor 253
JSL Scripts should be run only 424
K
Keep All option 211
keypad, formula editor 112
L
Label column name 208
Labeled and Labeled State functions 491
Labeled function 494
Labeled State function 493
labelled rows
showing in a data view 44
labels
axis 325
field widths 329
icon 158, 316
markers 315
rows and columns 158
tick marks 328–330
value labels 180
Lag function 448
language preference, JMP indexes 404
large plus cursor 48
laser pointer 407
lasso tool 311
Left function 456
legends 317
add 316
remove 317
Length function 454
LEV Density function 472
LEV Distribution function 472
LEV Quantile function 472
LGamma function 451
library. See SAS transport files
LIKE statement (SQL) 109
limits, specification, control, response 185
line numbers, in script editor 432
line tool 336
Line Width 408
linear axis scale 323
Linear Model function 496
lines
width 320
lines, dotted or dashed reference lines 330
linked data table 200, 309
list checking
cursor 49
sorting data 202
Little.jmp 229
loading, SQL queries 111
Local Data Filter 294
local variables
button on keypad 246
using in formula 241, 259
localizing toolbar and button captions 384
Location 436
locking
columns, preventing from being moved 166
data tables 41, 146
log
opening by default 424
saving 375
saving a report to 406
showing DisplayBox messages 404
Log function 449
Log window, saving reports to 406
Log, axis scale type 323
Log10 function 449
logarithm, natural 449
Logist function 450
Logistic Density function 472
Logistic Distribution function 472
Logistic function 450
Logistic Quantile function 472
Logit function 451
Loglogistic Density function 472
Loglogistic Distribution function 472
Loglogistic Quantile function 472
Lognormal Density function 473
Lognormal Distribution function 473
Lognormal Quantile function 473
Long Date function 489
lower control limits (LCL) and spec limits 185
Lowercase function 454
M
magnifying glass tool 319
Major Grid Line Color 410
Major Grid Lines 411
Make into Matrix command 309
Make Window with Legend command 317
Manage Rules, in reports 407
manipulating plots/graphs 319
marginal statistics 271
Marker functions 491
Marker Of function 495
Marker Selection Color 409
Marker Selection Fade 409
marker selection mode 409
Marker State function 493
markers
adding 159
changing shape 316
changing sizes 312
colors 312
default shape 409
default size 409
drawing speed 312
drawing speed/marker 312
excluding 315
excluding and hiding 315
hiding 315
highlighting 313
highlighting in plots 309
labeling 315
labels 315
legends 316
outlines 313
point values 317
shapes 159, 312
speed 312, 409
threshold 409
transparency 314
mask icon 157
Match Flag column 222
Match function 261, 465
matching
cases while searching 138
columns when joining tables 228
targets 186
whole words in search 138
matching columns (update) 233
matching specifications 221, 224
matrix 309
Max (summary statistics) 275
Maximum function 483
MDYHMS function 489
Mean (summary statistics) 275
Mean function 481
measuring units, columns 186
Median 286
Median (summary statistics) 276
members, importing 81
menu items
creating 385
menu preferences 440
menu tips 30, 403
menus
copying 389
creating 384
deleting 392
rearranging 391
merge old menus 395
merge vertically. See concatenating
merging same name columns 222
Mersenne-Twister technique 483
Microsoft Excel, preview data 62
Microsoft Word and PowerPoint 361
Min (summary statistics) 275
minimum and maximum axis values 322
Minimum function 483
Minor Grid Line Color 410
Minor Grid Lines 411
Minute function 488
missing
terms, in formulas 265
value comparison 463
values, in formulas 265
values, updating tables 232
missing data patterns 135
missing value code, SPSS 77
missing values 180
add ranges 180
mode, marker drawing 312
modeling types
continuous 170
icons 43
nominal 170
ordinal 170
specifying 170
Modified Internal Rate of Return function 497
Modulo function 449
Month function 488
Month Year 286
moving
cells and columns 141
rows 141
selection in data table 414
Multiple Series Stack 206
Multiply To (*=) function 496
Munger function 454
example 260
N
N and N Missing (summary statistics) 275
N Categories (summary statistics) 275
N Missing function 483
naming
data tables 145
report tables 309
reports 292
natural logarithm 449
NChooseK function 450
NChooseK Matrix function 450
Neg Binomial Distribution function 478
Neg Binomial Probability function 478
Negation 285
nested variables 273
nesting boxes, formula editor 258
Net Present Value function 497
new
columns 119
rows 119
New Group 372, 374
no-intercept model 184
nominal
modeling types 170
Non matches, include when joining tables 223
noncentrality 470–471, 474–475
Normal Biv Distribution function 473
Normal Density function 473
Normal Distribution function 473
Normal Quantile function 473
Not (!) function 468
not equal to (!=) function 464
notes
as table variables 147
displaying in report windows 406
saving in a column 179
NRow function 448
Num function 455
Number function 482
Number of Periods function 497
Number of Series option 206
numeric
allowing short numeric 413
formats 172–175
in axes 325
short 171
international formats 175
Numeric functions 449
O
ODBC 103, 352
ODBC drivers for importing data 62
ODBC Hide Connection String 415
ODS Result Format 435
ODS results 97
ODS Style 435
ODS Style sheet 435
Offset expression 454
OnOpen 150
Open All Below command 290
Open All Like This command 290
Open Database Connectivity 352
Open Text File Charset, in general 403
open windows 35
opening
add-ins as text 73
data in text editors 73
databases 103
Excel files 62
Excel worksheets 403
Internet files 76
JMP files 49
JMP Starter window 29, 37
journals 49
SAS data sets 79
SAS files 79
SAS stored process report as data table 77
scripts 49
SPSS files 77
text files 67
operator names
script editor, adding spaces between words 433
operator tips, showing in script editor 432
operators
adding 244
in assignment functions 495
Or (|) function 467
ORACLE synonyms 105
order of operations 249
ordering
columns 139
row order levels 185
values 181
ordinal modeling types 170
orientation of formulas 257
Original 410
outlines
adding to markers 313
structure of reports 291
Output Table option
joining tables 221
sorting tables 203
oval tool (simple shape tool) 336, 338
P
page
breaks, inserting 291, 361
panels. See data table panels
Parametric Model Functions 496
parentheses
script editor, adding spaces inside 432
script editor, auto-complete 432
password protected data sets 95
Paste Special command 361
Pat Abort function 461
Pat Altern function 462
Pat Any function 459
Pat Arb function 461
Pat Arb No function 461
Pat At function 461
Pat Break function 460
Pat Concat function 462
Pat Conditional function 461
Pat Fail function 461
Pat Fence function 461
Pat Immediate function 462
Pat Len function 460
Pat Match function 462
Pat Not Any function 460
Pat Pos function 460
Pat R Pos function 460
Pat R Tab function 460
Pat Regex function 462
Pat Rem function 461
Pat Repeat function 461
Pat Span function 460
Pat String function 460
Pat Succeed function 461
Pat Tab function 460
Pat Test function 460
patterns of missing data 135
Payment function 497
PDF 354
PDF file, headers and footers 366
peel (delete expression) 246
peel function 255
percent of total (summary statistics) 275
Personalization window 38
Pin File 34
platform preferences 416
platforms
common features 281
launch windows 281
plots and graphs
adding graphics 339
annotations, adding 335
appearances, altering 318
markers, changing 311
resizing 318
shapes, adding 336
statistics, adding 271
PNG 354, 359
points. See markers
Poisson Distribution function 479
Poisson Probability function 479
Poisson Quantile function 479
polygon (spline) tool 337–338
Post Decrement (--) and Increment (++) functions 496
Pow10 285
power. See Sample Size and Power
PowerPoint 361
precedence 249
preferences 399
Graph Builder 417
preferences, reset 401
preselected analysis roles 194
Present Value function 497
presentations, journal 367
Preserve SAS formats 350
Preserve SAS formats when exporting to SAS 413
Preserve SAS variable names 350
Preserve SAS variable names when exporting to SAS 413
Preview Graph 411
preview pane 52
previewing text on import 69
Principal Payment function 497
Print Data Grid as is 413
printing
page breaks 361
Probability functions 469–477
Probit function 473
Product function 482
projects
automatically open files 373
dragging and dropping files into 373
fix broken link 374
Prompt if data set has more than 435
Prompt if results are larger than 435
properties
creating with JSL 191
table properties 309
Q
Quantile function 482
quantile statistics 272
Quarter function 488
queries, SQL 111
quotation marks in imported data 72
R
Random Beta Binomial function 485
Random Beta function 484
Random Binomial function 485
Random Cauchy function 484
random data, adding 177–178
Random Exp function 484
Random Frechet function 486
Random functions 483–487
Random Gamma function 484
Random Gamma Poisson function 486
Random Geometric function 486
Random GLog function 486
Random Integer function 485
Random Johnson Sb function 485
Random Johnson Sl function 485
Random Johnson Su function 485
Random LEV 487
Random Logistic function 486
Random Loglogistic function 486
Random Lognormal function 486
Random Negative Binomial function 485
Random Normal function 484
Random Poisson function 486
Random Reset function 486
random sample (subset) 200
Random Triangular function 485
Random Uniform function 484
Random Weibull function 486
range checking 49
range comparison function 464
ranges, summary statistics 275
Ratio 285
Ratio (reverse order) 285
read-only data 146
rearrange open windows 35
rearranging
cells and columns 141
results 357
rearranging toolbars 388
recent files 34
Reciprocal 285
recoding data 134
rectangle tool (simple shape tool) 336
red triangle icon 293
reference lines, adding 330
Regex function 458
Regex Match function 462
Remove From function 457
Remove function 457
renaming
data tables 145
report tables 309
reports 292
reordering
columns 139
Repeat function 457
Replace argument 454
replacing
tables (when sorting) 204
values in a data table 137
Report Invalid Display Box Messages 404
report preferences 405
report windows
customizing 357
dates and times, adding 406
disclosure button 291
formatting 290
options 293
order of data 181, 185
rearranging results 357
red triangle icon 293
renaming 292
saving 353
tables 308
Resample Freq function 487
Reset file associations 425
reset preferences 401
resizing plots/graphs 319
response limits 185
responses, multiple 186
restricting search to selected rows or columns 138
results. See report windows
Reverse function 458
Reverse Into function 458
reverting columns to original order 140
Right function 456
roles
design roles 186
preselected analysis roles 194
root button on keypad 246
Root function 450
Round function 449
Row 284
row
editor 142
selection 123
Row function 447–448
Row functions 447–448
row selection, direction of movement when pressing Enter/Return 414
row state
columns 170, 175–176
data types 170, 176
Row State function 491
Row State functions 490–492
row states
clear 166
coloring rows by column values 159
rows
adding 119
characteristics 156
coloring 159
deleting 119
excluding 156
hiding 157
joining 220
labeling 158, 316
legends 316
markers 159
menu items 48
moving 141
order of data in reports 185
sorting in data tables 202
subsetting 199
summarizing 269
transposing 214
rows panel 44
creating a data view of selected rows 44
RTF (Rich Text Format) files 355
running scripts 42
S
sampling a database 103
Sampling in databases 105
SAS
creating transport files 81
files 81
importing password-protected data sets 95
opening data sets 79
saving in SAS format 349–351
toolbar 382
transport files 349
variable names 79
variable names in imported data 79
SAS 9.3 preferences 434
SAS 9.4
store extended attributes 350
SAS metadata server
supported version 82
SAS metadata server, automatically connect 435
SAS Server Version 434
SAS server version 86
SAS variable labels, importing 436
SAS, submit code 96
Save and restore document state information, in script editor 432
Save and Save As menu items 347
Save Data Table Columns GZ Compressed preference 42
Save Data Table Columns GZ Compressed, in general 404
Save Journals GZ Compressed,in general 404
Save Session Script 369
Save table in extended file format 413
Save table in extended file format preference 41
Save the session when exiting, in general 405
saving
column property 184
data tables 347
log windows 375
reports 353
reports as graphics 359
results to a database 352
scripts 357
scripts in English 404
spec, control, and response limits 185
SQL queries 111
Unicode 403
saving and evaluating formulas (when concatenating tables) 218
Scalable Vector Graphic format 359
scaling
axes 321
Scheffe Cubic function 452
Script All By-Groups menu 294
script editor
auto-complete parentheses and braces 432
extra space at bottom of document 432
indent guides, showing 432
line numbers, showing 432
operator tips, showing 432
spaces in operator names 433
spaces inside parentheses 432
tab width 432
use tabs 432
variable value tips, showing 432
Script menu 293–295
scripts
graphics 341
running when a data table is opened 150
saving in English 404
See JSL scripts
scroll lock/unlock 166
scrolling
axes 321
Search/Find 137
using the row editor 143
Second function 488
Select Dominant 123
Select Individual Excel Worksheets command 403
Select Randomly 123
SELECT statement (SQL) 107
Selected function 491, 494
selected rows
showing in a data view 44
Selected State function 491, 493
selecting
cells 122, 126, 131
columns 125
when joining tables 223
irregular area of points 311
parts of a report 291
points in plots 309
rectangular area of points 310
rows and columns in data tables 48–124
rows and columns in plots 310
selection (large plus) cursor 48
Semiconductor Capability.jmp 128–129
sequence data, adding 177
Sequence function 447
sessions, saving 368
setting
markers according to point values 317
SEV Density function 474
SEV Distribution function 474
SEV Quantile function 474
Shade Alternate Table Rows 411
Shade State function 491, 493
Shade Table Cells 411
Shade Table Headings 411
shapes. See drawing tools
Shift function 458
Shift Into function 458
Short Date function 489
short, allowing short numeric 171, 413
shortcuts, keyboard 263
short-integer format 413
Show Alternate Column Name 413
Show conditional formatting, in reports 407
Show embedded log on script window open, in script editor 432
Show indent guides, in script editor 432
Show line numbers, in script editor 432
Show on the Windows task bar 424
Show operator tips, in script editor 432
Show SAS Log 436
Show the thumbnail panel 424
show toolbar 389
Show Tree Structure 291
Show variable value tips, in script editor 432
showing
boxes around formulas 258
results 291
Sigma, assigning values 186
simple shape tool (oval or rectangle) 336
simplify formulas 252
Sine function 452
SinH function 452
sizing/scaling 319, 321
slope computation 259
Sorting
results by fields in a database (SQL) 108
sorting
data tables 202
list check 202
order 204
value labels 202
value ordering 202
source columns 218
Source Flag column 222
Source Label Column 207–208
Spaces in operator names, in script editor 433
Spaces inside parentheses, in script editor 432
spec limits 185
specifying columns when importing text files 72
speed, marker 312, 409
splash window 402
Split By column 212
Split Label Col 210
splitting columns 210
SPSS files, opening 77
SQL statements 106–107
SQL WHERE clause editor 111
Square 285
Squish function 450
stacking columns 205
Standard Deviation 275
Standard Deviation function 482
Standard Error 276
Starter Window 37
Starts With function 456
startup windows 402
Statistical functions 479–483
Statistics button 270, 274
statistics column 270, 273–274
Std Dev and Std Err (summary statistics) 275
Std Dev function 482
Step function 468
Stop function 469
Store extended attributes 350
Stored Process Results 436
stored process, copy metadata path 96
Straight Line Depreciation function 497
stripping enclosing quotes on imported data 72
subgroups, summary statistics 273
submit SAS code 96
Subqueries (SQL) 111
Subscript function 448
subsetting
from a data table 199
from a histogram 201
Substitute function 458
Substitute Into function 458
Substr function 455
Subtract To (-=) function 496
Sum function 482
Sum Of Years Digits Depreciation function 497
Sum Wgt (summary statistics) 275
summary table, creating 269
Summation function 482
supported version of SAS metadata server 82
suppressing formula evaluation
in data tables 41
on open 414
when creating a subset 201
when creating formulas 252
when joining tables 222
when splitting columns 211
when stacking columns 207
SVG 355
switch terms button on keypad 246
synonyms (ORACLE) 105
system tables (ORACLE) 105
T
t Density function 474
t Distribution function 474
t Quantile function 475
Tab width, in script editor 432
Table Column Borders 411
table properties
compare 155
Table Row Borders 411
table variables
adding 147–220
creating 41, 148
editing 148
in formulas 147, 240
notes 147
tables
concatenating 217
panel 40, 42
report tables 308–309, 427
toolbar 382
tabs
script editor 432
Tangent function 452
TanH function 452
target value 185–186
terms, formula 264
terms, switching in a formula 246
text
editing 73
importing 68
mode for formulas 253
opening add-ins as text 73
opening text files 67
saving as text 348
threshold of markers 409
tick marks 328
TIck marks inside graph frame 411
Time of Day function 488
time, adding to reports 406
Tip of the Day window
hiding and showing 402–403
title bar fonts 428
Titlecase function 455
Today function 488
toolbars
adding buttons 382
Analyze toolbar 382
copy 382
copying 389
create 382
deleting 392
File_Edit toolbar 382
hidden 389
personalizing (Macintosh) 395–397
rearranging 388
show and hide 393
showing by default 424
Tools toolbar 382
types of 382
toolbars and menus
personalizing (Windows) 379–395
tools, cursor 48, 335
tooltips 30
Transcendental functions 449–452
Transform 284
transform columns 285
transparency, markers 314
transport files, creating 81
transposing rows and columns 214
treat empty columns as numeric 421
Trial1.jmp 224–225
Trial2.jmp 224–225
triangle icon 293
Trigamma function 451
trigonometric function types 452
Trim function 455
truth tables 468
Tukey HSD P Quantile function 476
Tukey HSD Quantile function 476
tutorials 29
creating formulas 257
two-digit year rule, importing data 72
two-way table of summary statistics 273
U
unary sign function button on keypad 246
Underline Table Headings 411
Ungroup command 358
Unicode 403
save text files preference 403
units 186
univariate statistics 271
update
matching columns 233
updating data tables 231
upper control limits (UCL) 185
upper spec limits 185
Uppercase function 454
US Population.jmp 242
Use a Floating Window for Data Filters 414
Use an Asterisk with the PValue Format, in reports 407
Use Excel Labels as Headings, in general 403
Use SPSS Labels for column names during import, in general 403
Use tabs, in script editor 432
Use Thousands Separator 414
User Tables, database connections 105
V
validating data 179–180
value labels 180
sorting 202
value ordering
sorting data 202
values
high and low for columns (in DOE) 184
minimum and maximum 322
ordering 181
variable names 79
variable value tooltips, showing in script editor 432
variables
local 241
table. See table variables
Variance (summary statistics) 276
vertical, formula display 257
viewing
subset of rows in a data view 44
Views, database 105
W-Z
Warn before closing unsaved imported data 436
Week 286
Week of Year function 488
Weibull Density function 475
Weibull Distribution function 475
Weibull Quantile function 475
weight, preselected roles 195
WHERE clause editor 111
WHERE statement (SQL) 108
While function 469
widths
tick mark labels 329
wildtrack.org 334
Window Background Color 410
windows 402
hide splash 402
JMP Starter 402
Windows Explorer
preview pane 52
Word function 455
Word. See Microsoft Word
Words function 456
worksheets, selecting 403
Wrap Text, in script editor 432
Wrap the main menu in narrow windows 424
WWW. See Internet
Y-Axis Title Above Graph 408
Year function 488
Year Quarter 286
yellow tag icon 158, 316
zooming 319
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset