HOME QUICK SEARCH AUTHORS KEYWORDS HELP BUGS

SCSUG 2004 Papers - Index

38 papers. Source: SCSUG (South-Central SAS Users Group) conference proceedings.

Back to Conf
go 2005
go 2003
# Title
×		 Authors
×		 Abstract
×		 Keywords
×		 Extras Pages
1 A Complete Guide to HTML Form Output for SAS/IntrNet Developers Don Boudreaux A number of existing conference papers, course notes sect ions, and references can be found that describe the use of HTML form elements within SAS/INTRNET Broker applications. These sources usually provide several examples to illustrate how form element information gets passed into SAS code. Unfortunately, what is typically missing is a complete discussion of all the form elements and detailed description of their output. W hich form elements only generate one name/value pair? Which form element can generate multiple name/value pairs? And, which form element does not pass any information at all? This paper will attempt to "fill the gaps" and discuss ev ery HTML form element. This paper will also describe how HTML form output is processed through the Broker and present an example macro for processing the results. It is assumed t hat the reader is already comfortable with HTML coding, SAS/INTRNET concepts, and macro programming macro variable, missing value, ods html, %if-%then-%else 6
2 A Guide to Understanding Web Application Development Corey Benson,
Robert Girardin		 You have been asked by your manager to port a legacy, fat-client application to the web. There are so many directions you can take in completing this project. It is har d to know where to start and what technologies to use. The main focus of this paper is to introduce y ou to server-side Java. We will answer questions like: What is server-side Java technology? What are servlets, JavaServer Pages and custom tags? What are the benefits of using server-side Java technology? What is the Model-View-Controller(MVC) architecture? What is the Struts framework? What are the benefits of using webAF for Web application development? * How do you customize the look of your Web application? These topics will be covered while also highlighting how SAS AppDev StudioTM 3.0 makes it easier for you to build Web applications that are lightweight, easy to manage and instantly connect to SAS software data cleaning, business intelligence 17
3 A SAS/OR Primer on Using PROC LP Michael E. Salassi Linear programming is a widely used operations research tool in economics and business. It is used to answer such business questions as how to maximize profits from products produced or how to minimize costs of certain business activities given certain constraints. The use of PROC LP in SAS/OR to answer such questions will be presented including the formulation of linear programming, integer programming and mixed-integer programming models. SAS/OR general syntax will be presented, along with a discussion of dense and sparse data format, reduced cost and dual activity, and sensitivity and range analysis. The use of accounting activities and transfer rows will also be presented, illustrating how to model the SAS/OR program to calculate important values of the problem in addition to the objective function value linear programming, proc step, sensitivity analysis, integer programming, phase ii 14
4 An Introduction to ODS for Statistical Graphics in SAS 9.1 Robert N. Rodriguez In SAS 9.1, over two dozen SAS/STAT and SAS/ETS procedures have been modified to use an experimental extension to the Output Delivery System (ODS) that enables them to create statistical graphics as automatically as tables are currently created. This extension, referred to as ODS for Statistical Graphics (ODS Graphics for short), provides commonly used displays, including scatter plots, histograms, box-and- whisker plots, and contour plots, in ODS output. Many ODS features for tables, such as destination statements, apply equally to graphics. ODS styles control the appearance and consistency of all graphs, whereas ODS templates control the layout and details of individual graphs. This paper introduces statistical users and other SAS programmers to ODS Graphics. Examples illustrate basic functionality, which requires minimal syntax, and typical graph management tasks. Familiarity with ODS for tables is assumed graph template language, scatter plot, histogram, proc template 27
5 Basic Pattern Recognition and Digital Image Processing Using SAS/AF Frame Abhishek Lall The pr incipal goal o f patte rn recognition is su pervised o r unsupervised clas sification. The statistical ap proach to patte rn recognition has be en most intensively st udied and use d i n practice. SAS provides a host of procedures and package s tha t one can use to implement basic pattern re cognition ste ps l ike discriminant ana lysis, pr incipal component anal ysis, clus tering etc. This paper presents a G UI built using SAS/AF software that uses all t hese p rocedures an d provides t he u ser a c onvenient way to pe rform the se basic tasks. In add ition, th is it incorporates a fu lly w orking model o f a de cision mak ing software compone nt t hat ha s the capability of differentiating a good shrimp from a b ad one on the basis of their digital images. For spati al data, thi s pape r provides a c onvenient GU I t o the user, to allow a mapping of to map data v alues co ntaining spatial locations proc step, discriminant analysis 7
6 Creating Birth Data Quality Reports: Identifying hospitals that submit high volumes of invalid data using PROC REPORT and ODS Thaer Baroud,
John Senner,
Paul W. Johnson		 The quality and completeness of birth certificate data is essential to public health research, planning and services. State and Federal Maternal and Child health programs utilize birth certificate data to target mothers from particular racial/ethnic and age groups with low utilization of prenatal care or to investigate maternal characteristics associated with low birth weight, prematurity, infant mortality and other unfavorable birth outcomes. Every year, the CDC-National Center for Health Statistics (NCHS) sets up standards of acceptable proportions of invalid data fields reported as not classifiable (i.e., outside predetermined ranges), unknown or blank in birth certificate data. Since the vast majority of birth certificates are collected and submitted by hospitals, the Center for Health Statistics at the Arkansas Department of Health needed a report that can easily identify fields with high proportions of invalid data by hospital of birth proc step, proc report, excel, proc means, proc format, macro variable 12
7 Data Mining and the Use of SAS to Deploy Scoring Rules Neil S. Fleming proc hpsplit, regression analysis, cpu time, proc sql, data mining 13
8 Data Quality and Base SAS Clarence W. Jackson Attaining an d maintaining Da ta Quality shoul d b e a hot i tem o n everyone's to- do l ist. D ata i s a n asset to an or ganization. T he need for accur ate an d co rrect data i s apparent to anyone that use the data for decision making, forecasting, and other uses that depend on the need for accurate information. The impact of bad d ata to or ganizations can be great w hen deci sions ma de b ased on the d ata r esults i n l ost busi ness, unhappy cust omers, l awsuits, and various l evels of or ganizational failures. This paper addresses how SAS ca n help an organization to 1. Understand t he l evel of correctness and acc uracy of their d ata thr u d ata a udits based on t he or ganization's business rules 2. Correct the bad data 3. Keep the data clean data validation rules, proc freq, proc step, sas base, data cleaning 6
9 Designing the Optimal File Linkage Algorithm (OFLA) [ Poster ] Tsai Mei Lin In Mater nal a nd Ch ild H ealth, f ile li nkage is an inc reasingly important too l f or publ ic heal th r esearch, particularly when it in volves link ing birth data to infant death data. Suc cessfully link ing these f iles can lead to im provements in the ef fectiveness and ef ficiency of the deli very of public health s ervices. Sinc e linked files are more valuable than the s um of their parts, much more information is available than th eir constituent dat abases. Unf ortunately, with no c ommon c lean an d uni que identifier, f ile link age is m uch more of an ar t than a science and t ends to in volve highly subjective decisions on how to proceed. T he objective of this study is t o develop m ulti-step algorithms that us e various combinations of variables in order to c orrectly m atch a s m any r ecords as p ossible, while m inimizing f alse matches. T o tes t the strength of each algorithm, linkage results are compared to a "gold standard" file type i error, confusion matrix, sensitivity analysis 14
10 Enterprise Guide: Should it Be Your Everyday SAS Editor? Kevin Davidson Longtime SAS programmers have for years used the SAS Program Editor window and may have recently switched to the Enhanced Editor. Now there is a new kid on the block named Enterprise Guide that may tempt you to switch. This paper will take a look at some of the features of Enterprise Guide (including the new 3.0 release) and compare features against our old SAS editors sas enterprise guide, sas base 7
11 Equipment Data Development Case Study - Bayesian Weibull Analysis Wei Yu This paper describes a statistical study done on a set of equipment failure data from the South Texas Project site. The main assumption in the existing methodology is that the time between failures is distributed as exponential random variable (i.e. constant failure rate) with random parameter that follows Lognormal prior distribution. In addition, the current data collection gathers only the number of failures in a given time period which is sufficient for the estimation procedure due to the exponential failure time assumption. The current study proposes to substitute the constant failure rate with time varying one by modeling the time between failures as Weibull random variable. This requires that we have a different set of failure observations - the actual time between failures rather than the number of failures only. The previous categorization defines unique groups based on their TPNS number and failure mode code histogram, prior probability, weibull distribution, normality test, proc means, excel 43
12 Exploring DICTIONARY Tables and Views Kirk Paul Lafler SAS users can quickly and conveniently obtain useful information about their SAS s ession with a nu mber of r ead- only SAS data v iews c alled DICT IONARY tables or DI CTIONARY v iews. At any tim e dur ing a SAS session, information about currently defined system options, libnames, table names, column names and attributes, formats, indexes, and more can be accessed and captured. This paper will explore the purpose of DICTIONARY tables an d views, how they are acces sed, and w hat infor mation i s a vailable to SAS us ers. Att endees w ill le arn how thes e important tables and views can be applied using real-world code examples dictionary tables, proc sql, sas library, options statement, proc step 6
13 Fishing in Texas with SAS Richard Glenn Willey "Fishing in Texas with SAS" was designed to promote more efficient fishing through observing the feeding patterns of various record sport fish throughout the year over different regions of the state. This project utilized data provided by the Texas Parks and Wildlife Department, as well as the SAS/AF Frame system, and the SAS/EIS system. This paper structures a system, making it very user friendly. This project continues to prove that through statistics the world we live in can be seen more clearly and via SAS/AF Frame and EIS, such insight is greatly simplified for the general user sample, proc freq 4
14 Fraud Detection - A Primer for SAS Programmers Thomas J. Winn Jr. Prevention of fraud and abuse has become a major concern of many organizations. The SAS System includes powerful tools for data management, data analysis, and reporting, which can be used in battling against fraud and abuse. This expository paper will describe some basic methods for detecting possibly fraudulent activities, using Base SAS software. Additional remarks will mention using other SAS software components for fraud detection outlier, sas base, internal audit, proc hpsplit, data mining, neural network, supervised learning, regression analysis, data science 9
15 Grid Computing at Texas Tech University using SAS Ronald H. Bremer,
Jerry Perez,
Philip Smith,
Peter H. Westfall		 sas grid, grid computing, sample, random sampling 9
16 Joining a SAS Dataset With a SQL Table Using Enterprise Guide Gillis Guidry The following paper is offered as an alternative to the "normal" method of joining a SAS dataset with a SQL table using Enterprise Guide. By normal I mean the use of, for example, the task "Create Empty Query". The software versions used were Enterprise Guide v1.3 and v2.0, and Microsoft SQL Server 2000. Whenever used, there was a marked improvement in data retrieval when using the explicit retrieval method rather than the implicit. Problem Users were complaining that Enterprise Guide was taking too long when joining a SAS dataset to a SQL table. Cause When joining a SAS dataset to a SQL database in Enterprise Guide (EG), SAS is using a LIBNAME engine, which is considered an "implicit pass-through". In other words, SAS builds the specific SQL query and passes it to the SQL server on your behalf. EG is able to read the tables in the SQL database (named SQLDB for this paper) through the use of libraries proc sql, sql server, sas enterprise guide, dataset, sas base, implicit sql pass-through, proc step, sql pass-through 6
17 Just for the Kids School Reports: A data-oriented web site powered by SAS Bob Zambarano data wrangling, independent qc, sql server, web service, proc sql, quality assurance, raw data, dataset, regression analysis 14
18 MIS Reporting in the Credit Card Industry Tom Hotard In credit card acquisition campaigns, it is important to have the ability to keep track of various types of counts. After starting a campaign by pre-defining different populations, MIS reporting systems help capture counts as records progress downstream in the process. Sometimes referred to as a waterfall report, MIS reports come in a variety of flavors. This paper will focus on the creation of MIS edit reports. This type of reporting system is used in a campaign to count the reasons why non-survivors are dropped at gross and net levels from within each population. The purpose of this paper is to show how SAS is used to create an MIS edit report for a large credit card issuer, focusing on acquisition campaigns executed in an Oracle database on a UNIX platform. After first showing an example and illustrating an MIS edit report, the major steps toward generating an MIS edit report will be examined macro variable, mp connect, credit card, if-then-else, proc sql, mod, dataset, proc step, management reporting, macro definition 15
19 Power of SAS in the Palm of your hand Zeke Torres Let's take that Palm Pilot of ours, then some inexpensive third party app's matched with SAS and watch what they can all do in t he pal m of our hand! The f eatures t hese elements can provide us literally right out of the box is really amazing. In this paper I will cover some of the basic ones and t hen present an interesting way of c apturing and c ollecting dat a us ing a P DA, analyzing it with SAS ( on the PC) then sharing the results back to the PDA and other individuals service provider, batch processing 1
20 PROC MIGRATE: How to Migrate Your Data and Know You've Done It Right! Diane Olson,
David Wiehle		 Migrating your data to a new version of SAS presents challenges; depending on the attributes of your data libraries, your migration can be relatively simple or complex. Some issues to consider when adopting SAS 9 include the version of SAS in which your data currently resides, what member types exist in your libraries and whether you must move members from 32-bit libraries to 64-bit libraries. To address these issues, SAS 9.1 includes a new utility procedure, PROC MIGRATE. PROC MIGRATE streamlines the process of moving libraries forward to a new release. This paper introduces PROC MIGRATE and discusses pitfalls of migrating with the traditional methods - PROC COPY, PROC CPORT/PROC CIMPORT and PROC CATALOG. Base SAS also provides tools that can help you guarantee the content and attributes of your data after migration. We discuss how PROC DATASETS, PROC CONTENTS and PROC COMPARE are used in validation tools to validate the integrity of your migrated libraries proc step, data cleaning, audit trail, proc compare, constraint, sas 9, sas log, sas output, proc contents, proc sql, sample, libname statement, proc copy, data integrity, sas library, macro definition 17
21 Providing Standardization to DHI (Dairy Herd Improvement) Databases with SAS and using SAS products to deliver user friendly applications. Michael Tomaszewski,
Sandeep Gaudana		 The ability to perform data mining is predicated upon access to similarly calculated variables. Dairy consultants and educators h ave attempted to mine dairy herd improvement (DHI) d ata but ha ve b een faced with la ck o f standardization among t he seve ral da tabases us ed b y d airy produ cers. Using SA S Ba se, we have develop ed techniques to acc ess base data from these dif ferent databases and c alculate critical production indicators using similar algorithms. One of the databa ses is acces sed b y a scheduled SAS pr ogram that automaticall y obtains data from a FTP Serve r. All of this is done without an y us er inte rvention. SAS/ Intrnet applications wer e developed to enable a user to request analysis via web. This paper discusses the steps taken to reach this stage of development and the techniques us ed t o m ake pro grams effi cient. Finally, "Man agement Matrix" - a SAS/INTRNET Application will be discussed dataset, macro variable, data step, ods html, sql server, sample, proc sql 12
22 Ranking Efficiency, Properness with SAS Probability Functions and Procedures Dagan Zhang Computer technology (for hardware and software) makes statistics application not only more and more popular, but also more and more effective. SAS probability functions and procedures make us much freer to use more accurate and reliable statistical concepts and algorithms while trying to improve our business administration. For trying to improve cure efficiency of physicians and judgment properness of officers, two natural parameters for measuring them were introduced, respectively. The parameters, as random variables, have gamma and binomial distributions, respectively. For some physicians (or officers) each, their jobs construct small samples. To rank their job efficiency (or properness), hence, simply comparing values of the natural parameter is not a reliable way. To rank quality (efficiency / properness, etc.) of a same kind of jobs done by a group of people individually, concept MASS, a measure in a same scale of confidence was defined in our work confidence interval, probability functions, sample, gamma distribution, standard deviation, binomial distribution, proc step 8
23 Retaining, Lagging, Leading, and Interleaving Data Toby Dunn Many times a programmer must examine previous and/or future observations. When this occurs, the programmer is generally inclined to search the help docs for pre-defined statements, functions and techniques to create a quick solution to the immediate problem. However, this approach often leaves the programmer a headache, increased frustration and stress, and mistakes in their program. In an attempt to "go beyond the help docs," this paper examines frequently (mis)used techniques. Specifically, it addresses the retain statement and lag function as used to examine previous values, and the lead and interleaving techniques to look ahead at future values. The intent of this paper is not to provide the programmer with a comprehensive examination of these tools, but rather the fundamental understanding of their uses and subtleties required to make them an effective part of the programmer's tool chest retain, lag function, missing value, data step, by group processing, set statement, proc sql 14
24 SAS Add-In for Microsoft Office - Leveraging SAS Throughout the Organization from Microsoft Office Jennifer Bradshaw Clegg,
Stephen McDaniel		 The SAS Add-In for Microsoft Office is a Component Object Model (COM) add-in to Microsoft EXCEL and Microsoft Word. The SAS Add-In for Microsoft Office seamlessly exposes the power of SAS data access, reporting, and analytics directly from the familiar environment of Microsoft Office. This paper discusses the capabilities and features of the SAS Add-In for Microsoft Office 1.3. Refer to Appendix A for a list of features by release excel, sas enterprise guide, sas management console, business intelligence, proc sql, life sciences 15
25 SAS and Multivariate Music: A GUI for Multivariate Analysis of Musical Instrumentation Digital Interface (MIDI) Data Lisa Cannon,
Cecil R. Hallum		 proc freq, proc princomp 11
26 SAS as a Multi-Purpose Tool in the Healthcare Environment Robert Muzny The healthcare industry offers many opportunities to learn about the countless uses of the SAS System. With the varied number of information systems that are used to maintain patient care data, personnel data, and business- decision data, we quickly learn there is a need for a tool that can work between these systems. Business decision makers need their unique pieces of the puzzle combined with others to form a comprehensive view of the picture excel, retain, txt 7
27 SAS Enterprise Guide 3.0 for SAS Programmers - A Roadmap to Combining the Best of Both Worlds Stephen McDaniel,
Annette McDaniel,
Gregory A. Smith		 SAS Enterprise Guide is a powerful Windows client application that provides both a guided mechanism to utilize the power of SAS and a intuitive SAS code development environment. Results can be shared throughout the organization either via the SAS Stored Process Server, SAS IntrNet, the SAS Information Delivery Portal, email, or sending the results to other third party applications such as Microsoft Word or EXCEL. Business analysts, statisticians, and SAS programmers can all use Enterprise Guide to leverage the power of SAS on many platforms enabling them to access data simply and quickly and perform basic reporting and utilize complex analytics such as forecasting and linear modeling. This paper will cover the pertinent areas of SAS Enterprise Guide relevant to developing and managing SAS programs efficiently and effectively sas enterprise guide, clinical research 3
28 SAS Optimization: What's New and What's Next Edward P. Hughes proc step, data validation rules 25
29 SAS Procedure Implementation Annapurna Ravi This paper s hows ho w t o i mplement various p rocedures in SAS with out actually kno wing t he synt ax ( i.e., dynamic SAS p rogramming). I t particularly makes l ife e asy for n on- SAS use rs who act ually kn ow which procedure t o use but don' t hav e complete kno wledge of t he pr ocedure. It shows var ious sc reens (A/F frames ) which have Click and G o capability for different pr ocedures. It helps N on-SAS users to use n umerous p rocedures in SAS more efficiently as they can select the procedure, select the required data set and t hen implement the procedure on th e se lected d ata se t without actually typing in source code. For SAS users, it's a t ime saver if the required number of options is large proc step, sas base 7
30 SAS/ACCESS to External Databases: Wisdom for the Warehouse User Judy Loren With SAS/ACCESS, SAS users can read from and write to almost any database product: DB2, Oracle, Informix, Sybase, MS SQL Server, or Teradata just to name a few. ODBC opens up even more warehouse doors. SAS/ACCESS offers several ways to connect: procs, such as Import and Export; the LIBNAME statement option that treats database tables like SAS datasets; and pass-through, which passes user-written SQL directly to the external product to execute and return the results to SAS. The fun starts when the warehouse tables are too large or too complex to allow the easy approach. This tutorial reviews all the techniques briefly, then focuses on the situations that call for advanced expertise. Examples demonstrate using SAS with DB2, Oracle and Microsoft Access. Important details like how to refer to missing values in various databases, and how to use macros in pass- through SQL, make the tutorial concrete and useful proc sql, dataset, proc step, macro variable, create table, where statement, order by, libname statement, missing value, macro put, error message, out=, automatic macro variable, variable, select, sql pass-through 10
31 Scalable Access to SAS Data Billy Clifford Symmetric multiprocessor (SMP) computers can increase performance by reducing the time required to analyze large volumes of data. Using a new engine in Version 9, large SAS data sets can be partitioned and an I/O stream can be initiated for each processor. W ithin the engine, WHERE expressions are filtered in parallel by assigning a processor to each partition. Outside the engine, SAS applications like Datamining Regression, which uses the DMREG procedure, can initiate parallel I/O paths to the partitions. This new engine is compatible with data sets created by the Scalable Performance Data Server (SPD Server) product dataset, index creation, proc append, libname engine 7
32 Start with SAS with a few quick easy steps Zeke Torres Learn about SAS and bas ic D ata s tep pr ocessing and SAS Procedures. From reading raw data and other SAS datasets to printing, summarizing, reporting, sorting, formats and t abulates. This presentation is ideal for someone who wishes to learn more about SAS and would like a s imple i ntroduction t o i t. The presentation w ill p rovide u sers w ith d ifferent examples of 'projects' or 'problems' that are prac tical to everyday s ituations in a variety of businesses and various ways the SAS system can facilitate solving them proc step, dataset, sas base, proc freq, proc means 4
33 Teacher Evaluations - A tutorial in some advanced features of SAS Glenn Millard excel, put statement, data step, proc step, missing value, macro variable, proc freq, return, macro definition, %if-%then-%else 19
34 The Workhorses of Customized Report Writing - PROC TABULATE and PROC REPORT Deborah B. Buck SAS has a num ber of pr ocedures tha t pr oduce s ummary r eports. T hese can inc lude r eports de veloped f or assistance in da ta c leansing, f or des criptive s tatistics, or for statistical a nalyses ( hypothesis tes ting, m odeling, prediction, etc.) Two of the Base SAS procedures that are very versatile in generating summary reports are PROC TABULATE and PROC REPORT. This paper attempts to introduce you to s ome of the capabilities of both of these procedures and to pr ovide some guidance on which is th e m ore appr opriate f or a g iven n eed. A n ex ample of the out put f rom eac h of thes e procedures and the code that produced it are included. The code presented in this paper is valid for SAS Versions 6-9 proc step, proc report, proc tabulate, sas base, standard deviation 7
35 Undocumented and Hard-to-find SQL Features Kirk Paul Lafler The SQ L Proced ure contains many p owerful an d el egant l anguage f eatures for a dvanced SQ L u sers. This paper presents SQ L top ics that w ill help progr ammers u nlock th e many hidd en feat ures, opti ons, an d other h ard-to-find gems fou nd in t he SQ L un iverse. T opics i nclude CASE l ogic; the CO ALESCE fun ction; SQ L stat ement opt ions _METHOD, _TREE, and other useful options; dictionary tables; automatic macro variables; and performance issues. Finding the First Non-Missing Value The SQ L procedure provides a way to fi nd the first non-missing value in a column or list. Specified in a SELEC T statement, the COALESCE function inspects a column, or in the case of a list scans the arguments from left to right, and returns the first non-missing or non-NULL value. If all values are missing, the result is missing. When co ding the C OALESCE functi on, al l argum ents mu st be of the sa me da ta ty pe proc sql, proc step, macro variable, sas library, missing value 10
36 Using PROC SURVEYMEANS to Analyze A Creel Survey Rebecca G. Frederick,
E. Barry Moser,
George Melancon		 Rockefeller Wildlife Refuge in Gr and Chenier, LA, conducted a 3- year Creel Surve y that had been designed by the D epartment of Ex perimental Statistics. The C reel Survey began in May 1997 and continued on until March of 2000. A multi-stage cluster-sampling scheme was used to survey recreational users of the Refuge. The de sign was modified mid-way through the 3-year survey resulting in 2 sa mpling periods: Period 1 is Ma y, 1997- February, 1998 and Period 2 i s March, 1998 - F ebruary, 2000. The surve y w as st ratified b y year, se ason, and da y t ype, and sampling occurred at 1 of 4 locations with unequal probabilities. Information such as party-size, distance-traveled, hours fished, and numbers in harvest was re corded for each pa rty. Interest is in estimating usage of the refuge by season and year. Additiona l information on the users and the harvest ar e al so desi red. Individual measure ments were combined a nd then ex panded to yield day-level estimates sample, confidence interval, proc step, proc surveymeans, cluster sampling, sample size, sample weight 10
37 Using SAS to Automate Statistical Reports Madhukar Joshi Sherman, Texas Semiconductor Facility ( SFab) of T exas Instruments is t he epitome of "high technology, high volume, and complex" manufacturing operations: over 800 dev ices are made using numerous technologies, equipment types and pr ocessing steps. Near ly 25% of T exas Instruments Inc volume is pr ocessed in t his f acility. T hus, using m anual m ethods is hig hly impractical -- automation of statistical reports and charts is a must. On the other hand, it is not necessary t o em ploy com plex or hig hly sophist icated t ools ( translation: Expensive) to implement automation. T his paper will illustrate how t he tools already included in Base SAS and SAS / G raphs can be used t o f acilitate t he necessary automation. Note: Sk illful use of these tools is at the cor e of a r ecently aw arded Pat ent Aw ard. Specif ically, t his paper w ill illustrate how Data _NULL_, PROC SQL and SAS Macro statements can achieve the automation proc sql, macro variable, put statement, proc step, sample, macro definition, character constant, full join, order by, do loop, sas base, variable, dataset, macro loop 15
38 Using SAS/IntrNet to Generate Data Products from a Database: The SAO Online USAS Guide Kirby L. Cossey,
Olin Davis,
Thomas J. Winn Jr.		 This paper describes how SAS programmers at the Texas State Auditor's Office developed an intranet application to provide auditors and investigators with information derived from a large database containing accounting data for the State of Texas. The Texas State Auditor's Office - Our Context Operating within the legislative branch, the State Auditor's Office (SAO) provides information about the operations of state agencies and universities to legislators, agency management, and the citizens of the State. The goal of the SAO is to actively assist government leaders to create and maintain strong accountability systems that ensure efficient, effective operation of state agencies and universities. At the direction of the Legislative Audit Committee, the State Auditor would conduct an audit or investigation of any entity receiving funds from the state. Unlike many other organizations, the SAO does not "own" the data that are examined using our analytical procedures dataset, sas programmer, proc step, sample, macro variable, excel 13

Back to Conf go 2005 go 2003

This site serves as a convenient hosting location and does not work as a publisher. All copyrights belong to their respective owners.

The information on this site is provided for general reference purposes only. Whilst every effort is made to ensure that the site is up to date and accurate, no warrant, nor any responsibility or liability for, the accuracy or completeness of the content or for any loss which may arise from reliance on information contained in this site is provided. Links to other sites are provided for your convenience but no responsibility or liability for the content of those sites or of any external site which links to this site is accepted. References to any specific commercial product, process, service, or corporation are also for information only, and do not constitute endorsement, recommendation or favoring.

SAS is a registered trademark of SAS Institute Inc. SAS, Statistical Analysis System, and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration.