HOME
QUICK SEARCH
AUTHORS
KEYWORDS
HELP
BUGSSCSUG 2000 Papers - Index
36 papers. Source: SCSUG (South-Central SAS Users Group) conference proceedings.
| # | Title× | Authors× | Abstract× | Keywords× | Extras | Pages |
|---|---|---|---|---|---|---|
| 1 | A Program to Automatically Convert MS Access Tables to SAS Datasets Using DDE | Rob Workman | infile statement, dataset, proc sql | 14 | ||
| 2 | Advanced Macro Processing | Destiny Corporation (a company) | macro variable, call symput, proc step, symbol table, dataset, proc append, proc sql, if-then-else, macro loop | 9 | ||
| 3 | Advanced SQL Processing | Destiny Corporation (a company) | group by, order by, by group processing, proc step, proc print, select, sas programming, proc sql | 15 | ||
| 4 | Basic Macro Processing | Destiny Corporation (a company) | macro variable, macro definition, macro put, macro facility, macro call, proc step, &variable, automatic macro variable, symbol table, keyword parameter, missing value, macro parameter, %macro parameters, macro quoting function | 6 | ||
| 5 | Basic SQL Processing | Destiny Corporation (a company) | order by, proc step, proc sql, select, where statement, proc print, proc sort | 5 | ||
| 6 | Data Cleaning 101 | Ronald P. Cody | proc step, standard deviation, numeric variable, proc freq, character variable, proc univariate, missing value, put statement, dataset, outlier, sas output, verify, macro variable, adverse events, data step, proc means, proc print, proc rank, data cleaning | 13 | ||
| 7 | Doing More with SAS Using Enterprise Guide | Chris Hemedinger | SAS users allover the wond are taking advantage of the power of the SAS System in new ways through Enterprise Guide. Enterprise Guide is a Windows application designed to work with the SAS System running on any Windows, UNIX or 051390 server. It provides an intuitive user interface to support data access, analysis, and reporting. It also has flexible capabilities for custom SAS programming and automation. This paper describes the major features of Enterprise Guide 1.1 and also provides some hints for how to get the most out of your SAS server via the Enterprise Guide client | sas enterprise guide, excel, proc step | 4 | |
| 8 | Dynamic, Data-Driven, Web-Based Applications to Satisfy an Ever Changing World | Bernard R. Poisson | Today, business and government organizations thrive on information. They are totally dependent on their continued ability to rapidly and efficiently access information in order to function. Remove or reduce the capacity to access needed information and the organization slows to an ebb or worse, stops dead in its tracks. The changing nature of the information required, and the need to leverage costs while at the same time increasing the availability of information, makes the design and coding of applications a progressively more daunting task. Using a few powerful SAS functions and a modest change in design approach, you can create applications capable of satisfying the continually changing information needs of your organization, decrease costs, and increase information availability. Two equally important derived benefits that we can not overlook are those of increased portability of the application, and quick recovery after system failures | sample, poisson distribution | 7 | |
| 9 | Elementary Concepts of the SAS Programming Language | Thomas J. Winn Jr. | proc step, dataset, list input | 12 | ||
| 10 | Estimating Regression Models with Spatially-Correlated Errors Using the MIXED Procedure | Sam Field | The REPEA JED statement in the MIXED procedure offers a wide range of correlation structures for the error term in a mixed model. This paper discusses a subset of these structures applicable to spatial data and demonstrates their use using an example data set. First, the problem of spatial correlation is discussed as it relates to the assumption of independent errors in regression and ANOV A models. Second, a method of identifying the appropriate spatial correlation structure for a set of data is discussed and demonstrated on the example data using the V ARIOGRAM procedure. Third, information from the identification stage is used to estimate a spatial correlation model for the example data using the MIXED procedure. The paper concludes with a discussion of some common methods of comparing alternative models of spatial correlation for a given set of data. The application of these methods is demonstrated using the sample data set |
correlation, proc mixed, covariance, sample, spatial covariance, proc step, restricted maximum likelihood, regression analysis, response variable, anova, residual, fixed effects, covariance structure | 15 | |
| 11 | Extending the Data Warehouse: An Introduction to OLE DB | S. David Riba | Now that you have your data warehoused, how do you share that information with others who need access to it? SAS software provides a variety of tools to access and retrieve data from multidimensional databases (MDDBs). However, MDDBs are not accessible to non-SAS users in your organization. Until now. Starting with Version 7 of the SAS System, OLE DB can be used to access the information stored in SAS MDDBs and CFO Vision FOBs. OLE DB can be used to access the information stored in ANY multidimensional database that is OLE DB compliant. Starting with the release of Windows 2000 Professional, OLE DB will be installed as part of the operating system. In Microsoft Office 2000, all member applications will be OLE DB consumers | data mining, dataset, proc sql, structured data, relational database, excel, sql server | 8 | |
| 12 | General Guidelines for Creating Useful Static HTML Reports | Rick Porter, Jimmy A. DeFoor |
proc step, proc univariate, data step, output delivery system, ods html, proc ttest, file statement, structured data, ods output, dataset, excel | 16 | ||
| 13 | How to Use the DATA Step Debugger | S. David Riba | All SAse programmers, no matter if they are beginners or experienced gurus, share the need to debug their programs. Many techniques have been suggested over the years to solve the problem of debugging DATA STEP logic. Until now SAS programmers have never been able to interactively watch the DATA STEP execute and debug their logic as it executes. Introduced in Release 6.11 of SAS, the DATA STEP Debugger is part of Base SAS software. It is an interactive tool that allows the SAS user the ability to watch and control DATA STEP execution. The DATA STEP Debugger can be used to: .:. watch program logic execute .:. examine variable values as they change .:. repeat program statements .:. jump to other sections of the DATA STEP .:. modify DO loops interactively .:. test for "dead" code .:. give commands <- observe the results interactively The DATA STEP Debugger is a very useful tool, whether you are a Beginning SAS Programmer or a SAS veteran |
sas log, sas base, options statement, data step, macro variable, if-then-else, end, macro definition | 9 | |
| 14 | Introduction to the SAS Macro Language | Thomas J. Winn Jr. | macro variable, macro facility, macro definition | 19 | ||
| 15 | Many-to-Many Matching Using the Inner Join | Thomas J. Winn Jr. | inner join, merge statement | 3 | ||
| 16 | Mass Produced Web Pages | Michel F. Schexnayder | macro variable, proc tabulate, proc step, ods html, %if-%then-%else, macro definition | 7 | ||
| 17 | Merge Processing - Alternative Table Lookup Techniques | Destiny Corporation (a company) | This tutorial is designed to show you several techniques available for pulling together multiple sets of data for the purpose of combining or comparing their values | proc step, macro variable, data step, lookup, array, by group processing, merge statement, pdv, modify statement, proc print, proc sql, format statement | 7 | |
| 18 | Methods of Reporting Via the Web Using SAS.IntrNet | Kevin Davidson | Kevin Davidson FSD Data Services, Inc. This paper will discuss various methods of presenting and formatting data using SASlIntrNet software. Versions 6, 7 and 8 of SAS software provide an increasing array of options for creating output. Topics to be covered include the traditional DATA STEP, the use of the Output Delivery System (ODS) with standard SAS software procedures, SAS/GRAPH software output, the Xplore application, and the SASIMDDB Report Viewer. Examples are presented which show how to extend your normal SAS software· reporting code into dynamic web applications that can be run by anyone with a web browser |
proc step, proc report, output delivery system, sample, sas log | 10 | |
| 19 | Motorola's Engineering Data Analysis System: 10 Years of Analytical Excellence | C. Michael Whitney, Leslie Fowler |
In an effort to improve semiconductor product yields, an engineering data analysis application was developed in 1989 for engineers at Motorola's Advanced Products Research and Development Laboratory (APRDL). This application was called EDAS -The Engineering Data Analysis System. What began as a small text-based tool providing a handful of statistical reports used in one laboratory has grown to a large graphical system providing over 55 different analytical tools, used globally in Motorola's wafer fabrication plants and final manufacturing sites. The SAS system has been used as the basis of the EDAS system throughout its ten-year history. Whenever SAS Institute releases a new version of the SAS system, EDAS is upgraded to take advantage of those new features. Currently, the Analysis & Reporting Tools team is evaluating SAS version 8 to determine which new features can be utilized in the next major release of | proc means, correlation, anova, regression analysis, data science | 7 | |
| 20 | Multi-Level Intervention Study Data and PROC MIXED | Tom Bohman | proc mixed, proc step, covariance, fixed effects, repeated measures model, estimate, repeated measures, residual, main effect, likelihood function, compound symmetry, power analysis | 13 | ||
| 21 | On Paths Less Trodden: Excursions in SAS/GRAPH and PROC TABULATE | Aaron J. Rabushka | proc step, proc tabulate, proc greplay | 6 | ||
| 22 | Patterns for Producing Web-Enabled Applications | Dave Naden | sample, output delivery system | 10 | ||
| 23 | People Smarts for Career Growth | Judith F. Loren | People Smarts for Career Growth Judith F. Loren L. L. Bean, Inc. It is a rare career in which success does not depend primarily on your ability to work with people. You may have to serve them, lead them, convince them, teach them, get their cooperation or at the very least sell yourself or your product to them. The more you understand about how people differ and what makes each of us tick (or in some cases, tock), the better choices you will make about career opportunities available to you, and the more productive you will be in the jobs you do undertake. This paper gives you concrete suggestions for understanding your own strengths and weaknesses and working with various types of people. Written by a career SAS programmer, it focuses in particular on situations people in SA5-related fields might encounter | excel, sas programmer | 24 | |
| 24 | PROC TRANSPOSE: Making Data Easier to Process | Jimmy A. DeFoor | proc step, proc transpose, by group processing, proc print, proc univariate, length statement, numeric variable, automatic variable, macro definition | 12 | ||
| 25 | Programming for Job Security Revisted: Even More Tips and Techniques to Maximize Your Indispensability | Arthur L. Carpenter, Tony Payne |
A great deal has been said about programming techniques for efficiency and maintainability of SAS programs. We are taught to write code that minimizes machine and programmer resources. Unfortunately, easily maintained code requires fewer programmers, and fewer programmers means pink slips and less job security. In these troubled times, programmers need to be able to maximize their indispensability. Programmers can increase their job security and thereby protect themselves and their families by applying the tips and techniques discussed within this paper. The programmer will be advised when to apply the techniques, and whether the use of the techniques should be subtle or gross. Techniques will cover programming style, editing style, statements to use and avoid, and naming conventions. You will learn to blur data steps, make non-assigning assignment statements, and in general write code that not even you will be able to figure out how or why it works | job security, options statement, proc step, drop statement, set statement, label statement, macro definition, by group processing, macro variable, macro quoting function | 15 | |
| 26 | Providing Access to a Data Warehouse Using SAS/IntrNet and the SAS MDDB Report Viewer | Phil Rhodes | Providing timely and accurate information is the primary function of the Office of Institutional Research and Testing at Baylor University. With the advent of the Web, putting that information at fingertips of administrators and decision-makers is easier than ever before. Using The SAS system, a web-based Enterprise Information System was developed to allow University decision makers to evaluate various programs and academic departments over time. This system serves as the access point into the University data warehouse, and includes graphical and tabular reports with drilldown and reachthrough capability into individual student records. The only requirement on the client side is a web browser, with Java required to view the interactive graphics. The presentation will include a discussion of the requirements and implementation phases of the systems, as well as a demonstration | data mart, excel | 4 | |
| 27 | Reading and Writing Data from Microsoft Excel/Word Using DDE | Destiny Corporation (a company) | excel, data step, dataset, filename statement | 6 | ||
| 28 | Repeated-Measures Analysis and PROC MIXED | Shana Smith, Torsten B. Neilands |
Seasoned users of SAS PROC GLM enjoy the use of a powerful tool for repeated measures analysis of variance; yet SAS Institute's more modem MIXED procedure offers several advantages to the data analyst in comparison to the GLM procedure. First, PROC MIXED allows all available data points to be utilized by the investigator, resulting in improved statistical inference and greater power to detect statistical differences for within-subjects effects. Second, PROC MIXED allows users to specify their own variance-covariance matrices, thereby sidestepping restrictive PROC GLM sphericity assumptions. In addition, contrast coding, which enables comparisons across within- and between-subjects effects, is often complex and sometimes impossible in the GLM procedure. The MIXED procedure allows the data analyst to specify all contrasts in a more straightforward manner |
proc mixed, proc genmod, covariance, proc step, main effect, missing value, proc glm, covariance structure, repeated measures, anova, response variable, longitudinal data, degrees of freedom, repeated measures anova, interaction effect, unstructured covariance | 17 | |
| 29 | Running SAS Applications on the Web | Destiny Corporation (a company) | sample | 4 | ||
| 30 | SAS Version 8 Interface | Destiny Corporation (a company) | proc step, proc export, dataset | 41 | ||
| 31 | Selecting a Data Warehouse Architecture | David S. Septoff, Kevin Simmons |
Data Warehouse projects have provided end-users with extraordinary returns on investment. Maintaining those extraordinary returns requires an architecture that is robust, flexible and scalable. Careful thought must be given to the selection of the data warehouse and decision-support architecture. A mistake in this area often leads to the deployment of an application that cannot provide long-term support for the data and analytical needs of the end-user community. Selecting the most appropriate architecture requires examination of a number of factors. Some of those factors are rooted in technical constraints, while others are rooted in how end-users are organized. There are also political issues that must be noted during selection of the architecture. The first step in selecting an architecture is to understand your decision-support needs. The second step is to understand the available architectures | data warehouse, data mart | 8 | |
| 32 | Standardizing SAS Code for Quality Programs | Clarence W. Jackson | sas programming, pointer control | 14 | ||
| 33 | The Use of PROC MIXED for Analyzing Cohort-Sequential Designs | C. Nathan Marti | proc mixed, proc step, missing value, response variable, predictor variable, main effect, regression analysis, covariance, nominal variable | 11 | ||
| 34 | U. S. Air Force Has New IDEAS for Information Delivery | Eddie Stevens, Mary G. Crissey |
odds ratio, cpu time | 8 | ||
| 35 | Using JMP Version 4 for Time Series Analysis | William R. Gjertsen | Three examples of time series will be illustrated. One is the classical airline passenger demand data with definite seasonal variation. The other two will be daily closi ng price data from a steady growth series (CSCO) and an accelerated growth series (CIEN) | time series analysis, confidence interval, density plot | 10 | |
| 36 | Web-Enabling EIS Applications: Take 2 | David B. Horne, Donald J. Henderson, Vincent DelGobbo |
This paper provides an overview of the issues involved in moving applications from the SAS desktop environment to a browser based Web environment. BAS has a variety of tools that can be used to build new Web-based applications as well to assist customers migrate their existing applications to the Web. The paper describes which tools and approaches are best suited to particular types of SASIEIS and SASlAF software applications. Issues to consider in determining the suitability of converting a desktop AFIEIS application to the Web are discussed in the context of criteria which can help the user to determine what tools and methodologies which are available from SAS are appropriate. NOTE: The Web has had a tremendous impact on the time involved in delivering new software technology. At the time this paper was written (early January 1999) it accurately reflected SAS's plans in this area | sample, output delivery system | 8 |
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.