Index
A
accessing
file management functionality, 137
restricting access, 126–132
SAS Web Report Studio, 104
adding
bookmarks, 74
calculated items to cubes, 56–57
computed items to cubes, 57
dashboards to portlets, 189
data items to information maps, 102
filters, 63
measures, 59–60
pages in SAS Information Delivery Portal, 187
portlets, 188
time hierarchies, 54
AdmitDt variable, 4
AgeCat indicator, 175–176
aggregating data, 5
ampersand (&), 28
AmtCharge variable, 4
AmtPaid variable, 4
analytical tasks, with SAS Add-In for Microsoft Office, 38–44
applications
architecture of, 103
role-based, 12
applying prompted filters in SAS Web Report Studio, 147
architecture, of applications, 103
assigning data, 41, 147, 148
B
BI. See Business Intelligence (BI)
bookmarks
adding, 74
customized cube views, 74–75
deleting, 75
Business Intelligence (BI)
about, 1
integration between tools, 8–11
Platform, 6–8, 12–13
solutions for health-care industry, 6
C
calculating
charges by date of service and payment, 18–21
difference, 84–87
health-care metrics in OLAP cubes, 161–166
historical ratio of paid/charged amounts, 21–23
member count, 87
paid/charged amounts ratios, 21–23
percent paid, 86–87
CALL routine, 195
Category variable, 4
chaining stored processes, 26–29
charges, calculating by date of service and payment, 18–21
Claim Rep Data Security Cube, 152, 158
ClaimID variable, 4
ClaimRepID variable, 4
Claims Representative Comparison Report, 152
code, modifying, 33
computed items, creating, 84–87
conditional highlighting, 72–74, 111
conditional recipient lists, creating, 140
content
managing and sharing in Microsoft Office, 48
organizing in folders, 82–83
converting data items in SAS Information Map Studio, 84
Cost Trends Detail, stored processes for, 29
Cost Trends Summary, stored processes for, 27
costs, displaying and tracking, 23–24
Create New Stored Process Wizard, 19–21, 29
creating
AgeCat indicator, 175–176
computed items, 84–87
computed measures, 66–72
conditional recipient lists, 140
cubes, 52–57, 142–143
cubes using Cube Designer, 52–56
Current Members by Zipcode, 178–179
Current Members Indicator, 176–177
custom aggregations, 165
custom filters in SAS Web Report Studio, 115
dashboards for health-care industry, 169–196
data bridges with SAS Information Map Studio, 77–98
dependent prompted filters, 98
diagnosis groups, 71
dual filters, 96
dynamic prompt indicators, 192–193
filters, 87–93, 88, 115
folders, 82
footers, 108
highlighting rule, 73–74
Hot Spotters web application, 121
indicators, 175–180, 193
indicators in Medical Management Dashboard, 193
information maps, 79–94
information maps with prompted linked filters, 95–98
line plots in Graph Task, 43
links, 180–181
lists of values for data items in SAS Information Map Studio, 93
macro code to select multiple values in prompts, 30
MDX expressions with SAS Enterprise Guide, 155–158
measures, 55, 164–165
measures in cubes, 55
Member Profile Report, 117–121
multipurpose cubes, 142–152
multi-sectioned reports in SAS Web Report Studio, 145–152
OLAP cubes from summary tables, 164–166
OLAP information maps, 143–145
packages, 195–196
Population List Report, 113–117
population lists, 100–102
prefilters, 87
prompted filter combinations, 97
prompted filters, 89–91, 90, 92, 116–117
prompted filters in SAS Web Report Studio, 116–117
prompted reports, 113–121
prompts, 22, 90
prompts in OLAP information maps, 144
prompts in stored processes, 22
Provider Comparison Report, 146, 149, 150
recipient lists in SAS Web Report Studio, 138
rolling totals, 68, 157
security expressions in SAS OLAP Cube Studio, 160
security-based filters, 128, 131
Star Schema cubes in SAS OLAP Cube Studio, 142–143
stored processes with complex macro programming, 30–34
stored processes with linked prompts, 24–26
summary data sets for OLAP cubes, 163
summary reports, 105–110
tables, 41–42
Time dimension, 54
Cube Dimension properties, 159
Cube Manager, bookmarks in, 74
cubes
adding calculated items to, 56–57
adding computed items to, 57
bookmarking customized views, 74–75
creating, 52–57
creating measures in, 55
customizing views, 60
filter results in, 63–65
filtering, 64
providing information about, 53
selecting detail tables in, 53
Cubes Designer, creating cubes using, 52–56
Current Members by Zipcode, creating, 178–179
Current Members Indicator, creating, 176–177
custom aggregations, creating, 165
Custom tab (Select Data dialog box), 146
customizing
appearance of graphs, 44
cube views, 60
multiple report objects, 120
report appearance, 109
SAS Add-In for Microsoft Office, 44
D
Dashboard Designer, 174
dashboards. See also Executive Dashboard; Medical Management Dashboard
adding to portlets, 189
creating for health-care industry, 169–196
elements of, 170
indicators linked to, 182
placing in SAS Information Delivery Portal, 186–190
placing indicators inside, 185
SAS BI Dashboard, 8, 15, 170, 174–176
SAS BI tools for, 170–171
data. See also dynamic data
adding to information maps, 102
aggregating, 5
analyzing with SAS Enterprise Guide, 18–21
assigning, 41, 147, 148
converting in SAS Information Map Studio, 84
creating bridges with SAS Information Map Studio, 77–98
filtering, 38
managing with SAS Enterprise Guide, 18–21
manipulating, 162
properties of, 93–94
reading, 133
restricting access with MDX, 158–161
selecting for reports, 106, 113
Data Dimensions tab (Cube Manager), 60
Data Item Properties dialog box, 102
data model, for Healthy Living Inc., 3–5
data security
implementing via MDX, 152–161
in information maps, 126–132
in SAS Information Map Studio, 125–140
data sources
selecting, 146
using stored processes for indicator data, 194–196
date of service/payment, calculating charges by, 18–21
deleting bookmarks, 75
dependencies, specifying between prompts in stored processes, 26
dependent prompted filters, creating, 98
diagnosis-related groups (DRGs), 2, 71
dicing
in SAS OLAP Analyzer, 61–62
web reports, 10
difference, calculating, 84–87
dimensions
drilling in/out of, 61–62
hierarchy of, 52, 54
moving, 59–60
DischargeDt variable, 4
displaying
costs, 23–24
enrollment, 23–24
revenues, 23–24
stored processes in SAS Information Map Studio, 136
distributing reports conditionally, 138–140
DOS variable, 4
DRG codes, 130, 132
DRG variable, 4
DRGs (diagnosis-related groups), 2, 71
drilling in/out, of dimensions, 61–62
dual filters
creating, 96
populating prompted filters in, 97
dynamic data
stored process code for updating, 134
updating, 10, 136
updating with stored processes in information maps, 136
dynamic list, 102
dynamic prompt indicators, creating, 192–193
Dynamic Text Indicator, 177
dynamic updates, in SAS Information Map Studio, 125–140
E
e-mail, reports delivered by, 9
Encounter fact table, 3–4, 5
enrollment, displaying and tracking, 23–24
ER Daily Report, 137, 139
Excel
querying Data Warehouse in, 38
SAS Ribbon in, 36
execution options, 135–136
Executive Dashboard
about, 169
creating indicators, 175–180
design of revenue and costs graph, 11
elements of, 170
linking indicators for in-depth analysis, 180–184
organization of, 171–173
placing dashboards in SAS Information Delivery Portal, 186–190
putting into a single dashboard, 184–186
SAS BI Dashboard, 15, 170, 174–176
viewing in SAS Information Delivery Portal, 190
exporting results from reports, 112–113
Expression Editor (SAS Information Map Studio), 85, 86
external tables, identifying, 80
F
files, managing in SAS Web Report Studio, 137
filtering
cubes, 64
data, 38
in OLAP information maps, 144
in SAS OLAP Analyzer, 62–66
filters. See also prompted filters
adding, 63
creating, 87–93, 88, 115
creating in SAS Web Report Studio, 115
cube results in, 63–65
dependent prompted, 98
dual, 96
linked prompted, 98
predefined, 119
prefilters, 87
security-based, 128, 131
folders
creating, 82
in information maps, 83
organizing content in, 82–83
footers, creating, 108
formats, modifying, 108
Functions tab, 85
G
generating
headers, 107
monthly revenues with Summary Tables Wizard, 39–40
Graph Task
creating line plots in, 43
using SAS Add-In for Microsoft Office, 42–44
graphs, appearance of, 44, 47
group diagnosis codes, 70–71
H
headers, generating, 107
headings, labeling as, 185
Health Insurance Portability and Accountability Act (HIPAA), 3, 125
health-care data, aggregation challenges in, 142
health-care industry, US
creating dashboards for, 169–196
expenditures, 3
features of, 2–3
OLAP applications in, advanced, 141–167
SAS BI solutions for, 6
health-care metrics, calculating in OLAP cubes, 161–166
Healthy Living Inc.
building data bridges with SAS Information Map Studio, 77–98
creating dashboards for, 169–196
creating stored processes for finance department, 17–34
data model, 3–5
data security and dynamic updates with SAS Information Map Studio in, 125–140
patient management with SAS Web Report Studio, 99–124
solutions for, 6
hierarchy of dimensions, 52, 54
highlighting, conditional, 72–74, 111
highlighting rule, creating, 73–74
HIPAA (Health Insurance Portability and Accountability Act), 3, 125
historical ratio, calculating of paid/charged amounts, 21–23
Hot Spotters Information Map, 94
Hot Spotters web application, creating, 121
I
IBNR expenses, 18
ICD variable, 4
icons
OLAP, 153
SAS Information Map Studio, 78
SAS Ribbon in Excel, 36
SAS Web Report Studio, 106
identifying external tables, 80
implementing OLAP data security via MDX, 152–161
indicator data
creating, 175, 177
populating with UNION SQL queries, 183
indicators
AgeCat, 175–176
components of, 170, 171
creating, 175–180, 193
creating in Medical Management Dashboard, 193
dynamic prompt, 193
linking, 180–184
linking to SAS Web Report Studio, 194
Medical Management Dashboard, 192–194
placing inside dashboards, 185
in SAS BI Dashboard, 176
setting up interactions, 194
using stored processes as data sources for, 194–196
Information Map Properties dialog box, 101
information maps
adding data items to, 102
creating, 79–94, 95–98
creating with prompted linked filters, 95–98
data items in, 127
data security in, 126–132
dynamically updating data with stored processes in, 136
folders in, 83
managing, 95
OLAP, 143–145
properties, 89
replacing tables in, 95
stored processes in, 136
updating, 95
Initial view default bookmark, 74
inpatient hospital, Medicare’s payment methodologies for, 2
insurance programs, public, 2–3
International Classification of Diseases, Ninth Revision (ICD-9), 2
INTNX function, 101
J
joining tables, 80–82
L
labeling
as headings, 185
as links to SAS Web Report Studio, 186
launching SAS Management Console, 107
LIBNAME statement, 18
line plots, creating in Graph Task, 43
linked prompted filters, 98
linked prompts, creating stored processes with, 24–26
linking
indicators, 180–184, 194
indicators to SAS stored processes, 183
indicators to SAS Web Report Studio, 194
reports, 121–124
links
creating, 180–181
labeling as, 186
LOS variable, 4
M
macro invocation code element, 31
macro options code element, 31
macro programming, creating stored processes with complex, 30–34
macro shell code element, 31
Manage Prompts (Section Filters dialog box), 147
managing
content in Microsoft Office, 48
data with SAS Enterprise Guide, 18–21
graph appearance, 44, 47
information maps, 95
output, 46
stored process code additions, 135
MDX
about, 141–142
creating expressions with SAS Enterprise Guide, 155–158
implementing data security via, 152–161
naming conventions, 154
restricting data access with, 158–161
measures
adding, 59–60
creating, 164–165
creating computed, 66–72
creating in cubes, 55
specifying properties of, 86, 87
Medicaid, 2–3
Medical Management Dashboard
about, 169, 190–192
creating indicators in, 193
elements of, 170
indicators, 192–194
using stored processes as data sources for indicator data, 194–196
Medicare, 2–3
member count, calculating, 87
Member Profile Report, 117–121
Member Profile table, 192
MemberID prompt, 120–121
MemberID prompted filter, 89–91
MemberID variable, 4
metadata, 11–12, 134
Microsoft Office. See SAS Add-In for Microsoft Office
mlogic code element, 31
modifying
code, 33
formats, 108
recipient lists, 140
stored processes, 29
styles, 45
MonthDOS variable, 4
monthly revenues, generating with Summary Tables Wizard, 39–40
moving dimensions, 59–60
mprint code element, 31
multipurpose cubes, creating, 142–152
multi-sectioned reports, creating in SAS Web Report Studio, 145–152
N
naming conventions (MDX), 154
navigating SAS Information Map Studio, 78–79
NRSTR macro function, 28
O
OLAP applications
about, 141–142
building OLAP information maps, 143–145
computing health-care metrics in OLAP cubes, 161–166
concepts and terminology, 153–155
creating MDX expressions with SAS Enterprise Guide, 155–158
creating multipurpose cubes, 142–152
creating multi-sectioned reports in SAS Web Report Studio, 145–152
creating OLAP cubes from summary tables, 164–166
creating Star Schema cubes in SAS OLAP Cube Studio, 142–143
data manipulation, 162
in health-care industry, 141–167
implementing OLAP data security via MDX, 152–161
restricting data access with MDX, 158–161
summary data sets, 163
OLAP cubes
calculating health-care metrics in, 161–166
creating from summary tables, 164–166
creating summary data sets for, 163
custom aggregations in, 166
OLAP information maps
creating, 143–145
creating prompts in, 144
filtering in, 144
OLAP security, in SAS Web Report Studio, 160, 161
OLAP Web Report Studio Report, 10
organizing
content in folders, 82–83
Executive Dashboard, 171–173
outpatient hospital, Medicare’s payment methodologies for, 2
output, managing, 46
P
packages, 195–196
pages, adding in SAS Information Delivery Portal, 187
paid/charged amounts, calculating historical ratio of, 21–23
PaidDt variable, 4
PATHNAME function, 134
patient management, with SAS Web Report Studio, 99–124
Percent of ER Paid, 155–156
percent paid, calculating, 86–87
percent sign (%), 28
PHI (protected health information), 3
physicians, Medicare’s payment methodologies for, 2
placing
dashboards in SAS Information Delivery Portal, 186–190
indicators inside dashboards, 185
populating
indicator data with UNION SQL queries, 183
prompted filters in dual filters, 97
prompts in stored processes, 22
static lists in prompted filters, 92
Population List Report, 113–117
population lists, creating, 100–102
Portal Report, 104, 110, 112
portlets
adding, 188
adding dashboards to, 189
defined, 187
predefined filters, 119
prefilters, creating, 87
presenting results in SAS Add-In for Microsoft Office, 45–47
PROC SQL, 24
programs
Aggregating Data in Revenue and Encounter, 5
Calculating Paid/Charged Amounts Ratios, 21–22
Chaining Stored Processes, 28
Code for the Stored Process for Cost Trends Detail, 29
Costs by Category and Diagnosis Codes, 25
Create and Publish a Package, 195
Creating Macro Code to Select Multiple Values in a Prompt, 30
Creating Summary Data Sets for the OLAP Cube, 163
DRG Codes Seen and Unseen, 130
Identify Frequent ER Users, 100–101
Modifying Code to Allow All Possible Values Section, 33
Populate Indicator Data with UNION SQL Queries, 183
Read Hospital Census Data, 133
SAS Stored Process Code, 184
Stored Process Code for Dynamic Data Updating, 134
Stored Process Code to Source Indicator Data, 195
Tracking and Displaying Revenues, Costs, and Enrollment, 23–24
prompt linking, 24–26
prompted filters
about, 115
applying in SAS Web Report Studio, 147
creating, 89–91, 90, 92, 116–117
creating combinations, 97
creating in SAS Web Report Studio, 116–117
populating in dual filters, 97
populating static lists in, 92
prompted linked filters, creating information maps with, 95–98
prompted reports, creating, 113–121
Prompted SAS Web Report Studio Report, 117
prompts
creating, 22, 90, 144
creating in OLAP information maps, 144
creating in stored processes, 22
creating macro code to select multiple values in, 30
dependent, 25
including all values in, 34
multiple values selection in, 30–32
populating in stored processes, 22
setting up, 123
specifying dependencies between in stored processes, 26
specifying multiple values in stored process, 32
properties
of data items, 93–94
information maps, 89
setting, 83–84
specifying of measures, 86, 87
Properties dialog box, 109, 119
Properties pane (SAS Information Map Studio), 79, 84
protected health information (PHI), 3
Provider Comparison Report, 146, 149, 150
ProviderID variable, 4
public insurance programs, 2–3
publishing packages, 195–196
Q
querying warehouse data with SAS Add-In for Microsoft Office, 37–38
R
RBRVS (resource-based relative value scale), 2
reading data, 133
recipient lists, creating in SAS Web Report Studio, 138
recipient lists, modifying, 140
registering tables in metadata, 134
relative contribution analysis, 69, 155
replacing tables in information maps, 95
report breaks, 139
Report Wizard, 104
reports
customizing appearance, 109
delivered by e-mail, 9
distributing conditionally, 138–140
distributing in SAS Web Report Studio, 137–140
exporting results from, 112–113
linking, 121–124
multi-sectioned, 145–152
prompted, 113–121
results in, 110–112
saving, 112–113
scheduling in SAS Web Report Studio, 137–140, 138
selecting data for, 106, 113
setting up filters, 119
summary, 105–110
working with results, 111
Resource Replacement dialog box, 95
resource-based relative value scale (RBRVS), 2
Resources pane (SAS Information Map Studio), 79
restricting
access, 126–132
data access with MDX, 158–161
results
exporting from reports, 112–113
presenting in SAS Add-In for Microsoft Office, 45–47
Revenue by Month, selecting multiple values in stored processes for, 32
Revenue fact table, 5
revenues, displaying and tracking, 23–24
role-based applications, 12
Rolling Total of Paid Amount, 156–158
running
stored processes, 23, 26, 35–37
stored processes for paid charge amounts ratio, 23
stored processes in Excel, 36
S
SAS Add-In for Microsoft Office
about, 8, 14, 35
accessing information maps from, 78
analytical tasks with, 38–44
customizing, 44–48
generating monthly revenue with Summary Tables Wizard, 39–40
presenting results in, 45–47
querying warehouse data with, 37–38
running SAS stored processes, 35–37
scheduling in, 47–48
sharing in, 47–48
using Graph task, 42–44
using OLAP Cubes with, 57–75
using Summary Tables task, 40–42
SAS BI Dashboard, 8, 15, 170, 174–176
SAS BI Platform
conceptual architecture of, 6–7
features of, 12–13
physical architecture of, 7–8
SAS BI tools. See also specific tools
for dashboards, 170–171
stored processes, 13–14
SAS Business Intelligence. See Business Intelligence (BI)
SAS Enterprise Guide
about, 8, 13, 142
capabilities of Tasks Menu in, 13
creating MDX expressions with, 155–158
creating rolling totals, 157
data management and analysis tasks with, 18–21
Summary Tables Wizard, 19
SAS Information Delivery Portal
about, 8, 15, 170
adding pages in, 187
placing dashboards in, 186–190
viewing Executive Dashboard in, 190
SAS Information Map Studio
about, 8, 14, 125–126, 170
converting data items in, 84
creating data bridges with, 77–98
creating information maps, 79–94
creating lists of values in, 93
data security in, 125–140
distributing reports in SAS Web Report Studio, 137–140
dynamic updates in, 125–140
navigating, 78–79
scheduling reports in SAS Web Report Studio, 137–140
showing stored processes in, 136
specifying join relationships between tables in, 81–82
SAS Management Console
about, 8, 15
launching, 107
SAS Metadata Server, 6–7, 11
SAS OLAP Analyzer
about, 58–59
adding measures, 59–60
creating computed measures, 66–72
elements of, 59
filtering and slicing in, 62–66
moving dimensions, 59–60
slicing and dicing in, 61–62, 62–66
SAS OLAP Cube Studio
about, 8, 15, 51
adding calculated items to cube, 56–57
adding measures and moving dimensions, 59–60
bookmarking customized cube views, 74–75
concepts and definitions, 51–52
conditional highlighting, 72–74
creating computed measures, 66–72
creating cubes in, 52–57, 142–143
creating cubes using Cube Designer Wizard, 52–56
creating cubes with, 52–57
creating security expressions in, 160
creating Star Schema cubes in, 142–143
Cube Designer, 52
dimension types, 53
filtering, 62–66
SAS OLAP Analyzer, 58–59, 61–62
slicing and dicing, 61–62
using with SAS Add-In for Microsoft Office, 57–75
SAS Ribbon, 36
SAS Stored Processes, 170. See also stored processes
SAS Web Report Studio
about, 8, 14, 87, 99–100, 170
accessing, 104
application architecture, 103
applying prompted filters in, 147
assigning data in, 147, 148
basics of, 103–113, 105
creating custom filters in, 115
creating multi-sectioned reports in, 145–152
creating population lists, 100–102
creating prompted filters in, 116–117
creating prompted reports, 113–121
creating recipient lists in, 138
data summarization options in, 114
distributing reports in, 137–140
drill-down application, 9, 10
file management in, 137
inserting totals in, 148
labeling as links to, 186
linking indicators to, 194
linking reports, 121–124
OLAP security in, 160, 161
patient management with, 99–124
report scheduling in, 138
scheduling reports in, 137–140
slicing and dicing web reports through, 10
saving reports, 112–113
scheduling
reports in SAS Web Report Studio, 138
in SAS Add-In for Microsoft Office, 47–48
workbooks, 47
Section Filters dialog box, 147
security, data. See data security
security expressions, creating in SAS OLAP Cube Studio, 160
security-based filters
creating, 128, 131
results from, 129
viewing SQL to verify, 129
Select Data dialog box, 146
Selected Resources (SAS Information Map Studio), 79
selecting
data for reports, 106, 113
data sources, 146
detail tables in cubes, 53
multiple values in stored process for Revenue by Month, 32
styles, 45
time hierarchies, 54
setting properties, 83–84
setup
indicator interactions, 194
prompts, 123
report filters, 119
sharing
content in Microsoft Office, 48
in SAS Add-In for Microsoft Office, 47–48
slicing
in SAS OLAP Analyzer, 61–62, 62–66
web reports, 10
specifying
join relationships between tables in SAS Information Map Studio, 81–82
multiple values in stored process prompts, 32
properties of measures, 86, 87
relationships between tables, 101
SQL, viewing to verify security-based filters, 129
SQL procedure, 24, 89
Star Schema cubes, creating in SAS OLAP Cube Studio, 142–143
static lists
about, 102
containing values of health plan, 94
populating in prompted filters, 92
Status variable, 4
stored processes
about, 17–18
advanced, 24–29
basic, 18–24
calculating historical ratio of paid/charged amounts, 21–23
chaining, 26–29
code, 134, 184, 195
code for dynamic data updating, 134
code to source indicator data, 195
for Cost Trends Detail, 29
for Cost Trends Summary, 27
creating for finance department, 17–34
creating prompts in, 22
creating with complex macro programming, 30–34
creating with linked prompts, 24–26
dependent prompts in, 25
dynamically updating data with information maps, 136
in information maps, 136
linking indicators to, 183
managing code additions, 135
modifying, 29
populating prompts in, 22
results of, 37
running, 23, 26, 35–37
running for paid charge amounts ratio, 23
running in Excel, 36
SAS, 13–14
selecting multiple values in for Revenue by Month, 32
showing in SAS Information Map Studio, 136
specifying dependencies between prompts in, 26
specifying multiple values in prompts, 32
tabulating charges by dates of service and payment, 18–21
tracking revenue, costs, and enrollment, 23–24
using as data sources for indicator data, 194–196
styles, 45
summary data sets, 163
summary reports, creating, 105–110
summary tables, 40–42, 164–166
Summary Tables Wizard, 19, 39–40
symbolgen code element, 31
T
tables
creating, 41–42
joining, 80–82
registering in metadata, 134
replacing in information maps, 95
specifying relationships between, 101
Tile Chart Indicator, 179
Time dimension, 52, 54, 55
time hierarchy, 54, 72
Time Series Analysis, 68
toolbar (SAS Information Map Studio), 78
tracking costs, enrollment, and revenues, 23–24
type dimension, 69–70
U
UNION SQL queries, populating indicator data with, 183
updating
dynamic data, 10, 136
dynamic data with stored processes in information maps, 136
information maps, 95
URLLink, 28
user-prompting framework, 13
V
variables
in Encounter fact table, 4
in information maps, 82
viewing
data item properties in SAS Information Map Studio, 94
Executive Dashboard in SAS Information Delivery Portal, 190
rolling totals in cube view, 68
SQL in test query, 89
SQL to verify security-based filters, 129
styles, 45
W
warehouse data, querying with SAS Add-In for Microsoft Office, 37–38
web reports, slicing and dicing, 10
WHERE statements, 87
workbooks, scheduling, 47
Y
YearDOS variable, 4
YearMonthDOS variable, 4
YearMonthPaidDt variable, 4
Z
ZipCode Comparison Report, 151
Symbols
& (ampersand), 28
% (percent sign), 28
%if...%then...%do code element, 31
%SYSFUNC, 134
&&Value&Num code element, 31