SCSUG 1995 Papers - Index

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

#	Title ×	Authors ×	Abstract ×	Keywords ×	Pages
1	A Macro for Displaying Correlation Matrices	Diana L. Urbauer, Stephen I. Black	Pearson correlations are often used to examine the linear association between two variables. In addition to knowing the magnitude of the association, researchers are interested in whether the obtained correlations are statistically different from zero, meaning that a relationship probably does exist and that the correlations were not generated by chance. When measuring the association of several variables together, a correlation matrix is created which displays the correlations for all pairings of variables. This poster presents code which will produce a correlation matrix that is easy to interpret and concisely displays the Pearson correlations while flagging those that are statistically significant at both the a = 0.05 and a = 0.01 levels	correlation, proc corr, proc step, pearson correlation, label statement, macro variable, %if-%then-%else	23
2	Advanced Analysis of Stock Prices Using the CRSP Tapes and SAS: Protocols for Both Academic Research and Classroom Use	Glenn Millard, Garland Simmons	Analysis of stock price data made available by the Center for Research in Security Prices (CRSP) is conducted using SAS to write computer code which permits the extraction and statistical analysis of NYSE and AMEX listed common stock returns. These programs use advanced features of SAS version 6.08 such as random access of indexed datasets to provide error checking and information for output. Care has been taken in the estimation of Alpha and Beta statistics to address problems of autocorrelation which may be present when working with a time series of daily returns	missing value, time series analysis, index	20
3	Building a Graphical Network Analysis System Using SAS/EIS	Mahdi Al-Haery		raw data, quality of service	7
4	Creating a Dynamic Menuing System Using SAS Frames	Dee Burgett	The main menu is probably the single most important application in a company. If it doesn't work. nothing works. Therefore, it is important to design a menuing system that can keep up with the company's changing needs. This paper addresses creating a menuing system that personalizes for each user, uses only one SAS frame, and doesn't require a copy of each user. This menu uses a "shell" frame that dynamically populates the icons with bitmaps, title, and call reference, based on data from a SAS data set. Access to an application is checked by allocating a `LIBNAME` set by security. The menu is controlled by SQL. Statistics are stored for user tracking. It uses flags to generate (more) and (goback) buttons. The menu is recursive with no nesting involved. This system also checks for application availability	sysrc, libname statement	11
5	Data Entry and Data Transform Errors -- What They Are, How to Prevent Them, and How to Correct Them	Iris McPherson	The different methods for entering. uploading. downloading. and ftping the data to different platforms create a whole new set of problems for the SAS programmer. The data is entered in one form. but by the time it finally arrives at the machine where it will be used by SAS the characteristics of the file may have changed or the data may have been altered. Basing your INPUT statement on what the data looked like at its source can be disastrous. The first step in avoiding such problems is being aware that the potential for problems exists. Next the data and the file charactertstics should be carefully examined. Once any problems are identified. use SAS options and functions and host commands available to get the data in a usable form again. The final step in this process. and one that you should always remember. even when no problem appears to exist. is to check the data after it has been read by the SAS program to make sure it has been read correctly	infile statement, input statement, sas log, missing value, character variable, list input, txt, data step, proc print, dataset	10
6	Desktop Publishing with SAS and WordPerfect	Christopher Toppe	Let's face it: any report produced in the fixed space Courier font looks amateurish. And we all know that SAS output loves Courier and hates Times Roman or any other proportional, desktop publishing font. But that doesn't mean that you have to be the only one in your office who produces ugly reports. It is possible to create WordPerfect documents within SAS -- to imbed WordPerfect control codes for attributes like centering, bolding, underlining, and especially tabs. This allows you to go directly from SAS to WordPerfect, with all the desktop publishing capabilities of WordPerfect available for that SAS created document. The Secrets Creating a WordPerfect document from SAS is really straight forward once you know the secrets. They are listed below. * Start with a blank WordPerfect document A blank WordPerfect document is not empty. It contains all sorts of useful information in the header portion of the file	proc step, proc printto, sas output	8
7	Estimating Ultimate Losses for Claims With Long Tail by SAS Program Based Upon Loss Development Factor Method	Dagan Zhang		format statement, loss development factor, age-to-age factor, claims development, ultimate loss	21
8	Getting Subtotals and Percentages: It's Never Been So Easy	Christopher Toppe	Getting subtotals and percentages onto a database has always been one of the curses of working with SASiI> data. The most common techniques are neither easy to conceptualize nor easy to program. Sorting your data and using FIRST. and LAST. variables is perhaps the standard brute-force programming methodology that we all have learned to use and come to hate. Using `PROC MEANS` (or `PROC`	proc sql, group by, proc step, by group processing, proc means, create table, sas base, dataset, variable list	6
9	How to Write SAS Code Which is Efficient and Easy to Maintain	Thomas J. Winn Jr.		proc step, sas programmer	7
10	Market Research Using SAS/AF	James F. Moore		where statement, data step	22
11	Nested Procedures Loops: Yes! They Exist & Flourish!	Linda C. Rowland	Utilizing the power of nested do loops for variable assignments, has always been a recognized option. However, the real power, use, and benefit of a nested loop is generated when `PROC` statements are a part of the repetitive function. Placing PROCs within nested loops requires the use of macros. The minor inconvenience macro progrannning may create is insignificant when compared to the tremendous advantage of addressing repetitive progrannning within a loop. Applications of this type of coding are infinite and encompass all fields of discipline	proc step, do loop	3
12	New Electronic Services Offered by SAS Institute's Technical Support Division	Mason B. Nichols	The Teclmical Suppon Division now offers two new electronic suppon services available to SAS software installations. These two new features, in addition to the other electronic services announced at SUG! 17, offer a full range of electronic suppon services. The new electronic suppon services available are: SAS Notes E-mail server SAS Institute World Wide Web Site The other electronic services introduced at SUGI 17 are: * SAS Institute Bulletin Board Systems		7
13	Nine Cell Laboratory Tables	O. M. Little		laboratory data, clinical trial	23
14	ODBC: Windows to the Outside World	S. David Riba, Elisabeth A. Riba		proc sql, excel	10
15	OLE and the SAS System for Windows Release 6.11	Jennifer Bradshaw Clegg	This paper describes the support for OLE (object linking and embedding) provided in the SAS System for Windows Release 6.11. Features include support for em bedded and linked objects, drag and drop, visual editing, OLE automation, and OLE controls. OLE support within the SAS System is available in SAS/ AF@ FRAME entries and SASIEIS@ applica tions	excel, catalog	9
16	Portable SOPs for Contract SAS Programmers and Consultants	Bill Calvert	As a consultant SAS programmer/consultant one can encounter a wide range of conditions. From one place to the next, there may be very little similarity in the standards and fashions of getting the work done. To go beyond technical competence with SAS software to attain functional expertise, consider adopting a set of portable Standard Operating Procedures (SOPs). SOPs are good for everyone, but they are critical for temporary workers. Some basic SOPs and related data management concepts are presented considering the needs of temporary workers (and those who work with consultant help). Strategies for implementation of portable SOPs are described to help overcome some common problems temporary workers may encounter. Additionally, the need to maintain flexibility in your SOPs and adjust to the local resource profile is discussed. With the ideas and suggestions presented here, you will be better equipped to promote improved data management wherever you find yourself	data governance, data cleaning	6
17	Remote and Open Access to Enterprise Data: Enhanced Distributed Data Access Through Multiple Engine Architecture	Jack Wallace, Michael D. Jones	Access to data from the SAS· System Is constantly being expanded and enhanced: Transparent access to remote data Is now ava/lable when the local and remote machines have different erchltectures. And another new feature opens access to SAS data to applications that utilize the OOBC API. such as Microsoft Word. These new features are built on a modular system architecture that often provides more than one way to accomplish a given distributed data access task. To choose the best method. It Is advantageous to understand the proosssing performed by the components of Multiple Engine Architecture. Future enhancements for remote and open data access are also dependent on this architecture. this paper Introduces the new features but concentratas on the architecture and Ifs Implementation. If you simply want to know how to use the features, read the IntroducUon and selected references at the end of this paper. If your Interest extends to optimizations and proossslng details	dataset, proc sql, where statement, sysdate9, select, by group processing, proc step	10
18	SAS Tips	Philip A. Mason		proc step, temporary dataset, proc freq	14
19	The Making of a SAS/AF Programmer	John T. Stokes		sas base, sas programmer	4
20	The SAS System and Data Exchange	Clarence W. Jackson	The purpose of this paper is to describe one use of the SAS System as a Data Exchange tool at the City of Dallas. For this paper, Data Exchange defined as the process of moving digitized data from one computer platform or application to another. This paper will briefly review some of the reasons data exchanges between Mainframe and Personal Computer applications are needed, and some tools in use today to facilitate data exchanges. Data transfer tools between the PC and mainframe, OLE (object linking and/or embedding), DOE (Dynamic Data Exchange), and ODBC (Open Data Base Connectivity) will be discussed. Also, an example using a SAS server application under OS/2 DOE link to create a spreadsheet in a Lotus 123 for Windows client application will be reviewed	data warehouse, proc step	10
21	The SAS System Client/Server Products and Solutions for the VSE Operating System	Paul Mortensen	Today's market offers customers many client/server products and options. The client/server product or model that will satisfy one application is not necessarily a good choice for your next set of client/server needs. What is needed is a product with strong client/server support and the flexibility to meet the varied needs oftoday's client/server applications and users. The aVailability of `SAS/CONNECR` and `SAS/SHARE` for. Release 6.08 of the SAS System for the VSFJESA operating system provides VSE sites a flexible and powerful client/server tool set. Why Client/Serve? With more Information System departments supporting multiple computing platforms with different machine architectures and data fonnats. and an increasing need by applications to access and process data regardless of location, the demand for client/server computing is growing fast. * The Gartner Group derIDes client/server as "one process requesting services or data from another process running on a seperate machine"	traffic data, batch job	9
22	The SAS System: A Complete Client/Server Solution	Cheryl A. Garner, Stephanie Reinard			12
23	The Use of PROC ARIMA to Test An Intervention Effect	Neil S. Fleming		proc step, moving average	4
24	Use of SAS Code to Control TSO Batch JCL	Mohammed Abdulmujeeb		sysrc, batch job	7
25	Using SAS/PC for Higher Order Factor Analysis in Research	William L. Johnson, Annabel M. Johnson		factor analysis, factor loading, correlation, sample	10

Back to Conf go 1996 go 1994

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.