|
| |
 Information Technology
Initiatives in Nebraska, Hon. Rick Sheehy, Lt. Governor
With over 300 services now available from the State of Nebraska’s
award-winning Web portal, citizens and businesses are increasingly able to
conduct business with the State of Nebraska from their homes or offices.
Patients in rural communities can consult with medical specialists using the
Nebraska Statewide Telehealth Network. Students will be able to access classes
offered by schools across the state through a statewide synchronous video
network. Technology is also making state government more efficient. Network
Nebraska has achieved cost savings by aggregating State and University of
Nebraska networks into a multipurpose core backbone. Enterprise service and
purchasing agreements have saved more than $450,000. These are among the ways
the State of Nebraska is using technology to provide customer-focused services
to residents and businesses and to achieve greater efficiency. Lieutenant
Governor Rick Sheehy discussed these initiatives and the State’s IT strategy
at the Sept 14 NEBSUG meeting.
 Introduction to the SAS
Output Delivery System, David Kelley, SAS Institute
Download Slides (PDF, 1MB)
BT
The SAS Output Delivery System (ODS) has been widely adopted and embraced by
users since added to SAS in Version 8. With ODS, your reports are easily
rendered into industrystandard formats such as RTF and PDF, or as HTML pages for
easy upload to web sites. Gone are the days of having to manually re-type, or
tediously cut-and-paste results in your Output Window to other file formats.
This presentation offers something for SAS users at all experience levels with
the Output Delivery System. If you are unfamiliar with ODS, the presentation
will show you both why and how you should be using it. Experienced users will
see new ODS features added to SAS 9 Software that give you even greater control
over your output. Whatever your current skill level with ODS, this presentation
will show you at least one new tool to put to use in your work which will
impress your boss and co-workers!
 POWERful
Procedures for Knock-Out Analytical Results. Anil Jayaprakash, Experian
This talk highlights the sample size estimation tools available through two
Procedures added to the SAS/STAT Module in SAS 9.1 Software: POWER (Prospective)
and GLMPOWER (Retrospective). These new tools allow you to determine the sample
size required to get a significant result along with adequate power to
effectively carry out analytical tasks such as t-tests, ANOVA's, correlations,
regressions and survival analysis. The examples in this presentation on PROC
POWER and PROC GLMPOWER show you how to design a prospective study for
estimating sample size and power in order to detect meaningful differences in
the groups of interest and also perform a retrospective analysis for a past
study. By attending this presentation you'll can see how to apply the "power"
within these procedures to analytic projects in the health, behavioral and
marketing/decision sciences.
 Application of SAS/Intrnet® Software for Enhanced Data Analysis,
Visualization and Reporting, Anne O'Keefe, MD, Douglas County Health
Department, and Rob Rohrbough,
RSD, Inc.
Download
Paper (PDF, 1MB)
Do you need to provide analysis, reporting, and visualization on data locked
away in a database? The Nebraska Health and Human Services System had just such
a problem that they tried to address with a variety of vehicles including flat
files for spreadsheets and static web applications. The problem was that the
data were not available in usable formats to public health epidemiologists. The
solution for the State of Nebraska is to use SAS/Intrnet software to surface
epidemiological data to a web browser for dynamic analysis. Are you using SAS/Intrnet?
If not, and you are interested, or if you are considering such a project, this
paper will describe the advantages and challenges this system holds.
 Tips and Techniques for PROC MEANS,
Andrew Karp. Sierra Information Services
Download Slides
(PDF, 437KB)
Anyone who needs to use SAS tools to summarize, analyze and report data can
take advantage of the tips and techniques presented in this paper. By attending
this session you will learn about functionalities added to PROC MEANS in
Versions 8 and 9 that make enhance the value of this already powerful procedure.
Among the topics discussed are: 1) easier ways to create multiple output data
sets in a single PROC MEANS “run” with the CHARTYPE option; 2) using the
PRELOADFMT and COMPLETETYPES options to obtain observations in your output data
set where no observations in the input data set have a formatted value of the
given classification variable; 3) using the AUTONAME option to have SAS generate
the names of variables in the output analysis data set; 4) how the IDGROUP
option is used to output extreme observations from in the input data set to
variables in the output data set; 5) using ordering options for classification
variables; and, 6) the TYPES and WAYS statements.
 An Introduction to SAS®
Enterprise Guide 4.1 and SAS Add-In for Microsoft Office 2.1: Bringing the
Power of SAS to Your Desktop, Donna Fulenwider, SAS Institute
Download
Slides (PDF, 1.7MB)
BT
SAS Enterprise Guide and SAS Add-in for Microsoft Office bring the power of SAS
to the desktop. In these easy to use interfaces, you can access, analyze and
report on the data that resides in your organization. SAS Add-In for Microsoft
Office 2.1 gives Microsoft PowerPoint users access to the power of SAS and
allows them to create presentations with refreshable SAS content. SAS data
access support in Microsoft Excel is greatly expanded; users can open SAS data
sources of any size, either directly into worksheets or into PivotTables, and
users can easily create a SAS data set from Microsoft Excel data. This paper
provides an overview of both clients and shows how easy it is to harness the
power of SAS from within familiar environments on your desktop.
 Table Lookups...You
Want Performance?, Rob Rohrbough, RSD, Inc.
Download Paper (PDF, 55KB)
Over the years SAS Software has provided
many ways of accessing data related to a table or file. They range from match
merges, to SQL joins and the use of indices, to formats (yes, formats), to the
hash object. Each serves its own purpose in different contexts. This paper gives
you a review of many of them with examples and syntax, and it will discuss their
advantages and disadvantages. We will look at performance considerations and
discuss the new Hash Object in the Data Step in SAS 9.1.3.
 Working with SAS Date Time
Functions, Andrew Karp, Sierra Information Services
Download
Slides (PDF, 226KB)
BT
This presentation shows you how to get the most out of SAS System tools for
working with variables representing dates and/or times. Designed for the
beginning to intermediate user of SAS Software, this session discusses how SAS
“works” with date and time variables, how to create date and time variables, and
programming functions that are designed to simplify your work. You will also
learn about different approaches to how SAS calculates duration (the number of
time periods between events), the role of SAS Formats with date and time
variables, how SAS INFORMATS are used to create date and time variables from raw
data, and the new ANYDATE Informat added to the SAS System in Version 9.
My
Friend the SAS Format, Andrew Karp, Sierra Information Services
Download Slides
(PDF, 481KB)
BT
This presentation introduces you to the power of SAS Formats (and Informats).
Designed as a tutorial for attendees who are relatively new to the SAS System,
this talk shows you how Formats “work” within the SAS System, formats that are
supplied with SAS Software, and how to create your own using PROC FORMAT. We
will also discuss how to apply both user-created and SAS supplied formats in Data
and Procedure Steps to enhance the visual appeal of your reports and tables, and
how they are used to aggregate, summarize and portray data. The role of
Informats to convert raw data in to variables contained in SAS data sets is also
discussed, along with creating permanent SAS format libraries.
Productivity for SAS Programmers with SAS Enterprise Guide, Donna
Fulenwider
Download Slides (PDF, 462KB)
SAS Enterprise Guide is a boon to SAS
users, especially non-programmers. However, SAS Enterprise Guide 4.1 provides
some powerful features geared toward the SAS programmer, including an integrated
process-flow view of your project; the ability to create, publish, and execute
stored processes; and increased flexibility for output format and destination
with the SAS Output Delivery System (ODS). This paper provides an overview and
detailed examples of how SAS programmers can leverage SAS Enterprise Guide to
create, organize, and execute their SAS programs.
Creating Multi-Sheet Microsoft
Excel® Workbooks with SAS ODS, David Kelley
Download Slides (PDF, 770KB)
This presentation shows you techniques
available in both SAS 8 and SAS 9 Software to produce multisheet files from SAS
output that can be opened by Microsoft Excel. We will discuss approaches
appropriate for both SAS 8 and for SAS 9, as well as across releases of MS
Excel. Although there are many ways to export SAS output in to Excel-readable
tables, the tools and techniques shown in this presentation save you time and
effort required to create the multi-sheet workbooks you need. We will highlight
the MSOFFICE2K and EXCELXP tagsets to create the multi-sheet output files you
need. And, you will see how these tagsets offer features in SAS 9 ODS for
controlling the appearance of your multi-sheet workbooks, including frozen
headers and auto-filters. You will benefit from this presentation regardless of
your current level of experience with the SAS System, and will be able to apply
the techniques presented to your own reporting projects.
Additional papers, tool, tip, & tricks may be
found
|
