Index
Using JMP
Symbols
^. See insert button on keypad
! (Not) function 417
!= (not equal to) function 413
.emf 329
.eps 329
.gif 329
.pdf 329
*= (Multiply To) function 443
/= (Divide To) function 443
& (And) function 416
& (And) function and conditional clauses 417
+= (Add to) function 443
< (less than) function 413
<= (less than or equal to) function 413
= (Assign) function 443
== (equal to) function 413
> (greater than) function 413
>= (greater than or equal to) function 413
| (Or) function 417
Numerics
1, 2, and 4-byte integers 145
A
A tool. See annotate tool
Abbrev Date function 437
Abs function 401
Add All Windows 340
Add Database Query 340
Add Document 339
Add files opened by scripts to the Recent Files list 369
Add Filter Columns 262
Add Folder 339
add ranges, missing values 153
Add SAS Stored Process 340
Add to (+=) function 443
Add URL 340
Add Window 339
adding
columns 103
graphics and graphics scripts 314
maps and boundaries 300
rows 103
statistics columns 239
add-ins
managing 362363
opening as text 59
Aggregate functions (SQL) 94
allowing short numeric formats 145, 375
analysis roles 163
Analyze
toolbar 348
And (&) function 416
And (&) function and conditional clauses 417
annotate tool 307
annotations
creating 307
setting the default font 386
apostrophes in imported data 58
appending tables. See concatenating tables
Application
toolbar 348
ArcCosH function 404
ArcCosine function 404
archive files in project 339
ArcSine function 404
ArcSinH function 404
ArcTangent function 404
ArcTanH function 404
arguments
definition 230
opening and closing 224
arithmetic buttons on keypad 213
arrange
windows 44
Arrhenius function 403
Arrhenius Inv function 403
arrow
cursor tool 42
double arrow tool 42
As Row State function 438439
Assign (=) function 443
Assignment functions 443
assignment table property 281
asterisk icon 37, 151
attaching tables. See concatenating tables
Auto-complete parentheses and braces, in script editor 390
automatic recalc option 268
Auto-save the report to 371
axis
adjusting 264, 292
copying and pasting settings 297
customizing 292
divider lines and frames 299
gridlines 298
increments 294
labels 295
minimum and maximum values 293
numeric format 295
scale 293
scrolling 292
specifications for columns 154
tick marks 297
B
background color
preference 369
background colors 290
backwards compatibility 320, 368
backwards compatibility, tables 320
bars, histogram colors 290
base e 401
Bernoulli trials 433
best numeric formats 146
Beta Binomial Distribution function 427
Beta Binomial Probability function 427
Beta Binomial Quantile function 427
Beta Density function 418
Beta Distribution function 418
Beta function 402
Beta functions 402
Beta Quantile function 419
BETWEEN statement (SQL) 94
Big Class.jmp 224
Binomial Distribution function 427
Binomial Probability function 427
Binomial Quantile function 427
Blink button in row editor 121
Blob to Char function 409
boundaries, adding 300
boxes around formulas 223
braces in script editor, auto-complete 390
Break function 418
brush tool 282
building formulas 207
buttons
copying 355
creating 350
show and hide 358
C
Car poll.jmp 250
Cartesian join. See joining
Categorical Color Theme 374
Cauchy distribution 433
Ceiling function 401
cell formulas 105
Change Format option 252
Change Item Label 252
Change Plot Scale option 252
Char function 404
Char to Blob function 409
Char to Hex function 407
character data types 144
Character functions 404409
Character Pattern functions 409412
character sets 320
in data tables 320
save text as Unicode preference 368
select during text import 57
characteristics, rows and columns 131
ChiSquare Density function 419
ChiSquare Distribution function 419
ChiSquare Quantile function 419
Choose function 416
circle with strikethrough icon 131
clauses 230
cleaning data 112
closing
JMP Starter window 31
levels in a report 264
closing JMP Starter window 24
coding, column property 156
Coefficient of Variation 241
Col functions 429, 435
Col Maximum function 429
Col Mean function 428
Col Minimum function 429
Col N Missing function 429
Col Number function 429
Col Quantile function 429
Col Rank function 430
Col Shuffle function 435
Col Standardize function 430
Col Std Dev function 428
Col Sum function 429
Color function 439
Color Of function 442
Color State function 438, 440
Color Theme 154
Color Themes 374
Color Themes 374
colors
background in graph 291
backgrounds 290
by row state 134
histogram bars 290291
markers 284
rows and columns 133
shapes added to reports 309311
column switcher 268
column tables 250
columns
adding 103
adjusting widths 34
axis specifications 154
characteristics 131
compress 163
control limits 157
deleting 103
design roles 158
duplicating 118
excluding 131
factor changes (DOE) 158
fonts used in headings 386
formulas 152, 207
hiding 132
joining 188
labeling 132
locking 139, 143
measuring units 158
moving 118
names 34, 112
notes 152
order of data in reports 157
panel 3738
preselected analysis roles 163
properties 151, 160
reordering 117
response limits 157
row state 149150
Sigma values 158
sorting 117
source column 186
spec limits 157
splitting 177
stacking 173
transposing 181
validating data 152153
value labels 153
columnwise statistics functions 428
combine reports 266
Combine States function 438, 440
communications settings 98, 387
Compare column 111
Comparison functions 413
compress columns 163
Concat function 404
Concat Items function 408
concatenating tables 185
Conditional functions 413418
Connections, database. See database connection
Contains function 405
Continue function 418
Continuous Color Theme 373
continuous modeling types 144
Continuous Scale command 288
control limits 157
Copy As SAS Formula 222
Copy Formula button, using when
creating a subset 168
joining tables 168, 175, 179, 190
copy menu and toolbar items 355
copying
axis frame settings 297
graph contents 297
row states 150
text 330
copying toolbars 347
CosH function 404
Cosine function 404
Count (in a formula) 400
Count column 115
Count function 399
creating
menu items and buttons 350
menus 350
source columns (when concatenating tables) 186
creating data tables 98
crosshairs tool 291
currency formats
columns 146
cursor forms 42
customization sets
changing 346
importing 359
customizing
axes 292
graph elements 311
menus and toolbars (Windows) 345
results 327
See also preferences
toolbars (Macintosh) 360
toolbars and menus (Windows) 345
D
data
grid 34
missing 114
recoding 112
data feed. See communications settings
Data Filter 270
data filter
hierarchical 277
Data Table Clear Selection 139
data tables
compare 127130
concatenating 185
creating 98
data grid 3343
editing 112
elements of data tables 33
joining 188
locking 36, 121
names and notes, placing on reports 370
names, changing 121
opening 43
panels 34
preferences 374
properties 36, 281
saving 319
sorting 170
splitting 177
stacking 173
subsetting 167
summarizing 235
transposing 181
updating 198
Data Tables List toolbar 348
data types
character formats 144
date and time formats 146
numeric formats 146
row states 144, 149
specifying 144
data view
created from rows panel 38
database connection 8892, 323
datafeed. See communications settings
Date Difference function 437
Date DMY function 436
Date Increment function 437
Date MDY function 436
Date Time functions 435438
dates and times
formats 146147
inserting on report window 370
Day function 436
Day of Week function 436
Day of Year function 436
decreasing font sizes 266
defaults
JMP window 368
defaults. See factory defaults
delete button, on formula editor keypad 213
delete expression 213
deleting
columns 103
functions 221
menus 357
rows 103
toolbars 357
derivatives 218
descriptive statistics. See statistics columns
deselecting parts of a report 265
Design of Experiments. See DOE 156
design roles 158, 163
Design, table variable 36, 123
Desirability function 432
desirability values, as column properties 158
detailed maps 301
diamond icon, on a report 265
Dif function 400
Digamma function 403
disclosure icon. See diamond icon
discontiguous selection 106, 109
Discrete Probability functions 426428
distribution
column property 158
setting column property to automatically fit curve 158
Divide To (/=) function 443
DOE (Design of Experiments)
coding 156
toolbar 348
Double Declining Balance function 444
downsaving 320, 368
DPI, report graphics 326
dragging and dropping
in data table 118
into formulas 221
into other programs 329
drawing speed of markers 284
drawing tools 309311
dropping
columns when splitting tables 178
columns when stacking tables 174
duplicates when joining tables 191
Dunnett P Value function 419
Dunnett Quantile function 419
duplicating cells and columns 118
E
Edit Notes 341
editing
column names 112
formulas 221
names of data tables 121
names of report tables 281
reports 265
table variables 123
tables 112
WHERE clauses 96
efficient evaluations 217
elements and element browser in formula 230
eliminating missing rows (when stacking tables) 174
EMS 325
Encapsulated PostScript File 325
End of Field and End of Line options 57
Ends With function 407
end-to-end merging. See concatenating tables
Enhanced Metafile 325
EPS support in reports 325
equal to (==) function 413
equation editor. See formula editor
errors, ignoring in formulas 220
evaluating columns’ formulas
viewing evaluations in formulas 220
when creating subsets 168
when joining tables 190
when splitting columns 179
when stacking columns 175
examples, formulas 224
Excel
versions 2007+ 53
Excel files
opening 64
Excel versions 53
Excel, selecting worksheets when opening 368
Excluded function 440, 442
Excluded functions 438439
excluded rows, showing in a data view 38
excluding
columns when splitting tables 178
columns when stacking tables 174
duplicates when joining tables 191
rows and columns from analyses 131
Exp function 401
exponent button on keypad 213
exporting
column names to text files 321
data tables 319
reports 325
Extra space at bottom of document, in script editor 390
extracting data from image 306
F
F Density function 419
F Distribution function 420
F Power function 425
F Quantile function 420
F Sample Size function 425
factor
for mixture experiments 156
split plots 158
factor changes 158
Factorial function 402
factory defaults
min and max axis values 293
fast marker
drawing speed 284
threshold 373
fat plus tool 42
Fibonacci series 400
field widths
of tick mark labels 298
File_Edit toolbar 347
files
opening 320, 368
saving without Unicode 320, 368
filling columns with data 150
filtering columns 262
filtering data 270
Finance Functions 444
Find/Length expression 405
finding and replacing values 115
fit
column property to draw automatically when analyzing distribution of column 158
Floor function 401
fonts
changing in data tables 34
changing size in data tables 266
For function 418
For quantile statistics option when summarizing tables 238
Format function 437
formula editor 207228
formula element browser 211
formulas
arguments, opening and closing 224
boxes, hiding and showing 223
cell expressions 105
constants, adding 211
creating 152
types of formulas 207
data table elements, adding 208
editing 221
entering into cells 105
evaluating 216, 219, 377
examples 224
expressions 221
fonts 223, 386
functions, adding 213, 399
glossary of terms 229
JSL view 220
keyboard shortcuts 229
opening and closing arguments 224
operators, adding 212
orientation in formula editor 223
shortcuts, keyboard 229
tutorials 224
viewing 220, 223
Frame Border 374
Frame Color 374
frame sizes of plots or graphs 290
Freq (Frequency). See preselected role
Full Quadratic Model function 444
function browser 213
function types
Add to (+=) 443
And 417
Assign (=) 443
Assignment 443
Beta 402
Character 404
Character Pattern 409
Col 429, 435
Color 439
Color State 438
Combine States 438
Comparison 413
Conditional 413
Date Time 435
Discrete Probability 426
Divide To 443
Excluded 438439
Hidden 439
Hidden State 438
Hue State 439
Is Missing 413
Marker 439
Match 227
Multiply To (*=) 443
Numeric 401
Parametric Model 443444
Post Decrement (--) and Increment (++) 443
Probability 418
Random 432
Row 399
Row State 438
Shade State 439
Statistical 428
Transcendental 401
trigonometric 403404
functions
adding 213
aggregate (SQL) 94
columnwise statistics 428
deleting 221
glossary of terms 230
peeling 221
Row States 438
Future Value function 444
G
Gamma Density function 420
Gamma Distribution function 420
Gamma function 402
Gamma Poisson Distribution function 426
Gamma Poisson Probability function 426
Gamma Poisson Quantile function 426
Gamma Quantile function 421
general preferences 365
GIF 325
global variables, storing a report table 281
GLog Density function 422
GLog Distribution function 423
GLog Quantile function 423
glossary of formula terms 229
Go To command 109
Go To Row command 106
grabber tool. See hand (grabber) tool
Graph
toolbar 348
Graph Background Color 374
Graph Border 374
Graph Builder preferences 378
Graph Height 374
graph marker theme, default 373
graph preferences 372
graphics
adding to buttons 352
adding to reports 311
saving reports as graphics 329
scripts 314
graphics, dragging into graph 304
graphs
copying and pasting contents 297
customizing elements 311
greater than (>) function 413
greater than or equal to (>=) function 413
grid. See data grid
gridlines 298
GROUP BY command (SQL) 95
grouping variables
using when sorting tables 172
using when splitting tables 177
H
hand (grabber) tool
using in formula editor 221
using in reports 264
using to scroll axes 292
hard (factor changes), factor, hard or easy to change 158
HAVING command (SQL) 95
Hex function 407
Hex to Blob function 409
Hex to Char function 407
Hex to Number function 407
Hidden function 440, 442
Hidden functions 439
hidden rows
showing in a data view 38
Hidden State function 438
hiding
columns 132
menu tips 368
results 265
rows 132
thumbnails of reports 383
toolbars 345
hierarchical data filter 277
Highlight Outline Headers option 383
histograms, bar colors 290
Home
toolbar 348
Home Window 29
horizontal
alignment in reports 264
formula display 223
Hot Dogs.jmp 227
Hour function 436
Hover Help 370
HTML
importing 61
Hue State function 439, 441
Hypergeometric Distribution function 427
Hypergeometric Probability function 428
I
I-beam cursors 42
icons
asterisk 37, 151
circle with strikethrough 131
column characteristics 37
column properties 37
diamond (disclosure) 265
list check 37
lock 37, 122
mask 37, 132
modeling types 37
plus 37, 152
preselected roles 163
range check 37
red triangle 266
yellow tag 37, 132
ID column. See Source Label Column
If function 414
IfMax function 416
IfMin function 416
ignoring
errors 220
missing values (when updating tables) 199
images
dragging into graph 304
extracting data 306
importance values, entering 158
importing
data 5363
Excel files 64
HTML 61
ODBC 323
SAS files 6668
text files 54
text from the Script window 61
toolbar and menu customizations 359
using a database 88
using SQL statements 91
In Days function 436
In Hours function 436
In Minutes function 436
IN statement (SQL) 94
In Weeks function 436
In Years function 436
Include marginal statistics option 237
Include missing for grouping columns option 253
Include Non Matches option 191
increasing font sizes 266
indent guides, showing in script editor 390
Informat function 437
initial
data values 150
input formats 146
insert button on keypad 213
Insert function 408
Insert Into function 408
insertion points 42
instruments, connecting 98, 387
Interactions Model function 444
Interest Payment function 444
Interest Rate function 444
internal name 349, 351
Internal Rate of Return function 444
international numeric formats 149
Internet
file formats 325
opening Internet files 61
Interpolate function 417
Is Missing function 413
Item function 407
J
Java 1.6 65
JMP 5 compatibility 320
JMP Projects 337341
JMP Starter 24
hiding on startup 368
JMP tutorials 23
JMP.PFS 367
Johnson Sb Density function 425
Johnson Sb Distribution function 425
Johnson Sb Quantile function 425
Johnson Sl Density function 425
Johnson Sl Distribution function 425
Johnson Sl Quantile function 425
Johnson Su Density function 424
Johnson Su Distribution function 424
Johnson Su Quantile function 424
joining
by matching columns 191, 195
by row number 191
tables, methods 188
using Cartesian join 191, 194
Joint Photographics Expert Group (JPEG, JPG) 325, 329
journals
creating 330
JPEG, JPG 325, 329
JRE 1.6 65
JSL scripts
adding 124
copying 127
creating from a report 326
deleting 36, 127
editing 36, 127
fonts 386
formula editor 220
graphics scripts 314
new 36
running 36, 127
saving in data tables 36
suppressing automatic execution 375
viewing in formula editor 220
K
Keep All option 178
keypad, formula editor 96
L
Label column name 175
Labeled and Labeled State functions 439
Labeled function 442
Labeled State function 440
labelled rows
showing in a data view 38
labels
axis 295
field widths 298
icon 132, 287
markers 287
rows and columns 132
tick marks 297299
value labels 153
Lag function 400
language preference, JMP indexes 369
large plus cursor 42
laser pointer 372
lasso tool 283
Left function 407
legends 288
add 288
remove 289
Length function 405
LEV Density function 421
LEV Distribution function 421
LEV Quantile function 421
LGamma function 403
library. See SAS transport files
LIKE statement (SQL) 94
limits, specification, control, response 157
line numbers, in script editor 390
line tool 309
linear axis scale 293
Linear Model function 444
lines
width 290
lines, dotted or dashed reference lines 300
linked data table 168, 281
list checking
cursor 42
sorting data 170
Little.jmp 196197
loading, SQL queries 95
Local Data Filter 267
local variables
button on keypad 213
using in formula 209, 225
localizing toolbar and button captions 349
locking
columns, preventing from being moved 139
data tables 36, 121
log
opening by default 383
saving 341
saving a report to 371
showing DisplayBox messages 369
Log function 401
Log window, saving reports to 371
Log, axis scale type 293
Log10 function 401
logarithm, natural 401
Logistic Density function 421
Logistic Distribution function 421
Logistic Quantile function 421
Logit function 403
Loglogistic Density function 421
Loglogistic Distribution function 421
Loglogistic Quantile function 421
Lognormal Density function 421
Lognormal Distribution function 422
Lognormal Quantile function 422
Long Date function 437
lower control limits (LCL) and spec limits 157
Lowercase function 405
M
magnifying glass tool 290
Major Grid Line Color 374
Major Grid Lines 374
Make Into Data Table option 253
Make into Matrix command 281
Make Window with Legend command 288
manipulating plots/graphs 289
maps
adding 300
adding custom maps 302
simple and detailed 301
WMS 301
marginal statistics 237
Marker functions 439
Marker Of function 443
marker selection mode 373
Marker State function 441
markers
adding 133
changing shape 288
changing sizes 284
colors 284
default shape 373
default size 373
drawing speed 284
drawing speed/marker 284
excluding 286
excluding and hiding 286
hiding 286
highlighting 285
highlighting in plots 281
labeling 287
labels 287
legends 288
outlines 285
point values 288
shapes 133, 284
speed 284, 373
threshold 373
transparency 286
mask icon 132
Match Flag column 190
Match function 227, 414
matching
cases while searching 116
columns when joining tables 195
targets 158
whole words in search 116
matching columns (update) 199
matching specifications 189, 192
matrix 281
Max (summary statistics) 241
Maximum function 431
MDYHMS function 437
Mean (summary statistics) 241
Mean function 430
measuring units, columns 158
Median (summary statistics) 241
members, importing 67
menu items
creating 350
menu preferences 395
menu tips 25, 368
menus
copying 355
creating 350
deleting 357
rearranging 356
merge old menus 360
merge vertically. See concatenating
merging same name columns 190
Mersenne-Twister technique 432
Microsoft Word and PowerPoint 329
Min (summary statistics) 241
minimum and maximum axis values 293
Minimum function 431
Minor Grid Line Color 374
Minor Grid Lines 374
Minute function 436
missing
terms, in formulas 231
value comparison 413
values, in formulas 231
values, updating tables 199
missing data patterns 114
missing value code, SPSS 63
missing values 153
add ranges 153
mode, marker drawing 284
modeling types
continuous 144
icons 37
nominal 144
ordinal 144
specifying 144
Modified Internal Rate of Return function 444
Modulo function 401
Month function 436
moving
cells and columns 118
rows 119
selection in data table 376
Multiple Series Stack 174
Multiply To (*=) function 443
Munger function 405
example 226
N
N and N Missing (summary statistics) 240241
N Missing function 431
naming
data tables 121
report tables 281
reports 266
natural logarithm 401
NChooseK function 402
NChooseK Matrix function 402
Neg Binomial Distribution function 427
Neg Binomial Probability function 427
nested variables 238
nesting boxes, formula editor 224
Net Present Value function 444
new
columns 103
rows 103
New Group 339, 341
no-intercept model 156
nominal
modeling types 144
Non matches, include when joining tables 191
noncentrality 419420, 423424
Normal Biv Distribution function 422
Normal Density function 422
Normal Distribution function 422
Normal Quantile function 422
Not (!) function 417
not equal to (!=) function 413
notes
as table variables 36, 122
displaying in report windows 370
saving in a column 152
NRow function 400
Num function 406
Number function 430
Number of Periods function 444
Number of Series option 174
numeric
allowing short numeric 375
formats 146149
in axes 295
short 145
international formats 149
Numeric functions 401
O
ODBC 88, 323
ODBC drivers for importing data 53
ODS results 82
Offset expression 405
OnOpen 125
Open All Below command 264
Open All Like This command 264
Open Database Connectivity 323
open windows 30
opening
add-ins as text 59
data in text editors 59
databases 88
Excel files 64
Excel worksheets 368
Internet files 62
JMP files 43
JMP Starter window 24, 31
journals 43
SAS data sets 66
SAS files 66
SAS stored process report as data table 63
scripts 43
SPSS files 63
text files 54
operator names
script editor, adding spaces between words 390
operator tips, showing in script editor 390
operators
adding 212
in assignment functions 443
Or (|) function 417
ORACLE synonyms 90
Order by count of grouping columns option 253
order of operations 216
ordering
columns 117
row order levels 157
values 154
ordinal modeling types 144
orientation of formulas 223
outlines
adding to markers 285
structure of reports 265
Output Table option
joining tables 189
sorting tables 171
oval tool (simple shape tool) 309310
P
page
breaks, inserting 265, 328329
panels. See data table panels
Parametric Model Functions 443444
parentheses
script editor, adding spaces inside 390
script editor, auto-complete 390
password protected data sets 80
Paste Special command 329
Pat Abort function 411
Pat Altern function 412
Pat Any function 410
Pat Arb function 411
Pat Arb No function 411
Pat At function 411
Pat Break function 410
Pat Concat function 412
Pat Conditional function 412
Pat Fail function 411
Pat Fence function 411
Pat Immediate function 412
Pat Len function 410
Pat Match function 412
Pat Not Any function 410
Pat Pos function 410
Pat R Pos function 410
Pat R Tab function 411
Pat Regex function 412
Pat Rem function 411
Pat Repeat function 412
Pat Span function 410
Pat String function 410
Pat Succeed function 411
Pat Tab function 410
Pat Test function 411
patterns of missing data 114
Payment function 444
PDF 325
PDF file, headers and footers 334
peel (delete expression) 213
peel function 221
percent of total (summary statistics) 241
Personalization window 32
platform preferences 377
platforms
common features 261
launch windows 261
plots and graphs
adding graphics 311
annotations, adding 307
appearances, altering 289
markers, changing 283
resizing 289
shapes, adding 309
statistics, adding 236
PNG 325, 329
points. See markers
Poisson Distribution function 428
Poisson Probability function 428
Poisson Quantile function 428
polygon (spline) tool 309310
Post Decrement (--) and Increment (++) functions 443
power. See Sample Size and Power
PowerPoint 329
precedence 216
preferences 365
Graph Builder 378
preferences, reset 367
preselected analysis roles 163
Present Value function 445
presentations, journal 334
Preserve SAS formats 322
Preserve SAS variable names 322
Preview Graph 374
previewing text on import 56
Principal Payment function 445
printing
page breaks 328329
Probability functions 418426
Probit function 422
Product function 431
projects
automatically open files 340
dragging and dropping files into 340
fix broken link 341
properties
creating with JSL 160
table properties 281
Q
Quantile function 430
quantile statistics 238
Quarter function 436
queries, SQL 95
quotation marks in imported data 58
R
Random Beta Binomial function 434
Random Beta function 433
Random Binomial function 433
Random Cauchy function 433
random data, adding 150151
Random Exp function 432
Random Frechet function 434
Random functions 432435
Random Gamma function 432
Random Gamma Poisson function 434
Random Geometric function 434
Random GLog function 434
Random Integer function 433
Random Johnson Sb function 433
Random Johnson Sl function 433
Random Johnson Su function 433
Random LEV 435
Random Logistic function 434
Random Loglogistic function 434
Random Lognormal function 434
Random Negative Binomial function 433
Random Normal function 432
Random Poisson function 434
Random Reset function 435
random sample (subset) 168
Random Triangular function 433
Random Uniform function 432
Random Weibull function 434
range checking 42
range comparison function 413
ranges, summary statistics 241
read-only data 122
rearrange open windows 30
rearranging
cells and columns 118
results 327
rearranging toolbars 354
recent files 30
recoding data 112
rectangle tool (simple shape tool) 309
red triangle icon 266
reference lines, adding 300
Regex function 408
Regex Match function 412
Remove Column Label 252
Remove From function 408
Remove function 408
renaming
data tables 121
report tables 281
reports 266
reordering
columns 117
Repeat function 408
Replace argument 405
replacing
tables (when sorting) 172
values in a data table 115
Report Invalid Display Box Messages 369
report preferences 370
report windows
customizing 327
dates and times, adding 370
disclosure button 265
formatting 264
options 266
order of data 154, 157
rearranging results 327
red triangle icon 266
renaming 266
saving 325
styles 370
tables 280
Resample Freq function 435
reset preferences 367
resizing plots/graphs 289
response limits 157
responses, multiple 158
Restore Column Label 252
restricting search to selected rows or columns 116
results. See report windows
Reverse function 408
Reverse Into function 408
reverting columns to original order 118
Right function 407
roles
design roles 158
preselected analysis roles 163
root button on keypad 213
Root function 402
Round function 401
row
editor 119
selection 107
Row function 399400
Row functions 399400
row selection, direction of movement when pressing Enter/Return 376
row state
columns 144, 149150
data types 144, 149
Row State function 439
Row State functions 438440
row states
clear 139
coloring rows by column values 134
row tables 250
rows
adding 103
characteristics 131
coloring 133
deleting 103
excluding 131
hiding 132
joining 188
labeling 132, 287
legends 288
markers 133
menu items 41
moving 119
order of data in reports 157
sorting in data tables 170
subsetting 167
summarizing 235
transposing 181
rows panel 38
creating a data view of selected rows 38
RTF (Rich Text Format) files 326
running scripts 36
S
sample size, in tabulate 253
SAS
creating transport files 68
files 68
importing password-protected data sets 80
opening data sets 66
saving in SAS format 321323
toolbar 348
transport files 321
variable names 6667
variable names in imported data 66
SAS 9.3 preferences 391
SAS metadata server
supported version 68
SAS metadata server, automatically connect 392
SAS, submit code 81
Save and Save As menu items 319
Save Journals GZ Compressed 369
Save Session Script 337
Save the session when exiting command 372
saving
column property 156
data tables 319
log windows 341
reports 325
reports as graphics 329
results to a database 323
scripts 326
scripts in English 369
spec, control, and response limits 157
SQL queries 95
Unicode 320, 368
saving and evaluating formulas (when concatenating tables) 186
saving without Unicode 320
Scalable Vector Graphic format 329
scaling
axes 292
Scheffe Cubic function 403
Script All By-Groups menu 268
script editor
auto-complete parentheses and braces 390
extra space at bottom of document 390
indent guides, showing 390
line numbers, showing 390
operator tips, showing 390
spaces in operator names 390
spaces inside parentheses 390
tab width 390
use tabs 389
variable value tips, showing 390
Script menu 267268
scripts
graphics 314
running when a data table is opened 125
saving in English 369
See JSL scripts
scroll lock/unlock 139
scrolling
axes 292
Search/Find 115
using the row editor 121
Second function 436
Select Dominant 107
Select Individual Excel Worksheets command 368
Select Randomly 107
SELECT statement (SQL) 92
Selected function 439, 442
selected rows
showing in a data view 38
Selected State function 439, 441
selecting
cells 106, 109110
columns
when joining tables 191
irregular area of points 283
parts of a report 265
points in plots 281
rectangular area of points 282
rows and columns in data tables 42108
rows and columns in plots 282
selection (large plus) cursor 42
sequence data, adding 150
Sequence function 399
sessions, saving 336
setting
markers according to point values 288
SEV Density function 423
SEV Distribution function 423
SEV Quantile function 423
Shade State function 439, 441
shapes. See drawing tools
Shift function 408
Shift Into function 408
Short Date function 437
short, allowing short numeric 145, 375
shortcuts, keyboard 229
short-integer format 375
Show Chart option 253
Show Control Panel option 253
Show indent guides, in script editor 390
Show line numbers, in script editor 390
Show operator tips, in script editor 390
Show Shading option 253
Show Table option 253
Show Test Build Panel option 253
show toolbar 354
Show tooltip option 253
Show Tree Structure 265
Show variable value tips, in script editor 390
showing
boxes around formulas 224
results 265
Sigma, assigning values 158
simple maps 301
simple shape tool (oval or rectangle) 309
simplify formulas 218
Sine function 404
SinH function 404
sizing/scaling 290, 292
slope computation 226
Sorting
results by fields in a database (SQL) 93
sorting
data tables 170
list check 170
order 172
value labels 170
value ordering 170
source columns 186
Source Flag column 190
Source Label Column 175
Spaces in operator names, in script editor 390
Spaces inside parentheses, in script editor 390
spec limits 157
specifying columns when importing text files 58
speed, marker 284, 373
splash window 368
Split By column 179
Split Label Col 178
splitting columns 177
SPSS files, opening 63
SQL statements 9192
SQL WHERE clause editor 96
Squish function 402
stacking columns 173
Standard Deviation 241
Standard Deviation function 430
Standard Error 241
Starter Window 31
Starts With function 407
startup windows 368
Statistical functions 428432
Statistics button 236, 240
statistics column 236, 239240
Std Dev and Std Err (summary statistics) 241
Std Dev function 430
Step function 417
Stop function 418
stored process, copy metadata path 81
Straight Line Depreciation function 445
stripping enclosing quotes on imported data 58
subgroups, summary statistics 238
submit SAS code 81
Subqueries (SQL) 95
Subscript function 400
subsetting
from a data table 167
from a histogram 169
Substitute function 408
Substitute Into function 408
Substr function 406
Subtract To (-=) function 443
Sum function 430
Sum Of Years Digits Depreciation function 445
Sum Wgt (summary statistics) 241
summary table, creating 235
Summation function 431
supported version of SAS metadata server 68
suppressing formula evaluation
in data tables 36
on open 377
when creating a subset 168
when creating formulas 219
when joining tables 190
when splitting columns 179
when stacking columns 175
SVG 326
switch terms button on keypad 213
synonyms (ORACLE) 90
system tables (ORACLE) 90
T
t Density function 423
t Distribution function 423
t Quantile function 424
Tab width, in script editor 390
table properties
compare 130
table variables
adding 122188
creating 36, 123
editing 123
in formulas 123, 208
notes 123
tables
concatenating 185
panel 35, 37
report tables 280281, 386
toolbar 348
tabs
script editor 389
Tabulate 242257
tabulating data 242
Tangent function 404
TanH function 404
target value 157158
terms, formula 230
terms, switching in a formula 213
text
editing 59
importing 55
mode for formulas 220
opening add-ins as text 59
opening text files 54
saving as text 320
threshold of markers 373
tick marks 297
TIck marks inside graph frame 374
Time of Day function 436
time, adding to reports 370
Tip of the Day window
hiding and showing 368
title bar fonts 386
Today function 436
toolbars
adding buttons 347
Analyze toolbar 348
copy 347
copying 355
create 347
deleting 357
File_Edit toolbar 347
hidden 354
personalizing (Macintosh) 360361
rearranging 354
show and hide 358
showing by default 383
Tools toolbar 348
types of 348
toolbars and menus
personalizing (Windows) 345360
tools, cursor 42, 307
tooltips 25
Transcendental functions 401403
transparency, markers 286
transport files, creating 68
transposing rows and columns 181
treat empty columns as numeric 380
Trial1.jmp 192193
Trial2.jmp 192193
triangle icon 266
Trigamma function 403
trigonometric function types 403
Trim function 406
truth tables 417
Tukey HSD P Quantile function 425
Tukey HSD Quantile function 425
tutorials 23
creating formulas 224
two-digit year rule, importing data 58
two-way table of summary statistics 238
U
unary sign function button on keypad 213
Ungroup command 327
Unicode 320, 368
save text files preference 368
Uniform plot scale option 253
units 158
univariate statistics 236
update
matching columns 199
updating data tables 198
upper control limits (UCL) 157
upper spec limits 157
Uppercase function 405
US Population.jmp 210
Use tabs, in script editor 389
User Tables, database connections 90
V
validating data 152153
value labels 153
sorting 170
value ordering
sorting data 170
values
high and low for columns (in DOE) 156
minimum and maximum 293
ordering 154
variable labels, importing 392
variable names 66
variable value tooltips, showing in script editor 390
variables
local 209
table. See table variables
Variance (summary statistics) 241
vertical, formula display 223
viewing
subset of rows in a data view 38
Views, database 90
W-Z
Week of Year function 436
Weibull Density function 424
Weibull Distribution function 424
Weibull Quantile function 424
weight, preselected roles 163
WHERE clause editor 96
WHERE statement (SQL) 93
While function 418
widths
tick mark labels 298
wildtrack.org 306
windows 368
hide splash 368
JMP Starter 368
Word function 406
Word. See Microsoft Word
Words function 406
worksheets, selecting 368
WWW. See Internet
Year function 436
yellow tag icon 132, 287
zooming 290
..................Content has been hidden....................

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