Index_S

---

S

SAS application server

See default SAS application server

SAS Application Services 9

SAS Business Intelligence Infrastructure 8

SAS Application Services 9

SAS Foundation servers 8

SAS Foundation Services 9

SAS Client Services 10

SAS code transformation templates 109

creating 120

example 155

identifying 128

in jobs 128

SAS code transformations 109

access control 129

deleting folders for 129

exporting 128

importing 128

SAS/CONNECT servers

required for SAS ETL Studio 39

signon scripts for 182

SAS Data Quality Server

prerequisites for 51

SAS ETL Studio 5

components 13

features 10

installation 38, 39

migrating from SAS/Warehouse Administrator to 180

online Help 4, 13

SAS Intelligence Platform 8

SAS Intelligence Value Chain 6

starting 56

usage notes 20, 180

windows 13

wizards 18

SAS Foundation 8

SAS Foundation servers 8

SAS Foundation Services 9

SAS Intelligence Platform 8

SAS Business Intelligence Infrastructure 8

SAS Client Services 10

SAS Foundation 8

SAS Intelligence Value Chain 6

SAS Management Console

starting 40

SAS Metadata Server 9

SAS names

case and special characters in 184

SAS OLAP Server 9

SAS/SHARE libraries 45

importing keys and indexes from 184

SAS SPD Engine libraries 45

SAS SPD Server libraries 45

TEMP=YES option for 180

SAS Stored Process Server 9

SAS/Warehouse Administrator

migrating to SAS ETL Studio 180

SAS Workspace Server 9

SCD Type 2 Loader

configuring 150

schema names

DBMS names and 180

security

for data warehouses 26

servers

See also default SAS application server

database servers 185

entering metadata for 42

metadata server 13

required 39

SAS Data Quality Server 51

SAS Foundation servers 8

setup tasks

administrators 38

shortcut bar 15

shortcut plug-ins 190

installing 190

signon scripts

SAS/CONNECT servers 182

slowly changing dimensions 145

software installation 38, 39

source code

jobs with generated code 100

jobs with user-written code 101

source data

extracting and denormalizing 24

viewing in jobs 117

source designer plug-ins

building 191

installing and running 206

output 206

source designers 61

creating jobs with 116

entering metadata for source tables 72

External File source designer 47

extracting data from flat files 78

importing integrity constraints for tables 184

Teradata 186

unrestricted users and 186

usage notes for 183

Source Editor

submitting jobs from 182

submitting user-written code for cubes 172

Source Editor tab 107

Source Editor window 16

source tables

metadata for 72

sources 71

definition 60

examples 72, 78

specifying metadata for 60

viewing job data for 117

SPD Engine libraries 45

SPD Server libraries 45

TEMP=YES option for 180

special characters 49, 184

SQL Join transformation 137, 182

star schema

building cubes from 164

starting SAS ETL Studio 56

status line 15

stored processes

ODS output from 180

submitting code

user-written code for cubes 172

submitting jobs

from Source Editor 182

---