SEUGI 1999 Papers - Index

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

#	Title ×	Authors ×	Abstract ×	Keywords ×	Extras	Pages
1	"Performance Management" (SKIM, the solution for the business balanced scorecard)	Fred Tenkirk	Presentation	business intelligence, excel	source	35
2	700,000 customers managed one to one with the SAS System	Llius Pons	Presentation	deposit, customer segmentation	source	23
3	A balanced scoredcard for an insurance company base on SAS Software	Ludwig Fruhauf	Presentation	cpu time, health insurance, life insurance	source	39
4	A data model for database marketing activity	Alberto Saccardi, Frank Fiocca	What kind of data do we have collect to optimise C.R.M.? Which data do we need to understand the market and our competitors? Which logical subjects should we consider in a marketing database? How detailed and, how summarised should our data be? How should it be organised? These are a few questions that have to be dealt with to design a marketing database for decision support. We'll illustrate the basic guidelines to define the correct data model for a powerful database marketing activity. In particular we'll present some cases we have encountered and tried to resolve	data mining, fact table	source	2
5	A Data Warehouse on Auto-Pilot - how to maintain your SAS Data Warehouse without programming	Steve Morton	Presentation	data warehouse, create table, data governance, macro definition, raw data, proc sql, api	source	40
6	A means to an end-to-end Capacity Management System	Ben Ashford	Presentation	capacity planning, audit trail, correlation, transaction data	source	45
7	A SAS/AF application competitive with higly specialised data acquisition softwares in molecular biology	Xavier Draye	Presentation	output delivery system	source	26
8	A user friendly interface for simultaneuos non-linear regression on sets of metallurgical deformation curves	Ronald Mulder	Presentation	regression analysis, proc reg, proc genmod, proc nlin, sas output, txt, sample	source	20
9	Activity based costing turns a telephone monopoly into a market based competitor	Margarida Bajanca	Presentation		source	40
10	Advanced year 2000 testing and compliance issues for SAS software users	Ivor G. Moan, Mike Kalt	Presentation		source	54
11	Aiming for a world class performance management process	Felicienne Bloemers	Presentation	business intelligence, root cause analysis	source	20
12	Air Deal Manager: an end-to-end travel & expense management solution with SAS Software	Dionino Di Florio	Presentation	business intelligence, extract	source	52
13	AKU: customer profitability analysis	Jukka Virtanen	Presentation	customer profitability, excel	source	35
14	ALM Modelling at BACOB Bank c.v.	Marc Hanseene, Sabine Vanmaercke, Sigrid Spruyt	Presentation	interest rate, interest rate risk, survival analysis, liquidity gap, data warehouse, dataset, sas base	source	22
15	AMIS - The Airport Management Information System	Eeberhard Gratz	Presentation	mis, management reporting	source	34
16	An application for the analysis and visualisation of disease incidence data	Deborah Allon, Estelle Gilman, Paul Nicholson	Descriptive Epidemiology is concerned with the analysis of the incidence of diseases both geographically and over time. A characteristic of this field of study is the need for access to diverse types of data. These include data on disease incidence, population data from the region of study, data relating to diseases and map data sets at various geographical levels. The ability to manage such diverse data in a way which allows easy and efficient access to different subsets of data is an essential preliminary requirement to subsequent analysis. Preliminary investigations usually consist of the tabulation of age-specific incidence rates for each geographical region and the calculation of standardised rates, typically presented as standardised morbidity ratios (SMRs). Subsequent investigations include the analysis of variations in incidence rates with age, sex and geographical region, tests for spatial clustering and the use of maps to display SMRs	data standard, proc genmod, relative risk, poisson distribution, proc step	source	9
17	An approach to saving large amounts of disk space for the data warehouse without using compression	Peter Crawford	A large problem of data warehouse implementation is the enormous volume of data that "possibly" may be required to hold the information being collected. This paper describes how we may control some of this problem. While most stored information is regularly updated, we cannot predict which of the columns for the rarer events will remain unused. Not all data stored will need the maximum precision available (16 significant digits); nor will the actual needs be predicted accurately for warehouse designers. The SAS System data set compression option works well for text, but is less effective with numbers, and even less effective when information values are missing. Where most stored data is numeric and occasionally missing, an alternative approach needs to be found that will relate the data space required to the amount of actual information being stored. This presentation describes an approach, which enabled up to 50% saving on space required by the numeric information	proc freq, data warehouse	source	2
18	An Introduction to ODS	Christopher R. Olinger	Presentation	proc step, proc template, proc standard, sas base	source	18
19	An introduction to risk management paper stream	Rik van de Weerthof	Presentation	credit risk, monte carlo, sas risk engine	source	33
20	An MIS at Eurescom	Klaas-Pieter Vlieg	Presentation	mis, management reporting, proc sql	source	13
21	Anaylising response surface and mixture experiments using the new ADX Interface	Bob Rodriguez	Presentation		source	22
22	Application Development Tools	Mark Bodt	Presentation	end, proc step	source	8
23	Application of data warehousing techniques in the pharmaceutical industry	Simon Warman-Freed	Presentation	pharmaceutical industry, access control	source	37
24	Application of statistics in banking: marketing applications	George Damianov	Presentation	confusion matrix, sas base	source	19
25	Application of the SAS System to support financial management within the South African Government	Elize Basson, Gert van der Linde	Presentation		source	23
26	AR-QUEST: enterprise-wide sales information delivery for analysing tools through the intranet in Akerlund & Rausing Group	Arto Arffmann	Åkerlund & Rausing has a need to deliver sales information throughout the whole organization, which is geographically scattered. The former sales reporting system was terminal based, which needed to be re-implemented, because database it used was no longer maintained. Åkerlund & Rausing chose `SAS/INTRNET` software for the new system. Basic idea of the system remains the same. Information is delivered in raw format to be refined and analysed in tools like Paradox and `EXCEL` using existing applications. Novelty in the new system is browser based user interface and information delivery through intranet. Because information is in raw format, there is quite large amount it. And it has to be delivered to several countries throughout Europe on slow connections. The connection is even possible even through GSM-links to sales people's laptops. Chosen solution integrates system seamlessly into Åkerlund & Rausing's internal web pages, which is their strategic information delivery channel	excel, delimited file	source	4
27	Balanced Scorecard, a way to improve IT services' contribution to the business processes	Anders Hallgren	Presentation		source	23
28	Balanced Scorecarding with the SAS System	Jonathan Hornby	Presentation	customer satisfaction	source	26
29	Base SAS software reporting: moving from Version 6 to Version 8 with the Output Delivery System (ODS)	Paul Kent	Presentation	proc step, sas base	source	12
30	Better healthcare with the correct information	Goran Lord, Hans Gustafsson	Presentation	excel, output delivery system, sample	source	26
31	Better understand and make simulation in the insurance industry to increast underwriting profit in a context of imperfect files	Jean Boudy	Presentation	loss ratio, pure premium	source	19
32	Boosting your SAS/AF applications with the power of the WIN32 API	Martin Sjoholm	Presentation	data step, character variable, api, length statement, numeric variable, proc iml, sas base	source	14
33	Building a data warehouse in the Risk Management department of SkoFIN with the SAS Rapid Warehousing Methodology	Julia Farkasova	Presentation	data mart, sas base, excel, management reporting	source	32
34	Building data warehouse	Elena Muriel	Presentation	data warehouse, mis, management reporting	source	22
35	Cinical Data Warehousing	Justine Barber	Presentation		source	14
36	Clinical processes and SAS/PH-Clinical, a good marriage?	Patrick Genyn	Presentation	clinical trial, clinical data, data science, clinical data management, data governance, data cleaning, clinical database, data review, phase i, adverse events	source	24
37	Closing the CRM loop	Sven Farber	Presentation		source	21
38	Comparison of various statistical techniques to support market retention and acquisition programs	Ian Thornhill	Presentation	logistic regression, logistic distribution, sample, regression analysis, data mining, cross-sell, predictor variable	source	66
39	Concentrating on the Customer: Corepoint Technologies, IBM's new CRM company	James Cannon	Presentation	customer acquisition cost, commercial banking, credit card, customer satisfaction, distribution channel, management reporting	source	41
40	Considerations when implementing a risk management system using Risk Dimensions	Stephen Ludlow, Steve Rawes	Presentation		source	32
41	Controlling via Intranet: a SAS software based Java application	Thomas Koschlig	Presentation	data mart, macro facility, sas base, macro definition	source	23
42	Costing Warehouse Resources - A Solution for Windows NT Server	Michael Matthews	Presentation	dataset, sas base, data warehouse, proc step, bufsize, proc iml, memory usage	source	34
43	Credit risk analysis: an empirical approach	Angela Ancona, Emiliano Laruccia, Flavio Addolorato	Presentation	neural network, confidence level, sample, capital ratio, discriminant analysis, feature selection, data cleaning	source	22
44	Crime Statistics in Belgium: building a national database	Christian Leleux, Samuel de Klerck	Since 1994, the Belgian Internal Affairs Department started a criminal data collection program with the aim of building a national statistical database. After four years, all the Belgian territory is covered and now we are ready to extend the scope of our project. Currently, we are exploiting 8 dimensional variables and we are expanding those variables to 32. In the same time, we have changed our processes into a structured environment: the SAS Warehouse Administrator	data governance, excel	source	3
45	CRM Project: HP and SAS Institute explore new frontiers of scalability	Leigh A. Ihnen	Presentation	star schema, credit card	source	77
46	Customer data: from warehouse to powerhouse!	Nico Kuijper	Presentation	distribution channel, insurer, interest rate	source	23
47	Customer profitablily analysis for Securex - a major payroll adminstration and insurance company	Wim D'Hallweyn	Presentation		source	12
48	Customer relationship management with Cogito: the MIS of DG Bank	Christina Dietz, Rolf Huxoll	Presentation		source	31
49	Customer relationship management: organise for maximum ROI (Return on Information)	Lynette Stassen	Old Mutual is South Africa's largest financial institution and is in the process of listing on the London Stock Exchange. Our marketing data is held in a special datastore using SAS data warehouse programs. It contains information on some 10 million people associated with some 5 million present or recent policies or unit trust accounts. About 3.5 million are current contract owners. We have information on all the contracts which they are associated with, as well as the tens of thousands of salThis marketing datastore is used to source a large variety of marketing campaigns, and also feeds our datamining and OLAP tools … which are also SAS based.	data mining, proc hpsplit	source	13
50	Customer relationship management: where to start?	Ivan Clemente	Presentation		source	22
51	Data mining methodoligies for business: cross selling	Henrik Wagner	Presentation	proc hpsplit, regression analysis, data mining	source	37
52	Data mining methodologies for business: fraud detection	Bernd Drewes	Presentation	credit risk, data mining, outlier	source	22
53	Data mining technologies for business: an overview	Gerhard Held, Gloria Miller	Presentation	data mining	source	30
54	Data mining: beyond mandatory reporting to the authorities	Franky De Cooman	Presentation	concomitant medications, business intelligence	source	17
55	Data warehouse architecture for model development	David Annis, Turlough Fitzpatrick	Presentation	model deployment, data cleaning, data mart, data mining, sas base	source	32
56	Data Warehouse centric Information delivery? The case of Intesa Asset Managemetn	Tiziana D'Alesia	Presentation		source	20
57	Data warehouse on the Web	Attila Papp, Eva Torda, Rózsa Tóth	Westel 900 GSM Mobile Telecommunication Ltd., possessing more than a half of subscribers, is the stabile leader of the three companies on the Hungarian mobile telecommunication market. The key to the success of the 6-year old company, which has been acknowledged by several Hungarian and international awards, is the ability to meet the frequently changing expectations of the market and the customers. Companies, working on a mass market and having many hundred thousands of customers, are using more and more sophisticated computer systems to support their customer focused marketing strategy. The large number of information consumers, the increasing requirements and the data volume led Westel 900 to the idea of a data warehouse based information delivery system which has been created in co-operation with SAS Institute and KFKI ISYS Information Systems Ltd. Providing information about customers, their calling habits, churn and sales, Westel 900's Marketing Information System (W900MIR) helps decision makers and analysts in better understanding of customers' expectations and behaviour, in formation of strategies related to customers (customer care system, increase customer-satisfaction and customer-value) and in optimisation of relevant resources of the company.	development age, raw data	source	4
58	Data warehousing and cost management in the manufacturing sector using SAS System	Nicolas Radulovic, Ricardo Olea	The aim of this paper is to show how large manufacturing organisations can build an enterprise-wide Data Warehousing solution. This will then provide the basis for complete cost control management. Better cost control through timely analysis all the way from the factory floor to the final point of sale. This paper is based on the work done separately at SE in France, and at the Boeing Company in the United States. Today, an enterprise Data Warehouse is under construction at SE's European operations using `SAS/WAREHOUSE` Administrator software. The Data Warehouse already furnishes all of the data needed by two SAS solutions in the area of cost management for middle and high level management. One of them is a `SAS/EIS` and HOLAP application for profit center reporting (PCR) and analysis. The other solution is a dynamic `SAS/INTRNET` application used for analysing procurement data. This paper will describe the PCR application. Good Data Warehousing and Data Mining practices were also one of the contributing factors to the success of the Total Manufacturing Cost (TMC) application at The Boeing Company. TMC provides a simple daily scorecard to the shop floor employee and all levels of management. The scorecard compares actual cost, schedule and quality information with targets. The information includes both daily detail and historical trends. Detailed information is available at the individual employee, work package and serial number level. TMC was developed using `SAS/AF` transitioned to WebAF	structured data, data mining	source	7
59	Data warehousing in Tele Danmark with focus on active use of metadata	Allan Toft	Presentation	financial reporting	source	46
60	Database marketing for professional publishing	Bart Heinsius, Rudolf Vobornik	Presentation		source	12
61	Database marketing simplified through data mining	Arnfried Ossen	Competition in banking has never been fiercer, and like all other financial institutions, Deutsche Bank must pay greater attention to customer service. The bank needs to attract new, high-income and high-net-value customers, to cater to the individual needs of customers, to offer them precisely tailored products and services, to identify customers likely to close their accounts and to dissuade them from doing so.	data mining, private banking, data warehouse	source	7
62	Datamarts without effort	Francis Steelandt, Ignace Follet	Presentation	data mart, data warehouse, dimension table, fact table, insurer, logistic distribution	source	25
63	Dealing with Historical Data: Data Mining and Forecasting	I. Izquierdo, J. Migel Garcia-Santesmases	Companies have available huge amount of historical data regarding to customers, and their own business. However they are not able to extract the implicit knowledge from the data, knowledge, that on the other hand is needed for the decision making process. In this paper we will show how our company has provided industry with tools to support the decision making process based on clustering of customer behaviour and forecasting techniques using historical data. We will illustrate it describing the analyses carried out for some Spanish companies and will focus on practical aspects of forecasting and clustering using SAS system. We will show an application that we have implemented for an Spanish airline company in order to solve the problem of studying the behaviour of its customers for a discount vouchers promotion. The paper will focus the methodology followed in an analysis of the temporal customer behaviour curves after data filtering. In this way we were able to shrink a huge amount of data in just 15 homogeneous clusters. This application was implemented in `SAS/AF` and it includes a powerful query tool that speeds up the navigation through data in the system using OLAP techniques.		source	8
64	Delivering active Web contents with Base SAS software and a single macro	Hayo Hasselmann	Presentation	data step, macro variable	source	14
65	Delivering Information from your SAP AG's R/3 System	Levin de Nooij	Presentation		source	31
66	Design patterns for Web enablement	Chip Kelly, Mark Torr	Presentation	sample, proc sql	source	34
67	Developing a SAS data management system using FRAME technology	David Smith, Sandy Meek	Presentation	clinical trial, sample, clinical database	source	33
68	Dissemination of health reports: a hybrid (fat & thin) solution	Allison Low	A reporting system using a hybrid solution of both "fat" and "thin" clients will be examined: 1) The advantages of using a "fat" client `SAS/AF` based application for high-end users such as data analysts wishing to use The SAS Institute's advanced analytical tools such as `SAS/INSIGHT` 2) The advantages of using a "thin" client web based solution for easy distribution of reports to geographically dispersed health services. Fat, Thin or Both? Dissemination of Government Health statistics in NSW, Australia is regularly mediated by the old "print and paper " method. However, in recent times electronic distribution has either accompanied the paper version or replaced it altogether. The electronic version (distributed on floppy disk or Cdrom) may have consisted of a combination of the following types: a pdf file, a flatfile, or an `SAS/AF` application. One major limitation of releasing an electronic report in this way is high cost	excel, ods html	source	6
69	Distributing organisation charts via the Web without SAS/IntrNet software	Philip R. Holland	In large corporations the maintenance of organisation charts is a necessary operation. Staff need to have up-to- date information on who is working where. Printed organisation charts can only be distributed quickly enough in small companies, so intranets tend to be used in larger organisations. This paper demonstrates the techniques for generating and maintaining organisation charts based on simple parent/child records held in spreadsheets or SAS Datasets. The resulting organisation chart is then be converted to an HTML table, using only Base SAS software, for rapid distribution via the intranet	format statement, dataset	source	7
70	Distributing SAS/AF Models with Java Clients	Mark Torr	Presentation	bar chart, grid computing	source	19
71	e.intelligence: solutions for a new business world	Steven Maginnis	Presentation	capacity planning, error message	source	15
72	ECR: Focusing on the Customer	Jane Hawksworth	Presentation		source	26
73	Effective data warehousing - optimised MDDB in practice	Jacek Kaukiel	Presentation	data warehouse, dataset, life insurance, correlation, mis, data science, insurer	source	28
74	End-to-End Response Time Measurement from an End User Perspective - A Realistic Method to analyze Service Levels	Jurgen Wingorz	Presentation	elapsed time, financial reporting	source	14
75	Enhancing your output utilising RTF files from within Base SAS software	Rudy Gyzen	Presentation	sas base, data step, sas output, sample	source	18
76	Enhancing your SAS/AF applications with the Windows applications programming interface	Michael Matthews	Presentation	sysrc, i/o, api, macro variable	source	23
77	Enterprise budgeting and planning	Jesper Vork	Presentation		source	25
78	Enterprise Guide: the new thin-client to the SAS System	Carol Williams Rigsbee	Presentation		source	4
79	Enterprise Reporter: a Window to the SAS Data Warehouse	Scott Anderson	Presentation		source	14
80	Experience with Nashville on MVS, NT OS/2 and Unix	Per Andersen	Presentation	output delivery system, proc step, proc sql, create table, options statement, proc format, proc tabulate	source	44
81	Experiences fof Using SAS/Access interface to SAP AG's R/3 from a technical perspective	Marti Laitinen	Many leading organisations have made large investments in enterprise resource planning (ERP) systems. These systems automate such business-critical operations as finance, logistics (in whole), inventory and production planning - and are vital for day-to-day efficiency within an enterprise. However, while ERP systems can collect and provide important data as the basis for attaining competitive advantage through information, many organisations are finding ERP systems to be very complex. In fact, they are discovering it is not at all easy to get the kinds of information and reporting flexibility that business users need and desire to support their decision-making processes. Experiences of using `SAS/ACCESS` Interface to SAP R/3 in this case has recognised in using the sales reporting system in HK Food Ltd, the leading producer of branded fresh foods in Finland	format statement, data dictionary	source	4
82	Experiences from developing STARA: Starckjohann Sales Reporting System	Olavi Joutsi	Presentation	sample	source	10
83	Experiences when using SAS/PH-Clinical software in clinical trials	Gunnar Magnusson	Presentation	clinical trial, sample	source	28
84	Exploiting data warehouse metadata for knowledge management	Berthold Weismann	Presentation	data standard, dataset, view, data mart, time series analysis, proc format, data governance	source	27
85	Exploiting SAS/AF server models from SAS and COM clients	Robert Owen	Presentation	sas enterprise guide, data mining	source	69
86	Extending the SAS Data Warehouse using SAS/Warehouse Admistrator add-in technology	Steve Hiorns	Presentation	data cleaning	source	17
87	Extracting Data From Baan	Heike Czichy, Jim Davis	Presentation		source	31
88	Financial Management at a Commercial Bank	Tadeusz Stawicki	Presentation	raw data, data transformation	source	19
89	Finding the hot prospects in a legacy of diamonds: how to build good CRM given sparse demographics	Charles Stiffler, Vesna Luzar-Stiffler	Presentation	sample	source	23
90	Focusing on the customer perspective - Measurements for Customer Relationship Management	Jane Hawksworth, Linda Saul	Presentation	customer retention, customer profitability	source	37
91	Forecasting Cross-Sectional Time Series: A Data Mining Approach Using Enterprise Miner Software	John C. Brocklebank, Michael Leonard, Taiyeong Lee	The practice of developing predictive models on large volumes of data is classified as data mining. Cross-sectional time series manifests itself in cases where data for different departments, locations, part or SKU numbers are collected over time. The target or response measures may include product counts, sales, and a variety of inputs or independent pieces of information that are associated with the target. The inputs are classified as either deterministic (for example month or year where the future values are known) or nondeterministic (for example interest rates or price, where future values are not known and must be forecasted or estimated from the data). The cross-sectional nature comes from the fact that you have separate time series (departments for instance) and you wish to provide a modeling method that estimates correlations across separate strata and the combined series	data mining, time series analysis	source	3
92	Galahad: from the Round Table to the Web	Tony Payne	Presentation	business intelligence, data warehouse, sas base, proc sql	source	48
93	Generating a SAS program - case survey analysis	Markku V. Suni	Presentation	proc step, proc format, proc freq, macro variable	source	31
94	Getting clickstream behavior based on IT Service Vision: another component of CRM on the Web	Frank Johannsen	Presentation	proc freq	source	13
95	Guiding the user: using the tab layout object in a SAS/AF application	Deborah Allon	The availability of the Tab Layout Class in `SAS/AF` has greatly enhanced the potential for good screen design. Tab Layout objects allow the organisation of information on many screens within a single frame. A tab layout can be used to facilitate data entry or selection where there are many criteria to specify, or simply to provide different views of the same information. Furthermore, any of the tabs making up a Tab Object may be grayed or ungrayed, allowing more detailed control of the user interface. This paper describes how the Tab Layout object was used extensively in the design of the user interface of an application for the analysis and visualisation of disease incidence data. When investigating disease incidence data, many data items must be specified in order to choose the subset of data to be analysed. Some selection criteria may be dependent on other criteria already selected and this paper shows how ordering can be imposed on the tabs to control the user's journey through data selection.		source	6
96	Harnessing the Power of the SAS System Over An Intranet	Andrew Oliver	A SAS intranet solution was initially developed for an Insurance client who required an online management information solution to replace an existing labour intensive process. The system was to be used by different levels of management spread geographically to monitor sales force productivity and activity. Timely information was required in tabular and graphical format. The client required a secure, user-friendly OLAP enabled system that performed well over an Intranet. To meet the client's needs we developed and implemented a generic intranet solution, later named Questor. This presentation will demonstrate Questor, show how it integrates with the SAS System and highlight the benefits of the solution.	output delivery system, management reporting	source	9
97	Help! We are building a data warehouse. With a stethoscope on a developing process	Dag Refvem	Presentation	phase ii, phase iii, correlation, excel	source	32
98	High-quality SAS reporting: which is the optimal output format?	Mika Leinonen	Presentation	excel, macro definition, macro facility, sas output, wilcoxon signed-rank, proc means, proc report, clinical trial, data step, rank test, proc step	source	39
99	Historical service views based upon HP/ITO-5 and SAS IT Service Vision	Walter Verhoeven	Presentation	data governance, output delivery system	source	24
100	How to become the spider in your IT Web	A. Geerts, D. Peelen, Danny Dikstaal, Gert Scholtes, I. König, R. Lagcher	SAS IT Service Vision is a business solution for performance management, allowing IT managers to provide better service regarding quality of service and cost of delivery. IT Service Vision addresses services such as systems, networks, Web servers and phone systems. Data concerning these services are collected and stored in a Data Warehouse. This data can be analyzed to provide reporting for all levels of an IT organization to help integrate IT goals with corporate business goals. In this paper we will show the full-blown capacity of IT Service Vision, using a project we have completed successfully. Search And Solve has used IT Service Vision, enabled with Web-functionality, to solve an important problem of one of the world's largest oil companies. The implementation was characterized by the fact that it is an international, multi-mainframe environment, with very high time pressure on the implementation. We'll tell you more about the methodology we used and the tools we developed in obtaining optimal result and we will show some examples of information we created using Web technology. In addition we'll present how we used this experience in implementing IT Service Vision in a Windows NT environment, using systems-, network-, Internet- and telephone-data.		source	4
101	How to get the most out of SAP AG's HR module, a practical experience	Sophie De Baets, Christ D'haeveloose	In the field of human resources there is a growing trend towards moving from activity based functions to a more strategic, business oriented role. Nowadays a company wants to align its human asset management goals more closely to its corporate objectives. Therefore HR professionals need a sophisticated tool to understand their personnel by measuring for instance the employee satisfaction and analyse the impact of decisions about compensation policies, organisational structure, hiring and so on. A Data Mart focusing on the HR information needs is the best solution to meet these objectives.		source	8
102	How to use Version 8 features to optimise the distributed capabilities of SAS software	Richard Doherty	Presentation	mp connect, network data, proc step, data step	source	50
103	HR Vision - Tapping into Human Resources Information for Strategic Business Advantage	Michael Silva	Presentation	excel, proc sql	source	25
104	Implementing an IT Service Vision data repository in the real world	David Sherry	Presentation	macro definition	source	15
105	Improved Financial Management with Financial Warehousing from CFO Vision	Bubba Tyler	Presentation	financial reporting, data warehouse	source	18
106	Improving competitiveness and information supply at a financial provider	Jonas Sallander, Peder Blomgren	BUFAB is a financial provider within ICA AB, Sweden's largest retail firm. The paper discuss how BUFAB have used a business solution based on SAS software to use information to increase its competitiveness and how to solve deficiencies in it's prior information supply. The business benefits of the solution are addressed and the unique way of working during project implementation is outlined. Finally, the enabling technology solution is briefly commented	financial services, business intelligence	source	3
107	Improving manufacturing efficiency with optimisation techniques	Andrej Pajenk, Anton Cizman, Samo Cerc	The availability of decision support and productivity software is providing the opportunities for smaller manufacturing enterprises to develop systems which utilize operations research models to support decision making. The prototype of a decision support system, which incorporates linear and integer programming, is presented. The system is based on the `SAS/OR` software which has been widely used in operations research area. The graphical user interface is developed to assist users in making effective management decisions. Some decision making problems in an integrated production management context are pointed out and a simple example of linear programming problem is shown to illustrate the usage of the decision support system in practice. Keywords: decision support system, mathematical programming, computer software, computer integrated manufacturing	linear programming, odds ratio	source	7
108	Increasing the value added contribution of the Corporate Finance Function	Michael Bower, Tony Cotterill	Presentation	financial services, ledger	source	24
109	Information everywhere - Application Integration across the Enterprise	Allan Russell	Presentation	sample, business intelligence	source	57
110	Information systems in the public sector using SAS/IntrNet software	Michael Jensen, Ole Weinreich, Sven Gaffron	Presentation	temporary dataset, proc step, financial reporting, excel	source	25
111	Inquiry system of municpalities of the Slovak Republic	Jan Meszaros	The increasing demand for information related to the demographic development of municipalities and regions has forced us to think about the creation of a user-friendly system for the presentation of demographic indicators. The up to now way of accessing the data was inappropriate. The enormous amount of data is published in the book form and stored on magnetic media. These magnetic media can be used only with difficulties due to their different structure and codes. The published books, especially those of an older date, are hardly legible.		source	5
112	Insurance application: marketing database, forecasting model and cluster design at Reale Mutura Assicurazioni	Flavio Bonifacio	The application concerns: budget definition of insurance agencies and agencies performance- based segmentation. The paper will discuss the facility of building a marketing DB directly linked to the core of business mission. Some advantages will be illustrated in terms of parsimony and robustness of the forecasting model. A dynamic and self correcting estimation process will be presented. The same DB will be then accessed to establish a well defined clusters among the agencies in terms of local commercial opportunities. The absence of data redundancy will be outlined. The problem of upgrading such data and procedures will be focused. Of particular interest is the use of Enterprise Miner in the estimation process	data mining, insurer, logistic regression, logistic distribution, sample, regression analysis	source	16
113	Integrating data mining and marketing campaign management technologies	Kurt Thearling	Presentation	proc freq, data mining	source	33
114	Integrating management reporting with SAS Software: balanced scorecard, data mining and OLAP Analysis for an insurance company	Patrick Imark	Presentation	insurer, bar chart, expected loss, expense ratio, proc hpsplit, neural network, feature selection	source	30
115	Intelligent Warehousing for ERP: SAS Institute Strategies	Simon Ansfield	Presentation		source	42
116	Intelligently Launching Excel from SAS, using SCL functions ported to Base SAS	Christopher A. Roper	The SAS Companion for the Microsoft Windows Environment illustrates one technique for opening Microsoft `EXCEL` from within SAS using DDE. This technique has several disadvantages. First, it does not check whether `EXCEL` is already open, it can unintentionally open multiple `EXCEL` sessions and this can be problematic. Second, it does not know with certainty when it has opened `EXCEL`, it relies on the SLEEP function to pause processing until a set amount of time has passed. Hopefully, the amount of time is sufficient for `EXCEL` to open successfully, but there is no guarantee. Finally, this set amount of time must be predetermined and sufficient for the worst case scenario (i.e. the slowest machine on which the code might possibly be run). This means the pause is always set higher than the minimum amount of time required for `EXCEL` to open, does not take advantage of the best resources available, and causes the end user to wait unnecessarily	excel, sas base	source	2
117	Internet as an evolutionary tool of the information system	Giovanni Maio	Presentation	life insurance, data mining, logistic distribution, normalization	source	30
118	Intranet-based applications in Bank Handlowy	Zdzisław Dec	Presentation	output delivery system, access control, data standard	source	23
119	Introduction to WebAF: using webAF to create thin-client information delivery Java applications	Mark Torr	Presentation	bar chart, grid computing	source	15
120	Issues in migrating from client/Server to a Web environment	Alessandro Pozzoli, Lindsay Walton, Micaela Cera	Worldgem, a leader in the marketing and distribution of jewelry in Italy, made a decision to standardise on a Web environment as the common interface throughout the company. The impetus for this came partly from its decision to pursue E- Commerce and partly from its decision to use the Internet as a means of communicating with its salesmen. Worldgem already had an integrated and substantial SAS system for analysing its sales, finance, logistics and stocks that were all developed in a client/server environment using Windows. The business advantage that Worldgem was seeking was the ability to distribute information quickly, both internally within the company and also to outside parties via the Internet. This paper discusses the issues, decisions and compromises at both the business and technical levels involved in achieving this migration	data warehouse, logistic distribution	source	7
121	IT Service management in the next century	Foppe Vogd	Presentation		source	12
122	IT Service Quality at BNP	Joel Bourreau, Pascal Maurice	Presentation	oracle, data warehouse, where statement	source	36
123	IT Service Vision and IT Charge Manager: strategic directions	Richard Seery, Simon Ansfield	Presentation	customer satisfaction, phase i	source	34
124	Keeping track of the asylumseeker statust	Frank Koetsier, Onno van den Brink	Presentation		source	21
125	Key factors to booast application development productivity - Best practice in an insurance industry	Buch	Presentation	key performance indicator, reporting	source	33
126	Knowledge Management beyond the buzzword	Frank Leistner	Presentation		source	33
127	KPMG's rating predictor models	Christophe de Noaillat	Presentation	sample, regression analysis	source	14
128	LABORSTA, the International Labour Organization's statistical databases on Internet: a dynamic application with SAS/IntrNet software	Verónique Arthaud Bowen	Presentation		source	7
129	Large warehousing - software/hardware strategy	Wolfram Greiner	Presentation		source	23
130	Legal and Management Cansolidation System - How to calculate the group results	Bonacho	Presentation		source	13
131	Maintaining SAS data sets in a relational model with the Data Table Interface	Frank van der Willigen	Presentation		source	19
132	Methods of Exporting Data to ASCII or EBCDIC	Andrew Wilcox	The `SAS/C226` System offers the programmer a multitude of ways enabling the exportation of data from a SAS dataset into ASCII / EBCDIC text. This paper discusses some of the possible export options which are available across the broad spectrum of SAS versions	dataset, excel, sas output, proc printto, proc step	source	12
133	Model risk - how to survive in the financial model zoo?	Morten B. Pedersen	Presentation	market risk	source	23
134	Modelling of bad loans' reserves	Zbynek Studnicka	It is given by law the commercial banks should make reserves for their bad loans. Nevertheless the Central bank and various auditors can have different criteria of its computing. The bank itself needs to forecast the reserves in different usually ominous situations. An application that will be presented calculates the model of reserves and gives various detailed outputs supporting middle management's tactical control and global output for top management's strategic control.		source	8
135	Monitoring your MS Exchange Server	Chris Luckman	Presentation		source	90
136	MOSII - A new account system the for Dutch Social Security	Jan van der Leeuw	Presentation	premium, proc model, excel, proc step, probability distribution, error message, health insurance	source	19
137	Multivariate analysis of experimental data of a medium size gasoline passenger car operating on a urban expressway	Livia Della Ragione, Mario Rapone	Presentation	multivariate analysis	source	46
138	Myyrap: the data warehouse for a sales reporting system	Jouni Leskinen	Presentation	output delivery system	source	31
139	Network intrusion detection using SAS Enterprise Miner	Kristin Nauta	Presentation		source	47
140	New Features of SAS Data Libraries in Version 8	Luigi Golfieri	Presentation	proc sql, constraint, key, proc step, foreign key, proc download, reject records	source	33
141	New Features of SAS/AF Software	Peter Snelling	Presentation	catalog entry, variable list	source	11
142	New product marketing analysis and launch	Jose Manuel Rey	Presentation	data mining, proc hpsplit, histogram, response variable, correlation, sample, dataset	source	80
143	Nokia Telecommunications Hardware Services' data warehouse solution in intra-and extranet	Jukka Luostarinen	Presentation		source	11
144	OLAP and data delivery from SAP AG's R/3	Claudio Bianconcini	Presentation	extract, operational data store	source	34
145	OLE DB for OLAP: SAS Institute Leading the Way	Duane E. Ressler, Mark Moorman, Randy Pierce	Open access to `SAS/C226` data warehouses means more than just ODBC access to SAS data sets. Today with the growth of OLAP data stores in a SAS data warehouse it is important to offer open access to multidimensional data stores such as those in	data warehouse, proc sql, sample, excel	source	4
146	Operational and management indicators to control heterogeneous systems	Pierre Vandemaele	Presentation	data cleaning, proc freq	source	27
147	Optimising corporate expenses allocation	Julian Rioja, Manuel Rincon	Presentation		source	12
148	Optimising scalable performance data server for HP systems	Gertrud-Elisabeth Bonifer, Udo Schmitt	Presentation	index creation, libname engine	source	47
149	Outlier detection at EUROSTAT	Pacal Loosveldt	Presentation	regression analysis, confidence interval, outlier, time series analysis	source	31
150	Outside Performance through inside information, Effective insurance marketing through intermediaries	Hans Broekhuisen	Presentation		source	38
151	Overview of pharma technology process model components	Patrick O'Donoghue, Tim Thompson	Presentation	clinical research, pharmaceutical industry	source	40
152	PARADISE - Presentation Assist - Rapid Application Development in SAS Environment	Wojciech Sypko	Presentation: This presentation should be viewed under 800x600 resolution, 16 bit color. Otherwise the graphics may be displayed in wrong way		source	35
153	Peace between SAS users and Solaris/UNIX administrators: finding a middle ground	Leigh A. Ihnen, Maureen E. Chew, Thomas N. Keefer Jr.	There are a number of issues from both the perspective of the SAS user and the Solaris/Unix systems administrator to consider when trying to create predictable performance in a multi-user or multi-load environment. Often, unproductive finger pointing between the 2 groups results with each group communicating in a techno jargon that the other group does not understand. Here in the SAS Institute Customer Technology Center, we work closely with a number of customers in a wide variety of situations that include addressing inquiries with regards to performance and optimization. The intent of this paper is to summarize a number of commonly discussed scenarios. Additionally, we hope to establish a middle ground for both the systems administrators and SAS users in order to provide enough information, in relevant terminology, such that both groups can work together when addressing capacity planning, performance questions and/or problem resolution.	proc step, proc contents	source	40
154	Performance tuning tips for HOLAP (Hybrid OLAP) extensions	Carlo Grandi	Presentation	bar chart, class variable, structured data, dataset	source	33
155	Pharmaceutical application for stability (PASS) analysis	Charles Stiffler, Vesna Luzar-Stiffler	PASS is a point-and-click answer to the key issues raised by "marketed products" and by accelerated stability testing in the QA/QC/QI area. The application virtually automates data entry, test scheduling, stability analysis (for both accelerated and marketed products), and FDA reporting. I. Introduction and Overview PASS (product analysis, shelf-life stability) is designed to remove the cumbersome drudgery (and therefore the potential for error) from the key tasks involved in marketed products shelf-life stability testing, namely: data entry, test scheduling, product trend analysis, and FDA (and other regulatory authorities) reporting. PASS also has the capability to integrate accelerated testing outcomes with marketed product outcomes to remove much of the risk in the uncertainty surrounding final product approval	data science, proc reg	source	8
156	Police Data Warehouse in Finland	Ari-Pekka Neuvonen	Presentation	data mart, data validation rules	source	25
157	Principles of data warehousing in Zagrebacka banka	Ivan Vrancic	Presentation	data warehouse, dataset, data mart, data wrangling, retail banking, data cleaning, ledger	source	28
158	Printer Macros	Aswin Bouwmeester	The printer macros offer SAS users on Windows platform functionality to query the current printer and it's settings or change the printer and it's settings. It is also possible to store different printer settings in a dataset and give each setting its unique name. You can then apply printer settings by referring to this name.	sas output, proc printto	source	3
159	Proactive Debugging	Andrew B. Ratcliffe	Presentation	macro call, macro definition	source	28
160	Project for the Publication and Distribution of "intermediate Census for Industry and Services 1996" - Italy	Altieri Patrizia, Liana Veronico	Presentation	data mart, output delivery system	source	29
161	Publish and subscribe to information from the SAS System	Jim Davis	Presentation	dataset	source	26
162	Quality adjusted price index for real estate and land	Antti Suopera, Eugen Koev, Hannu Lehtimaki, Yrjo Vartia	The study and its ADP applications will develop a hedonic index for unbuilt small real estate properties (construction plots) and single-family houses in Finland. The index will describe the quarterly development of the unit prices (FIM/m²) of construction plots and single-family houses of comparable quality. For statistical data, the application exploits the Register of Real Estate Purchase Prices, the Dwelling and Real Estate Register of the Population Register Centre and the Tax Administration's Register of Dwellings and Real Estate. The Register of Real Estate Purchase Prices contains all Finnish real estate transactions since 1985 (approximately 100,000 plot transactions and approximately 120,000 single-family house transactions). The Population Register Centre's Dwelling and Real Estate Register and the Tax Administration's corresponding Register of Dwellings and Real Estate contain all dwellings and real estate properties in Finland (over 1,000,000 plots and approximately 1,000,000 single-family houses). In the index application, real estate-specific data are added from two Dwelling Stock Registers to the data of the Register of Real Estate Purchase Prices.		source	2
163	Quality assurance and SAS Application Development	B. Dudink, A. Geerts, I. König, M. Klijn, E. Lekkerkerker-Smit	Who can not think of examples of SAS applications that are functional and technically satisfactory but do not meet the clients expectations?! In the course of our work we have encountered numerous examples. For instance, a time-record sheet application that enables users to gain insight into budget use. Or a registration system that maps the geographic locations of a large company's branchoffices. Both SAS applications comply with the client's functional requirements and technical specifications. Nonetheless after a short period of time the applications were no longer being used. We believe there to be requirements, other than the functional requirements, which need to be fulfilled in order to increase the chances of success of an application. These additional requirements are being called 'quality requirements'.	proc hpsplit, data mining	source	8
164	Quasi-Monte Carlo applications for financial risk management	Maurizio Mondello, Maurizio Ferconi	Presentation	monte carlo, sample, interest rate, scenario analysis, uniform distribution, sample size, proc calis	source	28
165	Quast: the Monsanto system for quality control and analysis	Stijn Vermeulen	Presentation	sample, moving average	source	22
166	Raychem's worldwide data warehouse and sales reporting system	Paul Padley	Presentation	data mart	source	27
167	Realizing a company's strategy leads to KPI's, EISs and data warehousing	Geert Peeters, Patrick Schillemans, Perry Heijne	To maintain a top 3 position amongst the European mail delivery companies, the Dutch Royal PTT Post (member of the TNT Post Group) focussed on improvement and further automation of their mail sorting processes embedded in the project BP2000. To help realizing their strategy, two mission statements were created: /c183 each day a highly targeted percentage of the mail should be delivered on time; /c183 a highly targeted percentage of this mail should be sorted automatically. PTT management realized that besides automating the workflow, a business intelligence solution was required to support them. They had to find a way to measure the results of their actions, so together with the implementation team they derived the proper Key Performance Indicators. To follow up on these KPI's, an EIS application, called EIS Sorting, was build using `SAS/AF` and `SAS/MDDB`. The application starts from a dashboard system, giving an overview of the different KPI's	flat file, management reporting	source	3
168	Reporting from data warehouse to the internet at the Agricultural Data Processing Centre	Esa Hannula, Jukka Korva	Presentation	data warehouse, excel	source	26
169	Reporting is a-changing	Markku V. Suni	Presentation	artificial intelligence, life insurance	source	19
170	Reporting on Patrol data from 1,000 branch offices	Bruno Peeters, Francine Gheyle	Presentation		source	41
171	Resource Accounting for the Ministry of Agriculture Fishereries & Food (MAFF) UK - A 'CFO Vision' Pilot	David Fisher	Presentation	management reporting, balance	source	18
172	Resource planning with webAF software	Hans van Liere	Presentation		source	15
173	Risk data warehousing: leveraging operational gains	Pankaj Mistry	Presentation	time series analysis	source	23
174	Royal Dutch Airline Business Process Redesign supported by SAS Flexible Data Extraction	Harold van Puijenbroek	Presentation		source	28
175	S.O.C.R.A.T.E.S. Simultaneous Optimal Control by Recursive and Adaptive Estimation Systsem	Giacomo Patrizi	The algorithm that will be presented determines at the same time an accurate estimate and the optimal control policy for a dynamic process, by solving the two underlying optimization problems simultaneously. As is well known the estimation of a dynamic process is reduced to solving a nonlinear least squares problem, which in its turn is a nonlinear optimization problem. Similarly, the determination of an optimal control policy for a dynamic process, presupposes that the system has been estimated in a relevant subregion and then the policy may be determined by solving another optimization problem. Thus severe suboptimization may result when the optimization problems are solved successively. The aim of this paper is to present an algorithm which will simultaneously identify and optimize the dynamic system and to provide convergence and computational results, which will be compared to the SAS Institute's implementations	regression analysis, sample, normal distribution, confidence level, proc nlin, benchmarking, time series analysis, proc step	source	12
176	SAP R/3: Is performance an Issue?	Peter Bailey	Presentation	business intelligence	source	42
177	SAS Applications in the exploring of life beginning data	Jan Andrzej Domitrz, Magdalena Topczewska	The in vitro fertilization has become the frontier of both infertility treatment and research. This method opens up possibility to surmounting infertility consequences, which can be caused by many reasons. The medical doctors from the Department of Gynecological Endocrinology of the Medical Academy in Bialystok are concern with the problem of the low rate of success of the in vitro fertilization procedures. By exploring the available data we try to identify the factors, which could have impact on the results of the in vitro methods. The clinical data contained the numerical results the medical examination of the patients as well as the images resulting from the microscopic examination of the living, developing cells. The SAS application build by us contained the specialized procedures for data manipulation, procedures for statistical analysis supported by graphical presentations	data mining, clinical data, data science	source	4
178	SAS Enterprise Miner templates for database marketing applications	Federico Ambrogi, Guido Cussocrea, Massimo Saputo	Treasure island, an enormous amount of data at your disposal and the best software environment to exploit it. Data Mining is an opportunity to gain a competitive advantage and should supply the marketing decision-makers with operative tools for the evaluation of client potential, the planning of an integrated offer and the selection of campaign targets. Nevertheless data and technology are necessary but not sufficient. To successfully apply Data Mining solutions to Database Marketing activity you need to perform a process flow that starts from goal identification and then passes through making data available, and applying the SEMMA methodology. But this is still not enough: you need to implement the campaign in production, considering not only the new targeting rules, but traditional criteria, cross- sections and control tests. All this comparing budgets with expected break-even per segment and averaging market penetration goals with profit maximisation ones	data mining, sample	source	6
179	SAS Integration Technologies Overview	Steve Jenisch	Presentation		source	49
180	SAS Macros for Grouping Count and Its Application to Enhance Your Reports	Shi-Tao Yeh	This paper provides two SAS macros, one for one grouping variable, and the second for two grouping variables. Both macros count the subjects in the grouping variables and the number of sub-groups. For some report-writing tasks, the number of sub-groups and subjects in each subgroup may vary and cannot be predicted prior to invocation. The macros that perform the counts include an overall total number of subjects and a summation of subjects in each subgroup. They then save the counts as SAS macro variables for later use. This paper also discusses how to use these macros with provided examples to illustrate how to enhance your reports. The SAS product used in this paper is SAS BASE , with no limitation of operating systems	sample, class variable, macro definition, format statement, proc tabulate, proc step, in=, macro variable, data step	source	5
181	SAS procedures for the estimation of quality test methods in test laboratories	Celine Bensoussan	Presentation	likelihood function, restricted maximum likelihood, covariance	source	29
182	SAS software as the spider in the net. Conducting large scale trials, integrating various IT solutions	Henrik Forsman	Presentation	batch job, excel, data cleaning	source	12
183	SAS Software, a tool to evaluate the employment policy	Laurent Sasso	Presentation		source	22
184	SAS solution for analysing side effects of drug	Christine Vander Vorst, Lieve Debaecke	Presentation	business intelligence, dataset, adverse events, proc freq, sas consultant, data cleaning	source	31
185	SAS/AF Software Class API documentation generator	Bart Guijt	Presentation	business intelligence, catalog entry, length statement, macro call, variable list	source	20
186	Scalable data warehousing: storage users and more	Karin Edwards	Presentation	data mining	source	40
187	Scalable Performance Data Server 2.1: an overview of SAS Institute's parallel DBMS	Amitava Ghosh	Presentation		source	36
188	SCOM: SAS Component Model in Version 8 SAS/AF software	Derek Powell	Presentation		source	17
189	Security Concept and Implementation in a Data Warehouse	Christina von Rotz	Presentation	access control, data warehouse, internal audit, investment banking, traffic data, dataset, sample	source	18
190	Segmentation of the Slovenian retail bank market	Anuska Ferligoj, Igor Horvat, Joze Rovan	Bank market is a structure, treated by the banks as a homogeneous group of customers, or as a number of internally homogeneous and externally heterogeneous groups - segments. Segments are formed in such a way, that units within each segment are as similar as possible according to the characteristics (variables) that determine the use of bank services. Banks have two possibilities: 1) they can focus on the bank market as a whole or 2) they can specialize in servicing just a few segments and adjust their services to the specific needs of these segments. Focusing on a few segments leads to high satisfaction of the customers. They have a feeling that the bank has adjusted its service to their needs. This may be the reason for choosing a certain bank.	hierarchical clustering, current account, proc freq, binary variable, proc corresp, multiple correspondence analysis, ordinal variable, consumer loan	source	14
191	Service Level Management methodology	Andreas Noren	Presentation	service provider, customer experience	source	18
192	Shaping the future of clinical data solutions through partnership	James Jury	Presentation		source	10
193	Simulation models using SAS software to study the effect of amendments to legislation	Ferenc Lakó, Peter Szilágyi	Presentation	sas base, excel, bar chart	source	17
194	Smart sourcing is a communication task	Alaa Alagamawi	Presentation	data warehouse, sas programmer	source	21
195	Star's the limit.Ad hoc, cross-subject queries with the SAS system in a dimensional data warehouse	Wojciech Chybowski	Presentation	data warehouse, where statement, data science, data standard, train-test split, dimension table, response variable	source	30
196	Strategic Use of Customer Lifetime Value	Tony Woods	Presentation	sample, regression analysis, customer lifetime value, by group processing, proc freq	source	25
197	Supply chain management a new challenge for SAS data warehousing	Pascal de Poorter	Presentation	data warehouse, i/o, data standard, data science, demand forecasting, fact table, relational database	source	33
198	SYSPARM, CLIST, and MACRO Options for Interactive SAS/MVS Success	James K. Woods	The ancient IBM CLIST ("Command List") technology is still a great way to automate systems processing on MVS, and it works more smoothly for user interaction with the SAS System on MVS than do most other modern application softwares. SAS Software has provided the sysparm, clist, and macro options since 1982 specifically to enable user interaction with the batch mode of SAS. Your advantages with CLIST menus are that you always "get it right the first time" and you need minimal IT intervention. You reduce the possibilities for MVS abends, and you can automatically provide user help in your high-cost MVS submissions.	proc step, proc print	source	2
199	Systems Management and the data warehouse	Richard Seery	Presentation	data mart, capacity planning	source	52
200	Technical analysis and portfolio selection methods	Giuseppe Marcon	In these last few years international biography has offered many examples of portfolio selection methods, amply adopted by big financial institutes, international operators and by investment funds. Indicators used for Ex-Post valuation of selected portfolios are less in number but equally variegated. This poster describes the technical solutions adopted in implementing with SAS System various generalised methods of portfolio selection, integrated into a huge SAS software package for the Stock Market investment support. It then considers the statistical indicators for evaluating the selected portfolios and comparison of the implemented selection methods with mass simulations. All this is described with examples applied to the Italian Stock Exchange: 18 different portfolio selection methods were evaluated considering hundreds of portfolios generated in three different periods in the last four years. Finally, the poster presents the last innovations of PORTFOLIO EXCHANGE as for example, activation of thousands of Hot Spots in all generated graphs. Up-Tecno group has many clients of the Italian financial and banking market and partnership with important banking associations. PORTFOLIO EXCHANGE handles a financial data warehouse with historical series, Portfolio Selection and Technical Analysis methods, which support the decision process of the trader and portfolio manager.	regression analysis, proc step, linear programming, correlation	source	18
201	Technical data management for semiconductor manufacturing on the base on an integrated SAS System	Martin Seith	Presentation		source	31
202	The Analyst Application	Frank Boggasch	Presentation	sample, survival analysis	source	13
203	The Bridge between ERP and Business Intelligence - illustrated by example of SAP Retail and SAS	Frank-Stefan Rock	Presentation	data transformation, business intelligence, quality control, normalization	source	29
204	The data warehouse strategy (service profile for dispostive information processing)	Peter Albrecht	Presentation	data mart, data warehouse	source	50
205	The DIKA system, an OLAP application for the Marketing Department of the Generale Bank using the SAS System	Jean-Pierre van Dessel, Patrick Van der Veken	Presentation	distribution channel, flat file, sas consultant	source	13
206	The four elements of success: Balanced Scorecard ING Bank	Kees Timbers, Popko de Vlugt	Presentation	commercial banking, financial services, private banking	source	31
207	The good, the bad, and the quality	Chris Henricx, Dirk Waegemans, Ignace Follet	Presentation	quality control, insurer	source	21
208	The Implementation of the European data warehouse at Goodyear	Hans Hulpiau, Jean-Louis Hernandez, Jonathan Dean, Thierry Lannoo	The paper will focus on some of the aspects connected with an enterprise data warehouse, in addition architectural components such as warehouse metadata repository, security, application distribution and methodology will be discussed. Special attention will be given to the data flow, extraction and transformation for which the SAS Warehouse Administrator plays a key role. Finally the paper will show how metadata is used to build flexible reporting applications, from EIS to Intranet solutions.	data warehouse, batch processing	source	2
209	The incredible shrinking performance staff vs the collossal expanding server farm	Jean Claude Aron	Presentation		source	26
210	The Methods and Benefits of Implementing CFO Vision in a Financial Services Organization	Gareth Tucker	Presentation	ledger, excel, sas output, dataset, phase i, data warehouse, auto insurance	source	40
211	The migration of the central declaration form processing system of the Hungarian Tax Office into a SAS environment	Katalin Koczkane	Presentation	sas base, data warehouse	source	20
212	The network, a free but expensive resource	Peter Van Gils	Presentation	capacity planning, ledger	source	18
213	The painless way to implement and maintain a balanced scorecard system	Bernadette Ruane	Presentation	sas consultant, excel	source	26
214	The Professional Stocks and Securities Internal Accounting System for Large Banks	UNKNOWN	Presentation	ledger	source	12
215	The SAS Enterprise Quality Solution	Bob Rodriguez	Presentation		source	38
216	The SAS System and the ARM API - A practical implementation of the ARM API	Chris Luckman	Presentation	elapsed time, key performance indicator	source	40
217	The secrets of developing MDDB's and EIS applications without using SAS/MDDB and SAS/EIS - The "Sigma EIS" alternative	Gady Kotler	This paper will describe a commercial product called "SIGMA EIS" which is an OLAP/MDDB development tool. It is an add-on product to our "SIGMA WAREHOUSE" line of solutions, all based upon SAS products. The paper will describe the two basic modules of SIGMA EIS: the SIGMA EIS Application Builder, which is used to develop the GUI for end users and the SIGMA EIS MDDB Builder, which is used to create the "MDDB LIKE" SAS data for the application builder. One of the design goals was to use only three underlying SAS products: `SAS/BASE`, `SAS/GRAPH` and optionaly `SAS/CONNECT`. In spite of this limitation, we wanted to make a robust development tool, which will have enhanced functionality compared to `SAS/EIS` and will offer performance as good as or even better then `SAS/MDDB` has to offer in a client-server environment	dataset, proc step	source	6
218	The squaring of the circle: managed health care - integration of medicine and economy	Georg A. Mathis, Guido Schaub	Presentation	insurer, health insurance, data warehouse, underwriting risk, proc sql, data mart, data mining	source	26
219	The use of Balanced Scorecard in BRFkredit	Tim Thranegaards	Presentation	distribution channel	source	39
220	ThinProway-A Java client to a SAS application - A successful story. Exactly what you need?	Riccardo Proni	ThinProway is a software solution dedicated to the manufacturing industry. The engineer needs a simple and single "console" to access and analyze process and quality data, hiding as much as possible all "not interesting details" like the data format and location. The application environment includes many huge and heterogeneous data sources (GB- dbases; 100-GB file repositories). TXT Ingegneria Informatica has a long and deep experience in the field: we have developed a SAS application (FMOS Proway) composed of a powerful data warehouse- oriented kernel with a single and efficient user interface. A continuous successful story since 1992 in one of the main microelectronics companies. ThinProway is a "thin-client" evolution based on Java and `SAS/INTRNET`	data science, set statement	source	9
221	To beans or not to beans: an intitutive Web solution with SAS/IntrNet Sofware and JavaScript	Benedikt Amacker	Presentation	sas batch, batch job	source	32
222	Total Financial Management Strategies	Peter Bull	Presentation	key performance indicator, financial reporting	source	30
223	Tracking research of public information campaigns in the Netherlands	Piet van Montfort, Stephan Kordelaar	Presentation	sample, dataset	source	32
224	Traffic accidents and the road network in SAS/GIS	Frank Poppe	The first figure shows a screen snapshot of `SAS/GIS` with part of the network of a city. Some feed-back options are turned on: at the top of the `SAS/GIS` window you see: 1) the current position of the cursor in X and Y co-ordinate in the used system, 2) the current scale, and 3) the name of the street the cursor is on (which is one marked with a fat U-shaped arrow in the centre of the figure). In the name of street you may recognise the official address of the SEUGI 17 venue, and the streets you may recognise as the surroundings of the Netherlands Congress Centre in The Hague. In the figure you also see a collection of markers. These are all traffic accidents that have been registered by the police in the past 10 years. In this presentation I want to show how SWOV, the Institute for Road Safety Research in the Netherlands, uses the SAS system and particularly `SAS/GIS` for maintaining and analysing the accident databases we receive each year. I will first describe shortly the kind of data we receive, and why we decided to use `SAS/GIS`. Then I will say something on the properties and possibilities of `SAS/GIS`, one of the probably lesser known SAS products. The demands on the organisation of the databases are touched upon as well. Finally I will go into the possibilities this has given us for several kinds of research projects, and the small applications we have developed (and plan to develop further) to provide for features not (yet?) standard available in `SAS/GIS`	dataset, proc step, correlation	source	6
225	TWIGGI-A very lean Web client for your data warehouse	Wolf-Dieter Batz	Presentation		source	35
226	UBS data mining factory: a key success factor to increase profitability in retail banking	Adrian M. Weiss, Frank Block, Patrick Schünemann	Presentation	proc standard, dataset	source	12
227	Universal system for distribution of data and reports from SAS applications	Pawel Machalski	The system makes it possible to create quickly a distribution system for work results of numerous applications, written and started under the control of the SAS system at the server. The basis of the system is the applications metabase containing, among others, information about: /c183 all registered applications, /c183 users, /c183 distribution channels. The system offers the ready-to-use distribution channels: /c183 to `SAS/CONNECT` and `SAS/SHARE` servers /c183 to RBDMS servers (with `SAS/ACCESS` dimension and capabilities) /c183 via Intranet (to www, e-mail, ftp servers). 1. Presentation Plan 1. Business Assumptions 2. The System Concept 3. Technical Solutions 4. A Sample Application	distribution channel, sample	source	6
228	Using HR Vision with SAP AG's R/3 at a large manufacturing company	Michael Silva	Presentation	data warehouse, proc sql	source	30
229	Using ODBC and OLE to interface SAS software with MS Word	Robert Addis	The use of SAS has been fundamental in Quintiles' clinical trial reporting. However, using some of the more advanced features available in Windows 3.1, 95, 98 and NT, Quintiles has investigated new techniques that enable us to present our clinical trials SAS analyses to a far higher quality than has ever been possible before. A method that conforms to all of the strict operating procedures by which trials must be reported.		source	12
230	Using SAS and DDE to Execute VBA Macros in Microsoft Excel	Christopher A. Roper	Visual Basic for Applications (VBA) is the programming language Microsoft uses for all their desktop products, including Microsoft `EXCEL`. VBA allows programmatic control for virtually all the functionality of `EXCEL`. Because of the popularity of `EXCEL` as an end-user tool and the power and flexibility of the SAS System to deliver information, integration of these two resources is inevitable. One of the most popular and powerful protocols for integrating SAS and `EXCEL` is Dynamic Data Exchange (DDE). However, SAS can not send VBA commands to `EXCEL` using DDE. This paper will present a technique for circumventing this limitation. A VBA macro can be recorded in an `EXCEL` workbook, and then that macro can be executed by a SAS application using DDE and a command from the `EXCEL` 4.0 macro language	excel, xls	source	4
231	Using SAS in a Newspaper Marketing System	Luis Bettencourt Moniz	Presentation		source	15
232	Using SAS Software as a Decision Support System on Top of SAP FI Financial Accounting Module	Ida R. Carapelle	Financial information is vital for all departments of a company. The requirements in terms of analysis are different depending on each department's approach (marketing, sales, finance, production....) This paper will give solutions to allow the different company departments to exploit the financial information coming from SAP/FI adding their own views, dimensions and information. It will be demonstrated how to exploit the data coming from the General Ledger and Account Receivable (SAP-FI 'GL-AR') modules to build : A Decision Support System and a CFO Vision software interface for consolidation purpose	ledger, data dictionary	source	5
233	Using SAS software in a newspaper marketing system	Luis Bettencourt Moniz	Presentation		source	15
234	Using SAS software with other packages to produce faster and more reliable analysis of adverse events in clinical trials	Michael O'Kelly	Presentation	adverse events, clinical trial	source	34
235	Using SAS/IML to fit embedded models to accelerated life test data	Alan John Watkins, Richard E. Johnson	This paper presents an algorithm for fitting accelerated life test models based on the Burr XII distribution and a flexible parameterisation of its scale as a log-linear function of the accelerating stress factor. Practical problems thus include the numerical determination of the maximum likelihood estimates of two shape and two scale parameters. The approach outlined here uses a natural extension to the fitting of the three parameter Burr XII distribution, and hence exploits the fact that the Weibull distribution is embedded in the Burr XII distribution. The algorithm thus includes a direct comparison of the goodness-of-fit obtained from the two distributions. The paper discusses in detail the performance of the algorithm on a published data set. It is further argued that the algorithm is, by design, relatively robust and that, in some cases, the Burr XII distribution offers substantial improvements in goodness-of- fit over the more traditional Weibull approach	likelihood function, weibull distribution, maximum likelihood estimation, sample, standard deviation, proc means, predictor variable	source	7
236	Using the Web to view your data warehouse	Frank Nauta	Presentation	data warehouse, data validation rules, proc freq	source	29
237	Using webEIS to create thin-client Information Delivery Java applications	Anton Fuchs	Presentation		source	19
238	Utilising the Windows NT registry from within SAS software	Rudy Gyzen	Presentation	excel, output delivery system	source	19
239	VELIX-Building the controlling and planning system concerning bonds, stocks futures and other securities for the DG Bank	Heinz-Peter Dickerman, Jochen Kissel	Presentation	proc sql, data science	source	31
240	Version 6 and Version 8: A peaceful c0-existence	Richard Doherty	Presentation	proc step, libname statement, proc copy, catalog entry, proc cport, proc sql	source	46
241	Version 8 of the SAS System under Windows	Jennifer Bradshaw Clegg, Pat Bostic, Thomas Goettsche	Presentation	proc print, proc step, catalog entry, cpu time, sas library, sas output	source	56
242	Visualising large data volumenes with SAS/MDDB server, SAS/CONNECT, SAS/EIS software and HOLAP add-ins	Daniel Morris	Presentation	dataset, data step, proc means, reporting, proc step	source	29
243	Web support for the Sales and Marketing division of Panasonic Battery Sales Europe	Dirk Storms	Presentation		source	24
244	Web warehousing from down under	Jon Pallas	Web Warehousing is my term for the integration of internet/intranet technologies and a data warehouse or datamart. Without data driven design which is made possible by the presence of a data warehouse, robust, dynamically updating web applications would not be possible. In building web applications using SAS, the use of other technologies such as Javascript, Java, and Cold Fusion can simplify and speed development and get the most out of SAS and the web. This paper will examine a "real-life" application illustrating the many benefits of a thin client solution: ease of use, speed of delivery, reduced costs of distribution, reduced maintenance etc. Sample code will be provided and worked through. Tips on producing dynamically data driven web forms will be provided. As security is paramount in any application, security will be examined in relation to using SAS and the web.		source	11
245	What's new in SAS Enterprise Miner, Version 3.0	Gerhard Held, John C. Brocklebank	Presentation		source	16
246	What's New in SAS Enterprise Reporter	Scott Anderson	Presentation		source	29
247	What's New in SAS/Warehouse Administrator Software	Scott Anderson	Presentation	data validation rules, proc freq	source	37
248	What's new with SAS/EIS Software	Karin Essmann	Presentation	access control, bubble plot, audit trail, catalog entry	source	25
249	What's new with SAS/IntrNet software Version 8	Mark Torr	Presentation	proc step, grid computing	source	47
250	What's new with Version 8 and SAS/Access software	Luigi Golfieri	Presentation	proc sql, proc step	source	41
251	Working with SAS/ACCESS software views onto ClinTrial panels and Oracle tables	Adrian Jones	Presentation		source	28

Back to Conf go 2000 go 1998

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.