Book Contents		Master Index

S

S2KLEN statement

S2KLOAD statement

S2KMD option

S2KMD= statement

DBLOAD procedure

overriding access mode

QUEST procedure

S2KMOD option

S2KMODE= statement

DBLOAD procedure

overriding access mode

QUEST procedure

S2KPARMS file

S2KPW= statement

ACCESS procedure

DBLOAD procedure

passwords, overriding

SAS/ACCESS descriptors

changing database definitions, effects of

creating

creating in one PROC step

creating in separate PROC steps

listing

overview "SAS/ACCESS Descriptor Files"

overview "Understanding SAS/ACCESS Descriptor Files"

passwords

SAS/ACCESS software

interface, overview of

purpose of

SAS data files, examples used in this book

SAS data files, updating

overview

Version 6

Version 7

SAS formats

assigning

assigning to SYSTEM 2000 data

default conversions

inheriting variable names

reviewing

SAS/FSP procedures

browsing SYSTEM 2000 data

updating SYSTEM 2000 data

SAS informats

assigning

assigning to SYSTEM 2000 data

default conversions

reviewing

SAS System security

SAS variable names

inheriting

resetting to defaults

unique, generating

SAS variables

definition

reviewing

schema item types

character

date

numeric

overview

time

schema items

definition

indexing

null data

schema records

definition

null data

relationships between

SCS statement

secondary passwords

security

SEE: passwords

SAS System

SYSTEM 2000

SELECT statement

ACCESS procedure

SQL procedure

semicolon (;), statement delimiter

single-user environment

definition

enabling

sort keys, designating

sorting database output

overview

performance considerations

SQL procedure

browsing SYSTEM 2000 data

updating SYSTEM 2000 data

statement-queuing mode, single commands

statistics, calculating

stored strings

SUBSET statement

subsetting

overview

SYSTEM 2000 database input data

view descriptors

when browsing SYSTEM 2000 data

while browsing or editing

SYSTEM 2000 data

averages, calculating

character width, specifying

charting

combining

creating new items "Selecting and Combining Data with the SQL Procedure"

creating new items "Selecting and Combining Data with the SQL Procedure"

data order, specifying

data types, resetting to defaults

formats, assigning

formats, reviewing

FREQ procedure

grouping

informats, assigning

informats, reviewing

labeling

mapping between SYSTEM 2000 and SAS System

MEANS procedure

observations, definition

overview

percentages, calculating

printing

PROC SQL GROUP BY clause

rank order, calculating

RANK procedure

selecting with WHERE clauses

statistics, calculating

subsetting

updating data files, overview

updating data files, Version 6

updating data files, Version 7

variables, definition

variables, reviewing

WHERE clauses

SYSTEM 2000 data, browsing

overview

subsetting data

WHERE clauses

with FSBROWSE procedure

with FSVIEW procedure

with SAS/FSP procedures

with SQL procedure

with the QUEST procedure

SYSTEM 2000 data, updating

APPEND procedure

appending data, example

appending data, overview

appending data, to Version 7 files

appending data, to view descriptors

deleting records

overview

subsetting data

WHERE clauses

with FSEDIT procedure

with FSVIEW procedure

with SAS/FSP procedures

with SQL procedure

with the QUEST procedure

SYSTEM 2000 databases

access mode, specifying

ancestor records

blanks, in character item types

children records

column names, from SAS labels

column names, length of

columns, renaming

columns, resetting to defaults

data files, example

data types, resetting to defaults

database definitions, definition

database definitions, example

database files, allocating

database files, definition

database names

DBA passwords

DBLOAD procedure

deleting records

descendant records

execution environments

family of records

grouping data

indexing

insert mode

inserting records "Browsing and Updating with SAS/FSP Procedures"

inserting records "Inserting Data Records"

key items

labeling data

level numbers, specifying

locking levels

logical entries, adding and updating

logical entries, definition

mapping to/from the SAS System

master passwords

multi-user environment, definition

multi-user environment, enabling

naming

null data, definition

optimized load mode

optimized load processing, enabling

parent records

passwords "S2KPW="

passwords "SYSTEM 2000 Passwords"

record paths

renaming items

rolling back changes

schema item types, character

schema item types, date

schema item types, numeric

schema item types, overview

schema item types, time

schema items, definition

schema items, indexing

schema items, null data

schema records, definition

schema records, null data

schema records, relationships between

secondary passwords

single-user environment, definition

single-user environment, enabling

single-user operation

sorting output

specifying

subsetting input data

subsetting output data

where-clauses, definition

SYSTEM 2000 databases, creating

SEE ALSO: QUEST procedure

example "Loading the BANKING Database"

example "Loading the BANKING Database"

SYSTEM 2000 databases, loading

SEE: DBLOAD procedure

dropping records

from another SYSTEM 2000 database

from different paths

from scratch, example

incrementally, example

insert mode

listing variables

LOAD statement

optimized load mode

selecting processing mode

SYSTEM 2000 databases, updating

BY key considerations

deleting records

with BY keys, definition

with BY keys, examples

SYSTEM 2000 messages, logging

SYSTEM 2000 security

SYSTEM 2000 software, definition

SYSTEM 2000 statements

logging

strings and functions

syntax