SEUGI 1997 Papers - Index

131 papers. Source: SEUGI (SAS European Users Group International) conference proceedings.

#	Title ×	Authors ×	Abstract ×	Keywords ×	Extras	Pages
1	%SUPLANA - a powerful SAS macro routine for survival analysis	Angelo Tinazzi, Valter Torri	The importance of survival analysis has increased due to its capability to synthetically describe the story of one or more study groups. Basic methodology of survival analysis is presented and a SAS macro routine for its implementation, %SUPLANA, is described. %SUPLANA has been developed for producing survival cumulative plots using several methods such as crude (Product-Limit or Life-table), adjusted for imbalances in prognostic factors (Proportional Hazard and Stratified methods), time-depending covariates and competitive risks. Special features of %SUPLANA are: graphical display of the curves with other essential information, such as statistical tests (i.e. Log-Rank), n. of patients at risk (and events) in each interval time, and several other options in order to obtain a clear representation of the survival story of certain groups of observation. Simple examples to illustrate the use of the program are also given	survival analysis, overall survival, rank test, kaplan-meier plot, proc step, proc phreg, sample	source	6
2	1998 - liberalisation in the telecommunications industry	Richard King			source	13
3	A bank warehouse including a "customer mirror": getting information about customer and product profitability	Jaroslaw Remesz		output delivery system, sample, customer profitability	source	19
4	A branch management information system at Kredietbank: using rapid MDDB implementation and exploitation	Francis Steelandt, Philippe Beyé		sas analyst, mis, proc tabulate, call execute, flat file, management reporting, excel	source	32
5	A branch management information system at Kredietbank: using rapid MDDB implementation and exploitation	Francis Steelandt, Philippe Beyé			source	11
6	A customer MIS in banking	Dominique Rudin		data warehouse, data mining, batch processing	source	18
7	A customer profitability application for the board of managers	Christophe Baudet		customer profitability, sas consultant, output delivery system, excel	source	13
8	A data management system for use in the pharmaceutical and biotechnology Industries	Ellen Krantz		numeric variable, proc compare, proc step, data governance, character variable, audit trail, adverse events, clinical trial, data validation rules, flat file, missing value	source	12
9	A flexible menu-driven distributed database for micro data: from mainframe-via PC-to World Wide Web	Anders Kraftling, Jan-Erik Tomth, Lars Johnsson		sample, dataset	source	8
10	A genetic algorithm for improving a priori variables partition for risk segmentation in third party liability insurance	Alberto Busetto, Andrea Costa	A careful assessment of the risk covered by the insurer in Motor Third Party Liability insurance is a primary competitive factor. Actually, rating structures are heavily based on these risk estimates and, as a consequence, a bad portfolio risk segmentation may imply a bad premiums attribution. Unfortunately, there is at present a big number of variables involved in personalized premium calculation, and the number of possible combinations between class levels often exceeds some millions. For these reasons the insurers frequently reclassify the variables, summarizing them for easily manage their portfolio risks. However, the reclassification of variables affects the estimation of these heterogeneous risks and the adopted criterion should take into account all the interactions between the variables, while reducing the dimensionality of the problem (in statistical language it means a "multivariate" criterion)	portfolio risk, interval variable	source	8
11	A multi-level logical drill down application based on trend data output from PROC GLM	Nya Murray		where statement, proc glm, proc genmod, proc step, transaction data, dataset	source	3
12	A real reporting system to senior management in telecommunications using a data warehouse	Ivano Dei Giudici, Marco Carlettino		reporting, proc download	source	5
13	A system for managing economic databases	Helena Pompushko		time series analysis, balance, current account, proc freq	source	6
14	A web-centric info centre on the Alcatel intranet using ITSV (IT Service Vision)	Geert Buyse	The presentation gives a concrete solution to the I/S service information needs of our clients, I/S management and technical staff. In former days Alcatel Bell had a mainframe-oriented CA-MICS environ- ment for processing raw measurement data with a limited reporting facility to our I/S management and our clients. Two years ago we started the migration from CA-MICS to a more open & distributed `SAS/IT` Service Vision environment. Besides mainframe info we also wanted to include information about Internet usage, Ethernet and LANs, Unix servers and I/S quality indicators. Our goal was to gather these information needs, to develop a practical tool very rapidly and to automatically present that information in a timely manner without new investments in soft- and/or hardware for our audience	excel, sas base	source	4
15	An application and visualization tool for the exploratory analysis of lifetime data	Hans-Peter Altenburg, Thomas Floren	Many studies in clinical and experimental research have as main objective criterion the survival time or in general the time until a pregiven event occurs. A mayor problem thereby is that the corresponding variable time duration cannot be observed exactly, the data are censored. From a theoretical viewpoint is the main objective criterion the survival function, which can be written in the simple case of uncensored observations as 1- F(t), if the underlying distribution function is F(t). We describe the development of an exploratory analysis tool for visualization and analysis of studies with life time data according to different targets. The methods we use can be divided in two main classes, parametric methods and nonparametric methods . The parametric methods are analyzed using the SAS `PROCEDURE LIFEREG`, whereas nonparametric ways of analysis use the procedures LIFETEST (product limit estimator) or PHREG (proportional hazard / Cox regressions model)	survival function, hazard function, proc phreg, data science, survival analysis, right censoring, regression analysis, sample, censoring, cumulative hazard	source	6
16	An application by for the multidimensional analysis of insurance premiums	E. Richieri, Massimo Biancotto, S. S.Trivellato	The application allows for an interactive and multidimensional analysis of data relating to written insurance premiums not cashed. The project was carried out in Assicurazioni Generali. The programme was designed for the Control Department, National Head Offices and Regional Offices. The project used `SAS/EIS` Motore in a PC- Windows environment and in the Client/Server function. The programme uses a distributed SAS Data Warehouse (Mainframe / Unix Server and PC), which contains information on arrears from the Generali Control Department's present database. The Data Warehouse information is calculated using detailed data groups for the most important company features, such as organization and product type. As a result the user can produce the following: - numerical tables, - graphs, - Boston Matrices, - print-outs, - export to spreadsheets. Starting Menu	data mart, dataset	source	4
17	An atlas of mortality in Europe	Bennie Bloemberg, Gerda Doornbos		data wrangling, proc step	source	3
18	An integrated approach to validation of clinical data using SAS software	Mike Thomson		data cleaning, data dictionary	source	5
19	An internet information counter	Luciano Cococcia	The task of the person who has to consent the access to the statistic data doesn't concern only the quantitative aspect of the information but it also aims to improve the quality of the data to make them more utilizable by the users. This involves the identification of the cognitive demands of the users and the conforming of statistic production to such demands. It's necessary , then, to create an immediate relation with the users. This is the aim of the plan of Abruzzo Region that foresees the opening of a statistic multi- functional counter. Within it an interactive telematic counter has been realized, that can be reached by internet to obtain statistic information about regional data	sas base, macro facility	source	8
20	An intranet approach to generating, distributing and managing metadata using SAS software	Kristien Smets, Tom Tollenaere		interest rate, quality control, data warehouse	source	10
21	Analysing a bank's data using OLAP	Eva Mièovská		ledger, bank transaction, data science, dataset	source	12
22	Analysing the incidence of Leukaemia in England and Wales	David Rowland, Deborah Allon, Paul Nicholson, Richard McNally	The term 'Leukaemia', from a Greek word meaning 'white blood', describes a group of diseases arising from the formation of abnormal blood cells. The causes of the majority of cases of leukaemia remain unknown. However, it is thought that leukaemias may be triggered by 'risk factors' such as exposure to certain chemicals and exposure to radiation. Also, although these diseases are closely related, each has its own characteristics and considerable variation is exhibited in the incidence of the diseases in different age-groups, sexes and geographic regions. Epidemiologists believe that the study of these patterns of variation could provide clues to further the search for causes of the various leukaemias. This paper describes an application being developed, in collaboration with the Leukaemia Research Fund Centre for Clinical Epidemiology at Leeds, for the management, analysis and display of data relating to the incidence of leukaemia in England and Wales	poisson distribution, relative risk, proc step, regression analysis, proc genmod, proc mixed	source	9
23	Analytical information system for accident monitoring at the Russian transport	Andrey Grishel, Tatiana Voinova		by group processing, data wrangling, excel, traffic data, raw data, output delivery system	source	40
24	Applications development tools	Christoph Sporleder			source	11
25	AWACS flight data - NATO surveillance, using a warehouse and graphics to visualise flight data	Dario Nicolella, G.P.W van Tol		data science, proc freq, data cleaning	source	12
26	Behavioural analysis of retail customers at Banca Commerciale Italiana	Flavio Addolorato, Luca Bodio	The objective of this work is to test the use of several analytical instruments ("data mining") in order to pinpoint some of the behavioural characteristics of the bank's retail clientele. Definition of Sample The sample was constructed in accordance with two stratification variables: the combinations of products held by retail customers ("Current Accounts", "Savings Passbooks / Certificates of Deposit", "Loans" and "Investments"), and their distribution over five geographic areas. The data were sourced from the relative product files. We then reclassified the data on the basis of a "client-physical person" logic, with the use of the General Customer Number (GCN) assigned to each customer. In the case of joint account relationships, we opted to duplicate the products utilized for each of the individual GCNs involved, treating each GCN as an individual customer. The following files were considered: Customer information (	current account, sample, savings account, credit card, cluster analysis, balance, proc freq	source	10
27	BMW (SA)-Where modelling for motoring is sensational with SAS!	Lize-Marie Verhoef, Ria Pretorius		data science, proc reg	source	17
28	Business-oriented management of service environments	Reint van der Torn			source	18
29	Challenge your business processes with SAS software tools	Pål Navestad		predictor variable, anova	source	4
30	Client/server solutions in data warehouse applications	Attila Papp, Zoltán Németh		traffic data, data warehouse	source	6
31	Comparison between different methods to estimate orders in ARIMA models	Dominique LADIRAY, Michel Grun-Rehomme	It is usually difficult to determine the values of p and q for the stationnary autoregressive moving average ARMA(p,q) models. Considerable progress over the last few years has been made in order estimation problems in time series analysis, several approaches and criteria have been proposed. In the eighties, two methods have been development for the identification of a model ARMA(p,q) : the corner method ([1]) and the triangle method ([8]). These two methods use the autocorrelation function. The corner method define a determinant with the autocorrelations and present an algorithm for determining simultaneously the order p and q. With the triangle method for the ARMA models, an iterative regression procedure is applied to produce consistent estimates of the autotregressive parameters. An extended sample autocorrelation function based on these consistent estimates is then defined and used for order determination	time series analysis, sample, macro definition, moving average, regression analysis	source	11
32	Construction of a consumer confidence index with the X11 Procedure from SAS/ETS	Hans Bay		time series analysis, sample	source	4
33	Controlling information delivery: A strategy for IT infrastructure	Peter J. Jansen		management reporting, mis	source	5
34	Conventional and unconventional graphs in SAS	Julian Singer		clinical trial, proc step, confidence interval, odds ratio	source	8
35	Credit scoring at Vorwerk: the profit maximum is not the only goal	Elisenda Grau i Navarro, Ralf Finger		credit scoring	source	27
36	Customer profitability analysis using a data warehouse and intranet	Jukka Virtanen		customer profitability, profitability analysis	source	3
37	Customer relationship management using SAS software	Joanna Crosse, Julian Kulkarni			source	22
38	Data Mining and SAS/SPECTRAVIEW software: a case study	Annie Postic, Bengt Bengtsson		response variable, data mining, sample, proc hpsplit, customer retention, outlier, medical history	source	36
39	Data mining in the banking and insurance industry	Juan- Ramón Amat- Barras		sample, response variable, quality of service, numeric variable, attrition, distribution channel, chi-square test	source	18
40	Data Mining with The SAS System	Gerhard Held, John C. Brocklebank		card fraud, market basket analysis, credit card, customer segmentation, outlier	source	42
41	Data Modelling for an epidemiological database	Deborah Allon, Paul Nicholson	The dictionary defines Epidemiology as the 'Science of Epidemics'. In practice, epidemiology is concerned with studying the incidence and transmission of diseases in general, not simply those occurring in epidemics. In epidemiological studies, a variety of types of data can occur. These include case data (giving individual patient details), population data (typically arising from national census surveys), spatial data (e.g. geographic map data sets) and information about diseases. The choice of appropriate data models can be crucial to the successful and efficient access of information required for analysis. This poster describes the construction of data models for data arising from an epidemiological study of leukaemia. In addition to the types of data described above, additional temporal data are available indicating the periods for which both geographic regions and individuals within those regions were observed during the lifetime of the study	data standard, proc sql, proc means, proc step	source	11
42	Data warehouse on a host platform	Terje Hansen		access control, ledger, group by	source	18
43	Data warehousing and modelling: 2nd phase of the Hungarian Tax Administration modernisation project for information services	Károly Brüll		cash management, data warehouse, mis, management reporting	source	9
44	Data warehousing and reporting through the Internet/intranet in a transport company using SAS software	Michael Jensen, Ralph Eriksen		quality control, character variable	source	8
45	Delivering prompt and reliable information to the Brazilian Federal Government: a data warehouse solution	Henrique Andrade	In August 1996, SERPRO, a Federal Agency attached to the Ministry of Finance, decided to search for the best data integration solution to enhance the strategic planning process of the Brazilian Federal Government. SERPRO searched the market for a solution which would process the large amounts of historical data available within the Government in such way that would provide prompt, innovative, reliable and good quality information. Data Warehousing arouse as the solution which would shorten the gap between client needs and SERPRO's capability to make information available. With this in mind, SERPRO contacted some of its business partners, three of which agreed to share experiences and risks involved in the implementation of an architecture to support a solution within a typical mainframe environment. As a result, 120 days later, SERPRO has created a stable Data Warehouse environment which has proved to be a very important government tool	data integration, data warehouse	source	5
46	Development of a fully prospective electronic submission for global dossiers	S. N. Maniscalco, Sandra D. Schlotzhauer, Walter Hauck			source	27
47	Development of a resource accounting system	Bernadette Ruane		dataset, phase iii, data cleaning	source	3
48	Displaying non-visual objects using the model-view architecture	Michel Lehon		sample, sas library	source	10
49	Do it yourself: tips and tricks in building your own application using SAS macro language	Angelo Tinazzi	SAS macro language is probably one of the most used "features" of SAS System. The basic definition of SAS macro language could be "generator of SAS code". Its main charactheristic is to give the possibility to develop ad-hoc application. This paper is not intended to introduce SAS macro language, but the examples that reported could help also new users to better understand the "magnificient intrinsic language" of SAS System. Some examples on how to use macro language will be presented and discussed; tips and tricks will be deeply analysed	macro definition, &variable, macro variable, macro facility, macro loop, clinical trial, %if-%then-%else, proc step, data science	source	7
50	Early experiences with neural networks or if capacity planners had artificial intelligence, they'd be dangerous	Neil McMenemy	Capacity Planning techniques have ranged from rules of thumb through the use of spreadsheets to analytical and statistical modelling. Each technique has its advantages and drawbacks, with the main emphasis being on ease of use, cost and the accuracy of forecast. This paper briefly explains Capacity Planning and considers whether Neural Networks could be added to the Capacity Planner's toolbox	capacity planning, neural network	source	11
51	EURO: the IT and business consequences of European Monetary Union	Richard King			source	24
52	Experience gained implementing a data warehouse at a large retail company	Anders Lissola		kyc, data mining	source	6
53	Experiences with SAS software and the Internet at Volvo Data	Johan Jerresand, Katarina Floberg		data visualization, sas consultant	source	14
54	Experiences with the management of score data using SAS software	Detlef Elxnat		sample, financial services	source	13
55	Exploiting the internet: current technologies and future directions	Alan Pyne		sas output, proc sgplot, proc tabulate, if-then-else, proc step, proc sql	source	32
56	Extending a financial application with EIS capabilities and object orientation	Onno de Jong			source	11
57	Financial consolidation and reporting: the challenges and the solutions	Paul Spoormans		data cleaning, ledger, financial functions	source	13
58	Financial planning and reporting system for the Ministry of Agriculture, Fisheries and Food - a UK Government Department	David Fisher		phase ii, phase i	source	7
59	Flexible financial reporting system - development tips using the latest SAS software techniques	Andrew B. Ratcliffe, James Ochiai-Brown	This paper gives a technical description of a flexible financial reporting system produced for the UK Ministry of Agriculture, Fisheries and Food (MAFF). The system is part of a larger project covering financial budgeting and monitoring and forms a key element of MAFF's Resource Accounting strategy. Most of the data structures are maintained using SAS Data Table objects and the paper describes how validation and cross-referencing can be incorporated in these. A simple `SAS/AF` software audit object is used in this process to create a full audit trail of changes to the data set. MAFF's organisational structure changes every few months and the use of the new `SAS/AF` software Organisation Chart object has enabled MAFF to process these changes easily with drag and drop functionality. The SAS System lends itself well to object-oriented design and it will be shown how this approach led to greater clarity, ease of development and reusability. Because of MAFF's data structures (e.g	dataset, excel, proc step, audit trail, data cleaning, proc report, fact table, phase i, phase ii	source	13
60	Following up production at Arjo Wiggins: an EIS data warehouse solution in a client/server environment	Bernard Pirali, Christian Leleux, Eric Volcher		pharmaceutical industry	source	10
61	Fuzzy Logic and SAS Software - Do they work together?	Markku V. Suni		proc sql, create table	source	5
62	Gibbs sampling: simple examples	M. Ibañez, M. Talbot, Ramón Alonso	Progress has recently been made in statistical and computing technology to fit more complicated and realistic models without resorting to analytic approximations. Such progress includes Markov chain Monte Carlo (MCMC) which is a family of iterative methods based on stochastic simulation. To date, most statistical applications of MCMC have used one particular technique : Gibbs sampling. Although straightforward to describe, the mechanism that drives the process may seem mysterious. The purpose of this poster is to contribute to its comprenhension by exploring two simple cases, in which it is easy to see that Gibbs sampling is based only on elementary properties of Markov chains. In spite of the simplicity of the examples, a wide range of SAS tools are used in the programs provided	sample, markov chain	source	5
63	Going from APL to SAS/EIS	Karen Sedman		trend analysis, proc sql	source	14
64	How auditing the business process leads to bottom line benefits	Ian Huckle		data reconciliation	source	12
65	How to set up a multidimensional data warehouse in a banking environment	Gyorgyi Virgula		ledger, interest rate	source	2
66	HP Clinical, a software tool for faster and better checking of clinical data	Fredrik Hedvall, Per Haglund, Jesper Abrahamsson		adverse events, clinical data	source	9
67	Implementation of data warehouse and reporting at Fokus Bank	Håvar Wold		excel, sas base, data standard	source	14
68	Implementing a scaleable parallel interface between SAS and IBM's DB2 Parallel Edition on an IBM RS/6000 SP	Jim West, Leigh A. Ihnen			source	7
69	Improving security under Racf 2.1 for MVS/ESA 520 with SAS in client/server mode	Claude Dunand		access control, flat file	source	20
70	Information delivery techniques used for standard analysis of clinical trials	Dirk Grosse		dataset, adverse events, clinical trial, macro variable, data dictionary, data step	source	9
71	Integrating Windows clients and SAS software into the enterprise	Gary Mehler, Odd Petter Nythe	To utilize the full potential of SAS System software on the personal computer, your PC should be fully integrated into your ent erprise. SAS System products for the PC provide many client/server architectures that Information System designers can use to access, update and analyze the entire spectrum of enterprise data. SAS System client/server products are introduced in different PC based scenarios and several PC, network and SAS System configuration suggestions are presented to help you get better returns from your hardware and software investment	where statement, traffic data, dataset, proc sql, sas base, excel, proc step	source	9
72	Inter-rater agreement in medical studies: analysis tools within SAS software	Barbara G. Schneider	In this presentation the intraclass correlation coefficient , a graphical technique to check agreement visually and the κ-measure are discussed. Emphasis is laid on how these statistical methods and techniques can be performed within the SAS System and if they are not available within SAS Software how they can be implemented. Data from clinical trials are presented. SAS code is reported using the following tools: `PROC GLM`, `PROC GPLOT`, `PROC FREQ` , Macro Language and `SAS/IML`	proc step, correlation, intraclass correlation, proc freq, proc mixed	source	12
73	Interactive Telematic Counter	Luciano Cococcia	The task of the person who has to consent the access to the statistic data doesn't concern only the quantitative aspect of the information but it also aims to improve the quality of the data to make them more utilizable by the users. This involves the identification of the cognitive demands of the users and the conforming of statistic production to such demands. It's necessary , then, to create an immediate relation with the users. This is the aim of the plan of Abruzzo Region that foresees the opening of a statistic multi- functional counter. Within it an interactive telematic counter has been realized, that can be reached by internet to obtain statistic information about regional data	sas base, macro facility	source	8
74	Introduction of a SAS Data Warehouse	Henrik Dahl, Pernille Christensen, Poul Erik Hansen		data warehouse, dataset	source	20
75	Investigating likelihoods for lifetime distribution using SAS software	Alan John Watkins		likelihood function, maximum likelihood estimation, sample	source	6
76	Linking business applications	Christine Prigent, François Michel, Josette Barazon		excel, dataset, histogram	source	17
77	Loading a data warehouse from various database systems	Zdzisław Dec			source	24
78	Managing an insurance portfolio for profit and growth	Harold Clarke, Keith Chandler		data science, life insurance, loss ratio, excel	source	19
79	Managing financial reporting requirements	Peter Bull		financial reporting, regulatory reporting	source	15
80	Modelling of road deterioration including lifetime distribution and the Cox model	Emmanuel Courilleau	Maintenance program is necessary for optimizing national road network surveys. The maintenance cost could be minimized by the knowledge of the road future state. For this purpose, evolution of different road deterioration characteristics should be determined. Surveys of some test roads had been made during periods of five to thirteen years. Only transverse cracks on semi-rigid pavements were considered in this paper. Lifetime distributions were used to determine deterioration evolution laws. Data correspond to a random censoring with left, right and interval censoring. LIFEREG SAS procedure was used to select the best probability law among those available. Some explanatory variables were used to improve the model. The non parametric Cox model was also used with the PHREG SAS procedure. A new approach was developped to handle left and right censoring with Cox model. To choose the best model, a comparison of the results was made	predictor variable, probability distribution, proc phreg, confidence interval, cumulative frequency, right censoring, sample, proc lifereg, survival function, censoring, hazard function, interval censoring, left censoring, maximum likelihood estimation, likelihood function	source	11
81	Monitoring the market using a data warehouse and a decision support system	Leena Heikkinen		business intelligence, data governance	source	32
82	Neural Networks by "Profit Line"	Charles Oppenheim		neural network, order by, seed	source	16
83	Neural networks for business benefit	Michael Kerin		missing value, credit card, cross-sell, financial services, consumer loan, raw data, service provider	source	20
84	Object-oriented applications development at the Investment and Post Bank	Jiøina Rokosovà		dataset, data science	source	4
85	ODBC and SAS, a focus in interfacing with MS-Access	Peter Haems		proc sql, odbc	source	3
86	Opening the warehouse for business	Neil Hutton		enterprise risk, excel	source	17
87	Point-and-click data validation using SAS/AF software	Leif Puddefoot		data cleaning, clinical database, raw data	source	9
88	Preparing a bank's balance sheet for OLAP applications	Jana Ficová			source	8
89	Procedure for stamping source file information on SAS output	Breda O'Connor, Elizabeth Molloy	In the course of producing a report for a clinical trial numerous drafts may be produced and tables and listings may be generated using several different versions of the data and the programs. In order to keep track of the various versions it is advisable to record, at least, the source information relating to the data sets and programs used. This information should preferably appear on the hard copy of the output. While this information may be easily obtained with certain operating systems it is more difficult with SAS for Windows on a PC LAN operating system. Therefore a procedure for printing any or all of the following information on a table or data listing has been devised. `FILENAME`, filepath and version date of the program used to produce the output. Version date and location of the data sets used to produce the output. Version of SAS used and the time and date that SAS session was invoked. A userID for the individual responsible for producing the output	proc sql, macro variable, proc step, sas output, dictionary tables, txt, dataset	source	5
90	Programming for job security: tips & techniques to maximize your indispensibility	Arthur L. Carpenter	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, macro definition	source	4
91	RAMP' up your storage options - strategies for warehouse repositories	Thomas Becker			source	36
92	ROI in DW: a fast return on investment in data warehousing	Jim Davis, Thomas J. R. Emmerich		customer satisfaction, quality control, business intelligence, customer retention, management reporting, raw data, service provider	source	42
93	SAP R/3 performance management in the intranet of Braun AG: combining Web technology with SAS software	Hayo Hasselmann		cpu time, output delivery system	source	16
94	SAS and the year 2000	Tony Payne	Although the SAS System itself is millennium compliant, many programs written in SAS will not be. The year 2000 issue arises from the common practice of using two digits years in computer systems. This will cause problems in the new millennium, when '00' will often be interpreted as 1900 instead of 2000. Among software packages, the SAS System is one of the very few which is capable of properly handling dates after the end of the century. The very first version of SAS, designed and written in 1972, integrated the ability to deal with date values in the range of AD 1582 to AD 20000. Our paper deals exclusively with issues related to SAS applications and attempts to describe potential sources for problems and possible ways to solve them	sysdate9, date variable	source	5
95	SAS, the Internet and the new decision support systems	Rui Alexandre Henriques Gonçalves	Information is the main resource organisations need to carry out their activity, whether it is used for simple, operational, decision-making or for the establishment of their long term strategies. Critical information for any organisation's activity depends upon two kinds of resources: a good information and decision support system (DSS), and data. Addressing the former, the SAS system makes available to the user the most advanced tools for information analysis and handling. The Internet is nowadays one of the most important information sources available, due to its decentralised structure and its information volume, which is also growing continuously in quality. The aim of this paper is to present a number of tools and solutions that can be applied to the development of a full-potential, intelligent decision support system based on the SAS system and supported by a Internet/Intranet structure. These tools can be plugins developed by the SAS Institute, PERL scripts or JAVA TM programs		source	22
96	SAS/Warehouse Administrator: principles, practice and future directions	Scott Anderson, Terry L. Lewis	`SAS/WAREHOUSE` Administrator software makes it easier to build, maintain, and access data warehouses by bringing the strengths of the SAS System relative to data warehousing together into one consistent interface plus adding additional capabilities not currently available in other SAS system products. This paper explains how to use `SAS/WAREHOUSE` Administrator and describes many of the enhancements that have been added to the first release of `SAS/WAREHOUSE` Administrator since it was first introduced in an experimental form at SUGI 21 in 1996	data warehouse, sas base	source	3
97	SASSEE - A Software Engineering Environment for SAS Application Development	Martin Studemund, Rainer Uhl, Robert N. Lemke-Noe, Wolf-Dieter Batz		quality assurance, quality control, sample	source	22
98	Segmentation using decision trees	Gerhard Held		proc hpsplit	source	52
99	Social network analysis using SAS/IML software	Efraim Darom		dataset, cluster analysis, output delivery system	source	26
100	Social security benefits: using a warehouse to forecast and monitor social change	Sandy Fitzpatrick, Stephen Donnelly		regression analysis, resource allocation	source	20
101	Social security benefits: using a warehouse to forecast and monitor social change	Sandy Fitzpatrick, Stephen Donnelly		outlier, resource allocation	source	15
102	SPC system in steel works and control of the implemented SPC	Cinzia Amandonico, Franca Vicino, Stefano Conedera	Acciai Speciali Terni has been provided with a Technical and Quality Control System; technical data are collected in a commercial relational Data Base (DB) which contains corporate data directly coming from process computers of the different plants, data coming from the central managing system and from manual input	dataset, quality control, outlier	source	4
103	SPDS - The Scalable Performance Data Server	Thomas Becker		proc step, where statement, index, index creation, macro variable, proc sql, proc sort, dataset, proc copy, proc datasets, access control, sample, proc append	source	49
104	Tabulation Interface System	Andrew Wilcox		options statement, proc tabulate	source	9
105	Taking advantage of SAS software on Windows NT	Hans-Jochen Kirsten, Mark W. Cates	Windows NT is fast becoming the universal desktop client operating system as well as an important file and compute server for mission critical applications. This paper presents a discussion of the state of Windows NT and how the SAS System Release 6.12 for Windows takes advantage and integrates with the operating system. Areas such as the user interface, OLE and Web integration are presented. Data access and Microsoft BackOffice integration, and hardware considerations are also presented		source	16
106	The benefits of data warehousing in Holmia	Staffan Wadström		product profitability, sas risk engine, kyc, data mining, data cleaning, distribution channel, internal audit	source	39
107	The business case for improved management information	Martin Burge		management reporting, mis	source	12
108	The correction of wrong results obtained with the "Agree"option in PROC FREQ for contingency tables with empty rows and columns	Richard Vonk, Werner Wierich	Tests of symmetry are routinely used in the evaluation of ordinal variables in clinical trials. McNemar's test and Bowker's test of symmetry are, among others, available from `PROC FREQ` . However, if only a sub-table of the original (intended) contingency table is observed, the results obtained by using the 'agree'-option in SAS `PROC FREQ` can be wrong. For example, this is the case if in a 3x3 table only the upper right or lower left 2x2 table contains observations. This will be illustrated by the application on the evaluation of laboratory transition tables. A macro which calculates the correct statistic and the corresponding p-value will be presented	proc freq, proc step, degrees of freedom, out=, sample	source	8
109	The data warehouse strategy of SPAR Handels AG	Peter Albrecht		output delivery system, data wrangling, data warehouse	source	26
110	The development of enterprise information systeme	Imrich Weigl, Stanislav Klabník		business intelligence, data mining	source	12
111	The future of data warehousing	Sean Kelly		data warehouse, data mining, data governance, proc sql, data science, metadata management, data cleaning	source	28
112	The GDP forecast for the Slovak Republic	Josef Chajdiak		binary variable, anova	source	5
113	THE MANAGEMENT CONTROL IN A LARGE HOSPITAL STRUCTURE SAS/EIS AS SERVICE FOR SANITARY MANAGEMENT	Roberto Gregori	The need of a best quality in the sanitary services rent to the citizens, imposes the use of a management control system, and therefore the use of a measurement and a check of the division efficiency and efficacy in a modern hospital structure. Data warehouse, DSS, EIS are concept which, especially lately, arouse considerable interest in the world informatics community. This introduction wants to explain the buildings experiences of a model system which supports the top management decisions, for the control of the administrative activities in a big hospital. The realization is based on a `SAS/EIS` application, exploiting the possibility, provided from RDBMS Oracle, of collecting the information arranged on different databases in a dynamic and safe way	data warehouse, proc sql	source	7
114	The National Bank of Poland's warehouse-based reporting system	Jolanta Czerwinska		libname statement, financial reporting, proc sql	source	5
115	The Tank Battle of the 21st Century	Judy Rosten			source	6
116	The Use of the Data Table to Develop New Variables for Customer Selection	Martin Beasley, Richard Cannon		sample, proc freq, interval variable, dataset	source	13
117	Trickle feed update of SAS Data Warehouses from ADABAS protection log tapes	Stuart Birch		normalization, dataset	source	26
118	Understanding and enforcing standards to promote efficiency	Meimei Ma, Sandra D. Schlotzhauer		adverse events, quality control, pharmaceutical industry, quality assurance, proc step, data cleaning, clinical research, options statement	source	9
119	UNIX systems and LAN/WAN service level improvement	Camillo Clementi, Candido Cese		capacity planning, network data	source	23
120	Using a data warehouse for management control in a large hospital structure	Roberto Gregori	The need of a best quality in the sanitary services rent to the citizens, imposes the use of a management control system, and therefore the use of a measurement and a check of the division efficiency and efficacy in a modern hospital structure. Data warehouse, DSS, EIS are concept which, especially lately, arouse considerable interest in the world informatics community. This introduction wants to explain the buildings experiences of a model system which supports the top management decisions, for the control of the administrative activities in a big hospital. The realization is based on a `SAS/EIS` application, exploiting the possibility, provided from RDBMS Oracle, of collecting the information arranged on different databases in a dynamic and safe way	data warehouse, proc sql	source	7
121	Using DSDM (Dynamic System Develop Method) to implement your data warehouse - quickly, efficiently and for maximum return	Kevin Moug			source	59
122	Using EIS and OLE to explore consumer research data	Kate Browning	As part of Unilever's Research and Development program , it is essential to analyze competitor vs Unilever brand information. This involves handling large amounts of data which need to be represented in tabular, graphical and map form. A `SAS/AF` application has been written to aid the research into brand information. This system uses `SAS/EIS` software (Executive Information System) for information delivery, thus showing the data in easy tabular and graphical forms. The system also features Object Linking and Embedding (OLE) allowing the user to communicate with `EXCEL` without leaving the application. Both the `SAS/OLE` class and `SAS/OLE` automation are used here. The research data also needs to be shown geographically hence map techniques using `PROC GMAP` will be implemented. Unilever Unilever is one of the most international goods companies in the world. Its products serve people's everyday needs for food and cleanliness. The number of products which they manufacture is vast	proc gmap, proc step, excel	source	4
123	Using lifestyle data to improve customer segmentation	Huw Davis		sample, stage 1, regression analysis	source	13
124	Using SAS software in the financial management process	Christopher P. Gibley, Janet R. Gibley, Raymond A. Gibley	This paper describes the financial management system of Horizon Books, Inc., a specialty book distributor in North America. The paper focuses on the standard reports, financial analysis reporting, and management reporting elements of this closely held corporation. Considerable emphasis is placed on how the authors integrate third party software with the SAS software system. The paper highlights the following SAS system software products: Base SAS , `SAS/ETS` , `SAS/GRAPH` , `SAS/EIS` , `SAS/STAT` and `SAS/GIS` . The authors demonstrate how the integration of these information technologies sharpens the strategic focus of this international book distributor. To maintain the integrity of the firm, all of the company operating data are disguised	regression analysis, sas base	source	4
125	Using SAS software to forecast the results of the Russian parliamentary and presidential elections	Igor Romanov		output delivery system, data wrangling, time series analysis, sample, proc freq	source	27
126	Using SAS software to fulfill an FDA request for database documentation	Adam Crisp, Panteleo Nacci		proc step, proc sql, adverse events	source	11
127	Using SAS/ACCESS to SAP/R3: a practical experience	Hans Hulpiau		data dictionary, data step	source	4
128	Using SAS/SHARE software more efficiently	Philip R. Holland	`SAS/SHARE` is a very powerful product which allow concurrent access to SAS Datasets for reading and updating. However, if not used with care, it can also be the cause of significant system-wide performance problems. Although the product is widely used, its impact is not widely understood. This paper describes some of the potential pitfalls when using `SAS/SHARE`, and suggests techniques to gain the maximum benefit from the product	dataset, catalog, proc step, proc copy, cpu time, batch job	source	6
129	Warehousing works	Oratio Gaigher		proc freq	source	11
130	Weighted Poisson Analysis à la Goodman using SAS software	Rian Vogelesang		poisson distribution, anova, likelihood function, interaction effect, poisson regression, proc genmod, proc freq, main effect, proc step, regression analysis, maximum likelihood estimation	source	14
131	What is the profit on Spanish corn sold in Germany? Management information and sales reporting at Danisco	Kjeld Andreasen		data warehouse, logistic distribution	source	2

Back to Conf go 1998 go 1996

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.