Book Contents		Master Index

S

sample data

SAS/ACCESS interface

changing defaults

DBF files and

DIF files and

WKn files and

XLS files and

SAS/ACCESS software, overview

SAS/AF applications, reading PC files data into

SAS data files

creating

updating with PC files data

SAS data sets

converting to/from DBF files "DBF and DIF Procedures: Accessing DBF and DIF Files from PCs, UNIX, and OS/390"

converting to/from DBF files "PROC DBF"

converting to/from DIF files "DBF and DIF Procedures: Accessing DBF and DIF Files from PCs, UNIX, and OS/390"

converting to/from DIF files "PROC DIF"

transferring with DIF files

SAS/FSP procedures, browsing and updating data

browsing with FSVIEW procedure

SAS Viewer and

updating with FSVIEW procedure

SAS programs, PC files in

SAS Viewer

SCANTYPE statement, ACCESS procedure

SCL (Screen Control Language)

security

extracting data and

passwords

SELECT statement, ACCESS procedure

selecting and combining data

with SQL procedure

with WHERE statement

SKIP= option, PROC DIF statement

SKIPROWS statement, ACCESS procedure

sorted data

sorting data

WKn files

XLS files

spreadsheet files

SQL procedure

creating columns with GROUP BY clause

deleting data

inserting data

joining data from various sources

reading data "Reading and Updating Data with the SQL Procedure"

reading data "Reading and Updating Data with the SQL Procedure"

selecting and combining data

updating data "Reading and Updating Data with the SQL Procedure"

updating data "Reading and Updating Data with the SQL Procedure"

SS_MISS NULLS environment variable

SS_MIXED environment variable

SS_NAMES environment variable

SS_SCAN environment variable

statistics, calculating

with FREQ procedure

with MEANS procedure

with RANK procedure

SUBSET statement, ACCESS procedure

subsetting data