SCSUG 1998 Papers - Index

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

#	Title ×	Authors ×	Abstract ×	Keywords ×	Pages
1	A Comparison of Techniques for Extracting and Scoring Data from a Teradata Database Using SAS	Randy Rist	This paper compares six (6) of seven (7) Teradata Access Methods using the BTEQ and FASTEXPORT Teradata utilities and the NCR-ODBC drivers in conjunction with SAS `PROC ACCESS`/oDBC. These Teradata Access Methods have been paired with three ways of writing BAS code to extract and score customer data. This study suggests that the worst possible way to extract and score data from the Teradata database is to use the BTEQ utility to write an ASCII flat file, use BAS to re-format the flat file to a BAS data set and then execute a SAS scoring program. On the test data, this approach uses 17 X more storage and 6.2 times more elapse time than the best way tested. The best approach uses FASTEXPORT with a customized OUTMOD exit written in 'C' to write binary data to a unix standard out and the BAS infile statement to read the binary data from the unix standard out file through an unnamed pipe	flat file, teradata access, elapsed time, proc sql, proc step, teradata, data step, order by, format statement	17
2	A Health Care Claims Data Mart: Construction and Exploitation	Marge Scerbo, Stuart B. Levine	Health care claims data are compficated animals. The eccentricities of this data include differences in the types of claims files and the services which populate those files, variations in the type of providers who service the population and the information needed about each type of provider, and finally, the actual populations of health care recipients and all of their individual specifications. Being able to sort through all of this data (and there is usually a lot of it!) and answers queries from insurers, providers, analysts, etc., and other people within your organization can be a real challenge. In the past, the solution was to have people submit requests for one or more programmers to-extract data and run analyses. The problem was twofold: programmers were overwhelmed with requests, and worse, the data and/or analyses requested were not the correct solution to the problem. This paper will highlight how this challenge was met through the dev:elopment of a Data Mart	data mart, dataset	7
3	Advanced Macros	Destiny Corporation (a company)		macro variable, call symput, proc step, symbol table, proc append, proc sql, dataset, if-then-else	9
4	An Overview of Techniques to Introduce External Data Into the SAS System	Andrew T. Kuligowski		input statement, infile statement, character variable, filename statement, proc sql, excel, proc step, column input, list input, variable, dataset, named input, sample, length statement	20
5	CATALOGER: An Application Development Tool to Search, Compare, and Document SAS Catalogs and Data Files	Christopher A. Roper, Michael Gilman	This paper will present an application written entirely in SAS that greatly enhances the developer's ability to develop, compare, and manage SAS catalog entries and datasets. This application has point and click capabilities for printing catalog entries, including images of frame entries and complete descriptions of associated widgets directly into Microsoft Word documents, creating publication quality documentation at the push of a button. The batch printing facility allows for printing of all catalog entries of virtually any type, including Program, Source, SeL, and Slist (including expanded sublists) entries. The text searching facility will search through all text-based entries for character strings and allow point and click access to the locations in any catalog entry containing the text string	catalog entry, catalog, dataset	6
6	Creating SAS Reports from Data Collected Via the Internet Using Microsoft FrontPage 98 Hosted on a PC Running the Microsoft Personal Web Server	David Workman, Richard F. Pless	Robert Workman. Southern Connecticut State University David Workman. Brazil Center, University of Texas at Austin Richard Pless, Independent Consultant, Chicago, IL . The paper describes project designed to collect and analyze data on :fitculty research and scholarship. Forms created with Microsoft FrontPage 98 are used to collect the data. The forms are hosted on a PC running the Microsoft Personal Web Server . Users access the web page containing the forms, enter data, and submit the form. The data submitted is stored on the host PC's hard drive in comma delimited format. SAS is used to create summary reports. SAS procedures used include INFILE with the DSD option. which allows tab-delimited files with consecutive missing values to be read COITectly and system calls to redirect output to the end user's e-mail account. The Application Organizations frequently require employees to report on business related activities	missing value, sample, proc step	10
7	Data Tables: Highlighting Techniques	Christopher A. Roper	Data tables are arguably one of the best looking widgets in SAS. This makes them a popular choice for replacing the venerable Extended Table widget as a selection list, or front end to a data set. The model/viewer paradigm is an extremely flexible tool that gives the Data Table, and it's parent class the Table Editor, an extensive utility across a broad range of applications. Combined with the abundance of methods available to the Data Table class, this widget can add a very nice touch of polish to an application, giving it the professional, fmished appearance a client demands and deserves. This paper will illustrate five scenarios for using highlighting to make the Data Table object more attractive and functional for your information consumers	dataset, filtering	8
8	Data Warehouse: How to Use SAS from Beginning to Almost Ending for Year	Akbar Golmirzaie	The University of Arkansas at Fayetteville first began exploring the development and implementation of data warehousing in November, 1995. In under two years, the Computing Services Department has moved from conceptual modeling, through prototyping, to a working, evolving production system for data storage and retrieval - all at a substantial savings in time, money and resources. Paramount in this endeavor has been the use of SAS'" software. From the system administration tools to those maintaining the secure server, the University of Arkansas development team found in a single software suite what previously had only been available as separate, much more expensive packages. In addition, the new SAS'" ODBC drivers insure that end-users can directly retrieve, massage and report from the now-centralized data with any ODBC-compliant software package, including of course, SAS'" itself	data warehouse, ledger, raw data, dataset	6
9	Data Warehousing Efficiency Techniques with the SAS System	Tony Brown	The successful implementation of a data ware house relies on several key factors, including the ability to deliver clean, consolidated, and accurate information in the most timely and efficient means possible. Previous SUGI data warehouse papers have discussed the data and construction implementation aspects of data warehousing. This paper intends to address techniques for making the performance of the data warehouse as efficient as possible. Most of the concepts presented are not new, but consolidated from several areas as they apply to data warehousing. This paper is intended for a mid-range to advanced audience, and assumes familiarity with general data warehousing principles, and an advanced level of SAS programming knowledge by the reader. Topics covered will include subject-based modeling, indexing techniques for tables, techniques to prevent table joins, efficient query retrieval techniques, table load strategies, and data summarization considerations	proc sql, fact table, dimension table, data merging, star schema, data warehouse, index, data step, proc step, snowflake schema	10
10	Dressing Up Your Version 6 Objects to be Version 7 Components	Glen R. Walker, Tammy L. Gagliano	Version 7 SASlAF" software exploits the SAS Component Object Model (SCOM) Architecture to provide application developers with a rapid application development tool for object oriented applications. All existing applications will continue to run under Version 7 with no changes; however, with minimal work, your legacy classes can be enhanced to fully exploit the new features. In this paper we will discuss the few simple steps you can take to make your existing classes work as SCOM components and what advantages this will bring	error message, data cleaning	7
11	Functions in SAS	Destiny Corporation (a company)		index, character functions, sum, proc step, sample	3
12	Getting Started as an Independent Consultant: Opportunities, Challenges, and Consideration	Deborah B. Buck			2
13	GUI Testing of SAS Software	Dawn Amos, Stuart Austin, JoAnna Longman, Allen Malone, Sue McGrath, Jim McNealy, Natalie Morgan		txt, advanced sas	8
14	How I Learned to Stop Worrying & Love (?) Macros	Ann Stephan		proc step, create table, macro variable, %if-%then-%else, macro definition	6
15	How to Make any SAS program a Macro	Clarence W. Jackson		macro definition, macro facility, sas programmer	4
16	How to Setup a SAS AutoCall Library	Clarence W. Jackson		macro definition, options statement	3
17	HR PLUS: A Customized View on a Generalized Solution	Carolyn Courtney	HR PLUS is a SAS/ AF system developed to meet the following challenge: Take an outdated, but still widely used, mainframe AF system. Salvage the best of that system (which turned out to be the heart of any good SAS system: meaningful data, good data organization, and the basic components of report construction). Renovate and redesign the system for a Windows environment using the latest SAS tools and methods. Expand the power of your customized AF development by linking to the best desktop features of SAS for Windows: viewtable; multi-dimensional report and other EIS objects; the inherent features of catalogs; and information sharing options such as e-mail, HTML, and OIF. Tie it all together in a seamless customized package that is accessible to non programming, non-analytical end users. And, as important as all of the above, keep it fun - for you and your user	sas programming, advanced sas	7
18	Implementing Robust Statistical Calculations for Minimizing the Effect of Outliers	Rona Tracy		standard deviation, outlier	4
19	Introduction to Using PROC TABULATE	Thomas J. Winn Jr.		proc tabulate, proc step, class variable, proc freq, missing value, proc means	11
20	It's Almost the Year 2000 - Should I Panic?	Mike Kalt	This paper addresses the most freguendy asked questions about Year 2000 compliance for the SAS" System. Topics include: Is the SAS System Year 2000 compliant? What should I look for when testing my SAS applications for Year 2000 compliance? What resources are available to test my SAS applications for compliance? Do I need Special licensing in order to do Year 2000 testing? * How do I correct problems in my data and SAS applications? We assume that you have a basic knowledge of the SAS system, and are familiar with general aspects of the "Year 2000 problem"		8
21	JMP Reveals the Truth: Statistics Can Be Fun!	William R. Gjertsen	JMP is an interactive statistical analysis program that promotes the visualization and discovery of important patterns and outliers in your data. It accomplishes this through unique graphics and the dynamic linking of points. JMP's charter is to harness both statistics and graphics together at one time so that data analysis becomes understandable, enjoyable, and even fun! The use of leverage plots, comparison circles, desirability and interaction profIlers, parallel axis graphs, Gabriel bi-plots, the interactive linking of graphs, and the use of exploratory analysis and slider tools will be shown with various examples from science, engineering and fInance	correlation, outlier, standard deviation, sample, data science	10
22	Laboratory Data Management and Reporting	O. M. Little		laboratory data, null hypothesis, clinical trial, nonparametric test, proc freq, response variable, harmean, covariance, outlier	30
23	Making DBRMs More Readable (or Playing With Strings)	Ann Stephan		if-then-else, select	5
24	Moving SAS Information to Microsoft Word/Excel Using DDE	Dana Rafiee, Destiny Corporation (a company)		excel, data step, dataset	15
25	Presentation Quality Graphics with SAS/GRAPH	Keith Cranford	The `SAS/GRAPH` Annotate Facility along with hardware fonts can be used to produce presentation quality graphics that compete with the commonly used Windows-based software packages. This paper will give some guidance in the use of these tools. A brief introduction to the Annotate Facility will be given, and the use of True Type fonts within the SAS System will be illustrated. Also, aspects of publishing these graphs in PDF and GIF formats will be discussed. Tools `SAS/GRAPH` provides several tools for producing presentation quality graphs. Among these are various options in each of the procedures, the Annotate Facility, and hardware fonts (in particular, True Type fonts in the Windows environment). The latter two of these tools will be discussed in this section. The Annotate Facility in the `SAS/GRAPH` product can be used to enhance your graphics. This is accomplished through a data set of instructions to draw lines or figures at defined locations or write text to the `SAS/GRAPH` output	proc step, libname statement	5
26	PROC TABULATE Introduction	Destiny Corporation (a company)		proc tabulate, proc step, label statement	21
27	QUIZZER: A Fun, Fast Paced Game	Christopher A. Roper	Quizzer is a fun, fast paced game in the fonnat of the popular TV game show Jeopardy!. Written entirely using `SAS/AF` with Frames and SCL, this application offers the opportunity to have a little fun while demonstrating the range of capabilities in the SAS system. The questions and answers are all related to the SAS system and are geared to be challenging enough for even the most experienced SAS expert, and yet simple enough for novice SAS users to be able to participate. There are two rounds of twenty-five questions, and a :fmal quizzer round of one question where a team can bet it all. Contestants test their knowledge of SAS in a competitive, yet friendly environment of fair play, and unwittingly may learn a little more about the SAS system in the process. Why A Game? Quizzer was developed to help organizers of SAS related events in generating interest for the event. An event might be a local users group meeting, a training session, or any place SAS professionals might gather		2
28	SAS Data Libraries: V6 to V7 Compatibility	James Holman	This paper presents an overview of backwards and forwards compatibility between Versions 6 and 7 of the SAS System and is intended to be used as a reference in determining what manner of access is allowed. Furthermore, this paper takes into account differences in compatibility between the Base SAS System and when products such as `SAS/CONNECT` and `SAS/SHARE` are used. SAS I/O Services The I/O Services provided by the SAS System are essentially the same in Version 7 as they were in Version 6. The fundamental component of I/O Services is the ability to access a SAS Data Library and its members.	proc step, dataset, proc copy, proc upload, catalog, catalog entry, data step, proc cport, proc download, proc sql, libname statement, proc cimport	8
29	SAS Institute Quality Partners - Who Are They?	Loretta Jo Schlatzer		quality of service, customer satisfaction	6
30	SAS Programming Tips: Using SAS to Automate Third-Party Software	Mark MacMullen	Have you ever used third party software in the environment where your data sets, jobs or procedures are kept? Typically this information is kept in more than one environment, which requires the use of two or three different scan types. Perhaps your data is kept in one environment but you have to run multiple scans to arrive at the end	put statement, sample	7
31	SAS User-Defined Formats	Michel F. Schexnayder	SAS user defined formats provide a tool which can save programming and execution time as well as improve the appearance of output. User defined formats enhance the appearance of reports by substituting intelligible descriptions in place of obscure codes. The `PROC FORMAT` cntlin= option converts a code table into a user defined format. A SAS permanent library is the appropriate place to store user defined formats. With the growth of this format library comes the need to document its contents. This documentation consists of: How can the format be updated? Where did the descriptions come from? When was the format last updated? SAS automatically provides some of the needed documentation. User defined formats can subset a secondary file before sorting and merging with a primary file. A format statement associates formats with variables	proc format, proc step, format statement	7
32	Slug Hunting - Using SAS to Evaluate Your Database Access Strategies in DB2	Kathe Richards		proc sql, dataset, proc step, create table, key	10
33	Sometimes You get What You Want: SAS I/O Enhancements for Version 7	Steve Beatrous, Billy Clifford	This paper presents a high level overview of new database features added to Version 7. Some of the features presented in this overview have been top-vote getters when they appeared on the SASWare Ballot (such as long mixed-case column names and versioning). Some of the new features were added to make the SAS System more of a DBMS (such as integrity constraints). Concatenation SAS libraries and SAS catalogs may be logically combined through library and catalog concatenation. Concatenation provides a tool for esfablishing a search list for locating the information contained in a SAS library or catalog. Library Concatenation Concatenation allows you to reference two or more SAS libraries with a single libref. In Version 6, some platforms, such as-Windows and HP-UX, supported a limited form of library concatenation. The limited support of V6 had several problems: * It allowed only one form of the concatenation syntax -all the levels were specified as quoted physical names	proc step, proc print, constraint, key, foreign key, index, proc append, catalog entry, sas library, proc contents, dataset, options statement	9
34	SQL Basics	Destiny Corporation (a company)		order by, proc step, proc sql, select, proc sort, proc print	5
35	SQL Query Windows Classes: How to Incorporate the SQL Column Expression Builder Class in Custom SAS/AF Applications	Christopher A. Roper	SQL (Structured Query Language) is the standard language used for querying all major databases, including SAPIR3, SYBASE, ORACLE, RED BRICK, DB2, and others. The SAS Query window creates SQL expressions using SAS/ AF Classes that are available to the `SAS/AF` developer. One of these class entries is the· Column Expression Builder Class, QWCLEXPR.CLASS in the SASHELP.SQL catalog. This is the class used by the Query window to build columns in SQL. This class may be called by any `SAS/AF` entry to present the same interface the SAS Query window uses as a column expression builder. This paper will cover what the Column Expression Builder Class is, how to incorporate it into a SAS! AF application, and the nuances of using this class effectively	proc sql, proc step	6
36	SQL Query Windows Classes: How to Incorporate the SQL Where Expression Builder Class in Custom SAS/AF Applications	Christopher A. Roper	SQL (Structured Query Language) is the standard language used for querying all major databases, including SYBASE, ORACLE, RED BRICK, DB2, and others. The SAS Query window creates SQL expressions using SASI AF Classes that are available to the `SAS/AF` developer. One of these class entries is the Where Clause Builder Class, QWWHERE.CLASS in the SASHELP.sQL catalog. This is the class used by the Query window to build SQL where clauses. This class may be called by any SASI AF entry to present the same interface the SAS Query window uses to build where clauses for SQL queries. This paper will cover what the Where Clause Builder Class is, how to incorporate it into a `SAS/AF` application, and the nuances of using this class effectively	where statement, proc sql	6
37	Your BASE Dollars at Work	SAS Institute (a company)	The BASE procedures group (a.k.a. Information Products) at SAS Institute has been hard at work adding new and useful features to the heart of the SAS System. This talk describes this work and uses generic "business oriented" examples to place these features in a context that demonstrates their use in everyday programming. Covered are: General additions to SAS Software that should make the programmers life an easier one. New SUMMARYIT'ABULATE options like percentiles, independent ordering of class variables, and the pre loading of the class-variable space using formats and/or a data sets of desired class level values. The `ODS` statement for producing output data sets and HTMl output from all SAS procedures, High Fidelity Printing and more. `ODS` is an acronym for Output Delivery §ystem. `ODS` specific additions to `PROC REPORT`, `PROC TABULATE` and the `SAS/GRAPH` Procedures. General Improvements SAS Software (finally!) permits table and column names to be up to 32 characters long		10

Back to Conf go 1999 go 1997

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.