HOME
QUICK SEARCH
AUTHORS
KEYWORDS
HELP
BUGSSEUGI 1998 Papers - Index
138 papers. Source: SEUGI (SAS European Users Group International) conference proceedings.
| # | Title× | Authors× | Abstract× | Keywords× | Extras | Pages |
|---|---|---|---|---|---|---|
| 1 | "The Scorecard": Balanced decision making at PGGM | Monique Gerritse-van de Brug, Rob Bello |
Presentation | data warehouse, management reporting, application scorecard | source | 35 |
| 2 | A branch management information system at Kredietbank: using rapid MDDB implementation and exploitation | Jurgen Sprengers, Veronique Morthier |
Presentation | sas base, mis, management reporting, proc step | source | 17 |
| 3 | A data warehous that continues to develop: Five years of hands-on experience and future prospects | Peter Cramer | Presentation | proc sql | source | 19 |
| 4 | A Data Warehouse Solution for Account Management | Elena Battini | In 1996, the NUOVA MAGRINI GALILEO, a company belonging to the SCHNEIDER group, started a review process of its control system. The need of adopting the DW philosophy for data processing falls within this context. The project "DW Controllo Gestione" has seen the | excel, data science | source | 4 |
| 5 | A management indicator based on Statistical Process Control data: the average percentage of non conformity items | K. Hadadj, Thierry Cembrzynski |
To prosper in today' s economic climate, we - at Renault automotive- are dedicated to never-ending improvement in quality and productivity in order to produce vehicles that satisfy customers' needs. To accomplish this, the Process Validation Division under the direction of Michel Chambon has built an efficient strategy of control based on Statistical Process Control (SPC) tools such as control charts, capability indices, acceptance tests to waranty the process conformity. As far as the very high level management is concern, our paper deals with a control chart over the average percentage of ' ' non-conforming ' ' (NC) of a panel of measured characteristics in order to estimate, on a month basis the plant' s process performance. This indicator is computed with all the data gathered through the control system put in place by the Validation Division; it does function at the plant of Flins (Paris suburban) for the new Clio | sample, normal distribution, standard deviation, data cleaning | source | 19 |
| 6 | A Methodology for Developing SAS Applications for Use in Multiple Languages | Christopher A. Roper, Gina M. Thomas, Michael Gilman |
Developing SAS applications that will be used in several countries, each with its own native language, presents unique challenges for the SAS applications developer. This paper will present a methodology for developing a SAS application that may be used in any number of languages, without requiring a rewrite of the application code for each language translation. The application is developed once, the translation methodology is applied once, and then the application can be translated as often and to as many languages as is necessary, without having to rewrite any of the original application code | macro variable, call symput | source | 4 |
| 7 | A methodology for developing SAS software applications for use in multiple languages | Christopher A. Roper, Gina M. Thomas, Michael Gilman |
Developing SAS applications that will be used in several countries, each with its own native language, presents unique challenges for the SAS applications developer. This paper will present a methodology for developing a SAS application that may be used in any number of languages, without requiring a rewrite of the application code for each language translation. The application is developed once, the translation methodology is applied once, and then the application can be translated as often and to as many languages as is necessary, without having to rewrite any of the original application code | macro variable, call symput | source | 4 |
| 8 | A Micro-Simulation Modelling System for HM Treasury | Andrew Beggs, Daniel Morris |
The SAS System was used to create a parameter driven application for micro simulation modelling the Tax and Benefits System in the UK. Her Majesty's Government approached Amadeus Software, a SAS Institute Quality Partner in the UK, to develop a parameter driven application that would analyse and manipulate household, tax-unit and adult level data. Detailed reports describing the effect of policy changes were required along with exploratory tools for data mining. Amadeus accepted the task and developed the Micro-Simulation Modelling (MsM) System. MsM was first used in consideration of the UK Governments' budget in June 1997. | dataset, excel | source | 10 |
| 9 | A Multi-region Multi-sector model for the evaluation of Demographic and Economic Scenarios | Elena Forconi, Cristina Maranzana |
Given the increasing need of intervention at a regional level, the RGS (the Italian Government Accounting Office) has started a research activity with the intention to build a multi-regional, multi-sectoral, demographic and economic model aimed at the production of consistent medium-long term forecasts. For its functioning the model needs a number of exogenous hypothesis, some of demographic kind (for ex. fertility rate, number of immigrants from abroad) and others of macro-economic kind (for ex. growth of national demand). As for the structure, the model is articulated in two main sub-models that produce forecasts, in a detailed and consistent way, of the main characteristics of each region, both demographic (amount and structure of the population) and economic (amount and composition of National Accounts of resources and uses). All this respecting the ties of the possible interactions within the demographic and macro-economic components | macro facility, proc sql | source | 6 |
| 10 | A SAS Data Warehouse on Open VMS (AXP) | Giampolo Trenta | Presentation | access control, data warehouse | source | 10 |
| 11 | A SAS/IML algorithm for maximum likelihood estimation in the Three Parameter Burr XII Distribution | Alan John Watkins | This paper outlines an algorithm for calculating the maximum likelihood estimates of the three parameter Burr XII distribution. The algorithm exploits the link between this distribution and the two Weibull distribution, which emerges as a limiting case of the distribution, and also calculates a discriminating Δ statistic, used to determine which distribution provides a better fit to data. A SAS/IML implementation of the algorithm is discussed in some detail, and we illustrate our discussion with the output from this implementation for published data sets. Key Words : Burr XII distribution; data rescaling; maximum likelihood estimation; Weibull distribution |
likelihood function, maximum likelihood estimation, weibull distribution, cumulative frequency, probability distribution | source | 7 |
| 12 | A SLM: the balancing act of the service industry: Working together to fulfil customer wishes better, faster, and at less cost | E. Hulshof, Johan Hoogerbrug |
In this presentation we will discuss this changing role of the service industry, discussing above questions and resulting issues. We will see that an integrated part of the solution connected with the above questions is supporting the management need for better and more reliable information, using techniques as Activity Based Costing and Service Level Management. The goal is to achieve the optimal balance between profitability and quality. At the end of the presentation we will discuss A-SLM, a management information system, providing the ability to measure real costs and quality. | quality of service, distribution channel | source | 22 |
| 13 | An introduction to Customer Relationship Management | Annie Postic | Presentation | source | 51 | |
| 14 | An introduction to the PH-Template Developer's Kit extension to SAS/PH-Clinical | Alan Reading | Presentation | pharmaceutical industry, raw data, proc step | source | 15 |
| 15 | An overview of SAS Software SPDS | Jochen Kirsten | This paper will discuss the features, usage and benefits of using the Scalable Performance Data Server (SPD) 2.0 as an enterprise wide storage for SAS Data Sets specially optimized for Data Warehouse and Decision Support applications | proc sql, proc step, sql pass-through, sql server, where statement, create table, libname statement, proc append, access control, dataset, group by, index creation, macro variable, parallel processing, select | source | 24 |
| 16 | Are you thinking about investing in SAS/Warehouse Adminstrator software? | David Price, Tina Hunt |
You have spent the last two weeks happily generating data extraction processes using SAS/WAREHOUSE Administrator and have now reached the point where they need to be run together in a predefined sequence. The data generated then needs to be written to your data warehouse in a certain order to ensure referential integrity is correct. So what do you do? Where do you start? A couple of SAS macros and a little SAS/AF code solves your problem. A macro is method by which you can automate repetitive actions, ensure that they are always processed in the same way and ensure that everyone abides by the same standards. The macros can be run stand alone from base SAS or called from SAS/AF. This paper will demonstrate how easy it is to automate the read and write processes using macros and how little AF coding is required in order to have a very simplistic front end to further simplify the process |
data integrity, proc sql | source | 10 |
| 17 | Auditing security under OS390 with SAS/CPE software | Giampaolo Florese | The paper is mostly based on actual demonstration of the real life working application. Performance, accounting, service levels: concepts that allow many numbers and interpretations. Each company department thinks to have the correct one, but often they "forget" to declare the coming source and do not make publish the aggregation and/or transformation laws used. From that kaos, a lot of resources are often lost to find which are the correct data and the right | source | 4 | |
| 18 | Autocorrelation as an artificial reponses detector: an IML application | Efraim Darom | A common knowledge among researchers who collect data using questionnaires is that not all people give reliable and valid responses to items presented to them. The term 'Response Set' has been used to mark individual tendencies to agree, to disagree or to refrain from expressing a clear attitude. Other tendencies like generalized perception , and trying to guess the 'correct' response, were termed 'Halo Effect" and "Social Desirability' respectively. Enormous effort had been invested to detect and correct such tendencies . People who write attitude items make sure that some of the items are expressed in a negative manner. This way a person who tend to agree to all items will not be considered as having a positive attitude toward the target object, Many personality inventories include 'Lie Scales'. People score high on such scales if they respond in an unlikely manner to certain items and consequently deleted from the data set. | correlation, lag function | source | 6 |
| 19 | Balanced Business Scorecards and Management Reporting: A Case Study of a Pharmaceutical Company | Oliver Schalch | Many of today's companies have an apparent surplus or "overload" in the area of management information, based on the data volume produced by the transactive systems as SAP or BAAN. This information overload can lead to ineffective management decision making. This paper presents a successful project resulting in a MIS-"cockpit", focusing on those key performance indicators which have significance for top management. It shows how to link financial and non-financial key performance indicators (customers, processes, innovation, staff) in a KPI hierarchy cascaded to the different management levels. In addition it demonstrates how to identify the essential KPIs for each manager and his Balanced Business Scorecard. Based on these scorecards, the reporting systems have been redesigned, resulting in a significant realignment of management and controlling effort and a dramatic reduction of in the number of management reports | key performance indicator, management reporting | source | 5 |
| 20 | Barclay View: End-to-end and business transaction performance reporting in a client/server environment | Derek Cowell | Barclays Bank is one of the major financial institutions within the UK. These notes describe the steps that have, and are being taken to manage the IT services delivered to UK Banking Services. | elapsed time, retail banking | source | 29 |
| 21 | Be free from the burden of obligatory reports in the banking environment | Attila Papp, Tibor Simon |
Creditanstalt Ltd - regarding to the measure of market share and profitability - is about at the fifth eighth place in the rank of all (45) banks in Hungary. Our mother-bank is the Bank Austria Creditanstalt AG of Austria. The Hungarian subsidiary has 20 own branches. The amount of total assets in 1997 reached 770 million USD. In the last two-year period it has more than doubled its activities and business volume, and since the IT background - and especially the reporting subsystem was planned for a small bank, it was very urgent to set up a proper information system. The paper discusses the crucial problems of the conventional, operational system based reporting, the main features and key ideas of the CASIR, and how it helps improving the efficiency of the bank. | excel, data warehouse | source | 6 |
| 22 | Bioequivalence standardized | Julian Singer | As the attention of pharmaceutical companies focused towards generic drugs, the design and analysis of bioequivalence studies - aimed to demonstrate bioequivalence between the generic and original drug product - have gained an increasing importance over the past decade. Their usual 2x2 cross-over design is suitable for standardization because ICH and FDA guidelines prescribe clearly the procedures to be applied. | confidence interval, sample size, outlier, proc step, sample | source | 6 |
| 23 | Building a data warehouse successfully with SAS Software: The Dutch PTT Post approach | Stef Lagomatis | Presentation | management reporting, data warehouse | source | 17 |
| 24 | Building an ALM system for the Insurance Industry | Koen Van Huffel, Marc Hansenne |
ALM systems are having a breakthrough in the insurance sector. This is a response to factors as an increased variability of financial markets coupled with new insurance products and a fierce competition with the banking sector. In contrast with the banking sector, where ALM is since years a known technique, insurance companies have to build this know how. Moreover, the system and the organisation to make an ALM system operational must be implemented. We will give a brief discussion of what ALM is, and which components are needed, in order to guarantee a flexible and open system. We will see that ALM fits in a RISK management approach that monitors issues as performance, risk, solvability and liquidity. Given the major components of an ALM system (data input from a data warehouse, front-end, calculation box, report generator) we demonstrate why the SAS System offers an ideal solution as a platform to build an ALM system for your organisation | interest rate, interest rate risk, insurer, insurance, ifrs 17, survival analysis, liquidity gap | source | 7 |
| 25 | Building powerful SAS/AF applications using OCX controls | Henrik Forsman, Martin Sjoholm |
This paper describes how SAS/AF developers can take advantage of the OCX technology to enhance their applications. In recent versions of the SAS system, third party OCX controls can be used in the SAS/AF development environment as OLE objects. This gives the developer the possibility to enhance the graphical look and feel of applications as well as the possibility to use functionality not included in the SAS System. The paper describes how to communicate with third party OCX control through events, properties and methods. Issues like event maps and property pages are discussed in depth. Further more the paper gives a brief description of how to design OCX controls in Microsoft Visual Basic 5 for use in SAS/AF. Finally examples are given on how to encapsulate OCX handling in SAS/AF classes to create an easy to use interface between SAS System and the OCX. |
sas base, elapsed time | source | 12 |
| 26 | Business Intelligence and supply chain management | Sander Piet | Presentation | i/o, clinical trial | source | 20 |
| 27 | Campaign management and customer profiling: How to close the customer circle | Amat Barrasa | Presentation | sample, customer segmentation | source | 15 |
| 28 | CATALOGER: An Application Development Tool to View, Compare and Document SAS Catalogs and Data Files | Christopher A. Roper, Gina M. Thomas |
This paper will present an application written entirely in SAS that greatly enhances the developer's ability to develop, compare, and manage SAS catalog entries and datasets. This application has point and click capabilities for printing catalog entries, including images of frame entries and complete descriptions of associated widgets directly into Microsoft Word documents, creating publication quality documentation at the push of a button. The batch printing facility allows for printing of all catalog entries of virtually any type, including Program, Source, SCL, and Slist (including expanded sublists) entries. The text searching facility will search through all text-based entries for character strings and allow point and click access to the locations in any catalog entry containing the text string | catalog entry, catalog, dataset | source | 6 |
| 29 | Complementary use of log-linear modelling and correspondence analysis in SAS software | Jon Paul Laka, Izaskun Astondoa |
Data mining impplies intensive use of several data analysis techniques, where combination of these techniques proves to be very useful. In this manner, the complementary use of Correspondence Analysis and log-linear modelling applied to the analysis of complex contingency tables as proposed by Van der Heijden, de Falguerolles and De Leeuw (1989) needs the combination of several SAS procedures. Log-linear analysis helps at the data structure level while Correspondence Analysis through graphic display helps at the interpretation level. Our paper shows how to deal with this complementary analysis using SAS tools, where a log-linear model is fitted in order to define the structure of the two-way contingency table to be analyzed by Simple Correspondence Analysis. In this manner, our paper shows how to deal with several SAS procedures (GENMOD, CATMOD and CORRESP) to achieve this goal. Furthermore, this complementary use needs the definition of macros through PROC IML where Generalized Correspondence Analysis (Escofier, 1983) or Joint Correspondence Analysis (Greenacre, 1989) are implemented. This complementary analysis, together with the use of the macros previously mentioned, have been succesfully applied to large datasets as the Spanish Labour Force Survey and the Basque Health Survey data, where more than 100,000 observations are analyzed. |
proc corresp, likelihood function, proc freq, proc step, degrees of freedom, data visualization, interaction effect, main effect, proc genmod, sample, proc princomp | source | 18 |
| 30 | Corporate financial reporting via the intranet: Forget the fat monthly paper reports | Erik Stricker | Presentation | financial reporting, excel | source | 23 |
| 31 | Covering technical provisions at Verlandi Group | Ingrid Tolvas, Jukka Korva, Peter Volin |
The objective of the data warehouse pilot system is to produce the various reports required by the Ministry of Social Affairs and Health. These reports are the essential requirement for the license needed for practising insurance business in Finland. Since Verdandi uses systems operating in different environments (among others Windows NT, OS/2, RS/6000, AS/400 and IBM S/390) all the required reports have until now been made primarily manually. The increasing demands by the Ministry alongside with Verdandi's rapid growth and the diverse information system architecture have made the reporting very difficult. | insurer, technical provisions, life insurance, txt, excel | source | 5 |
| 32 | Customer Performance System: Information for competitive advantage | Jacques Recourdon | Presentation | service provider | source | 30 |
| 33 | Customer relationship management (CRM) research: How to spot, understand and respond to marketplace change signals | Charles Stiffler, Vesna Luzar-Stiffler |
The primary goal in most customer relationship research situations is to make choices..., i.e., to measure, monitor (over time), and take optimum action using "fresh" periodic customer feedback data (i.e., primary data). Using live feedback combined with legacy data, expert opinion, and a variety of decision support tools allowed CAIR Center researchers to apply strategic marketing concepts (market segmentation, buyer/user targeting and product/service positioning concepts, e.g.) so as to forecast potential future demand opportunities at the industry, organizational, and product/service levels. (Usually, the forecasts are a result of "data mining" operations using: data on what people say, what they do, and what they have done to help reveal key signals to imminent marketplace change.) Multivariate statistics, data warehousing software and large data base "mining" tools (e.g., SAS 1) are vital to this "discovery" process | data science, market basket analysis | source | 7 |
| 34 | Danske Data A/SAS software does not have any problems with the Year 2000: But how do we go about finding and correcting our own "sins" of not using SAS data | Per Odgaard | Presentation | dataset, date variable, insurer, life insurance, sysdate9, macro variable | source | 28 |
| 35 | Data mining as a tool for Customer Selection | André Hønsvall, Nils F. Haarvardsson |
Presentation | data mining, life insurance, data warehouse, label statement, combined ratio, earned premium, predictor variable | source | 20 |
| 36 | Data Mining at IMS America: How We Turned a Mountain of Data into a Few Information-rich Molehills | Jerry Kagan, Paul Kallukaran |
IMS America, a division of Cognizant Corporation, is the principal source of information used in marketing and sales management by health care organizations throughout the United States. Of the various potential applications of neural networks, pattern recognition is considered one of major importance. This paper presents the results of using neural networks to classify time-series data into several trend pattern classifications [e.g., Increasing Trend, Decreasing Trend, Shift Up, Shift Down, Spike Up, Spike Down, and No Pattern], and the information generated from the classifier is used to detect various marketing related phenomena [e.g., Brand Switching, Brand Loyalty, and Product Trends]. The data used for the test consisted of prescription data for 12 months, for 600,000 prescribers writing four drugs in the Anti-ulcer market | neural network, network optimization, time series analysis, dataset | source | 7 |
| 37 | Data warehouse as an organizational tool in the Institute for Tourism | Blazenka Vrdoljak-Salamon, Zrinka Marusic |
As a research institution, the Institute for Tourism (IT) is involved in basically two types of research projects. IT regularly produces commissioned studies, which generally greatly vary from one another covering a relatively broad selection of topics and involving the performance of ad hoc analyses. The Institute also works on the so called continuous research projects which generally involve the analysis of time series, forecasting and market research. As of November 1997, the Institute has become a user of the SAS System software which has met a set of very strictly outlined performance limitations and conditions: heterogeneous data, differing data sources, impossibility of standardizing data analysis (use of statistical methods, time series analysis, ad hoc queries and analyses, multidimensional tables), a minimal staff trained in SAS applications and, last but not the least, a very limited financial budget | time series analysis, excel | source | 11 |
| 38 | Data Warehouse+ | Willem Wegman | In the pharmaceutical industry, sponsors are constantly developing new medicines. These medicines have to be tested very carefully before they are introduced in the market. Usually several years pass by before they can be sold. Many times the medicines do not even make it to the market. Therefore, the process of bringing a medicine on the market is a very expensive one. Reducing the amount of time necessary to develop or test the medicine may result in cost savings of several million dollars. On the other hand, if there is a delay this will cost the sponsor at least the same amount of money or more. Other sponsors might develop equivalent products and thereby reducing the time for the sponsor of having a monopoly. This will always turn out in a loss of money and, maybe more important, market share. It might even result in the fact that the medicine will never reach the market. | management reporting, clinical trial, logistic distribution | source | 2 |
| 39 | Data Warehousing and application development using client/server computing | Miroslav Orlovsky, Veronika Hornikova |
The fundamental characteristic of client/server computing is distribution of computing resources (e.g. data, compute power) across different computers. The idea is to divide applications into logical segments (tasks) so that they are then performed on platforms most appropriate. | data wrangling, conditional do loop, mis, data warehouse, management reporting, raw data | source | 12 |
| 40 | Data warehousing in a call centre environment Media Warehouse/Telenor Media | Anders Hotthe, Per Steinar Tafjord |
Telenor Media is a subsidiary of Telenor responsible for value-added services in the area of call centre services and Yellow pages products. The present focus on Media Warehouse is the operations of directory inquiries call centres. | source | 10 | |
| 41 | Data warehousing to support commercial reorganisation | Eddy Volcher, Philippe Colpin |
Presentation | data mart, data warehouse, insurer, clinical trial, distribution channel, quality control, star schema | source | 46 |
| 42 | Database marketing applications in the Italian banking sector | Alberto Saccardi, Guido Cuzzocrea |
Many database marketing projects in Italian banks have been started before the development of a Data Warehouse and without a specific Data Mining expertise within the company: these projects have the goal of obtaining operative tools for marketing activities, such as cross-selling. In our experience, these projects are the best way to test costs and benefits derivable from larger investments in Data Warehousing and Data Mining: dealing with the selection of a work group, the design of a Marketing Data Model, the implementation of data analysis results and, finally, with the evaluation of the return on investment, the company has the opportunity to validate and justify the strategic evolution towards Data Warehousing and Data Mining. To gain a competitive advantage, banks have the opportunity to exploit the enormous amount of data at their disposal | data mining, sample, predictor variable, data science, policy, data warehouse, neural network, current account, data standard, fact table, financial services, life insurance, proc freq | source | 8 |
| 43 | Defining groups of "typical investors": hierachical clustering for qualitative data | Raffaela Piccarretta | In this work we deal with the problem of defining clusters of individuals according to their portfolio choices. More precisely, we consider individuals classified according to six possible financial investment choices in the Italian market (Shares, BOT, BTP-CCT, Repo, Assets Management, Foreign Bonds). As, due to privacy respect, it was not possible knowing neither the percent of capital invested in each investment choice or the total amount of invested capital, the only reliably collectable data were the "presence" and the "absence" of each investment type in each individual's portfolio. We have thus to define clusters on the basis of a vector of binary data, or, more generally, we have to cluster individuals classified according to the categories of nominal variables. In this work we thus analyze illustrate developed at this aim, propose new measures to evaluate the obtained groups, which are more sensible to the nature of data and introduce new algorithms for divisive clustering | sample, nominal variable, binary variable | source | 7 |
| 44 | DEMOGRAPHY: The system for presenting demographic conditions and development in Slovakia | Josef Chajdiak | There are demographical data descibing the Slovak republic's territory (period of 1919 or later), in the first section. This part covers the indicators: mid-year population; number of Slovaks, Hungarians and other nationalities; live-births; overall fertility; life expectancy for males and females; infant mortality rate (deaths in 1 year of the age per 1000 live births); number of marriages; number of abortions. The figure 1 shows DEMOGRAPHY system's menu for this section. The data are presented in table and graph form. | source | 5 | |
| 45 | Development of an interactive review and reporting tool based on SAS/PH-Clinical software | Sylvia Pratz | Presentation | adverse events, system organ class | source | 33 |
| 46 | Development of client/server-based financial data reporting and data exploration system | Paul Murray | This paper describes the development of a financial data management system, demonstrating some of the facilities provided by the SAS System to meet the system requirements. The application was written from a specification written by Base 3 Systems, after consultation with the manager of the team now using the system. The application, written for a large financial institution, brings together data on the companies managed assets and liabilities to calculate the exposure to risk present in the data. The data is sourced from a DB2 database, the data required is extracted and summarised to various levels within a batch SAS job. During the summarisation other routines carry out a projection on the future liabilities and asset positions and a profit and loss analysis. The summarised data is downloaded to PCs on an OS/2 network. An application resides on the PC, allowing navigation down (drilldown) and across the levels of summarisation. At the lowest level of drilldown an on-line query is made to the DB2 database to obtain and download the actual transactions that make up the summarised data. | dataset, batch job | source | 8 |
| 47 | dib-eisa tool for developing controlling applications | Oda Bellingrath | Building a data warehouse often does not solve the following problems: There are still programming skills needed to analyze, select , sort and summarize the requested data, to produce reports, to define and view drill-down levels, ... As a controller or an executive you just do not want to deal with this. You are familiar with the look-and-feel of your spreadsheet application and that is exactly what you want for retrieving the information you need. Often your field organisation or branch office can not get access to the information they have to work with. Or your field staff has to deal with complicated update mechanisms to keep their reports up to date, instead of having direct access to the enterprise-wide data warehouse by using a laptop, a modem and just a browser software. | data warehouse, proc sort | source | 7 |
| 48 | Displaying and comparing correlated ROC curves with the SAS software | Barbara G. Schneider | Diagnosis is an essential part of clinical practice. Much medical research is carried out to improve methods of diagnosis. Medical tests are developed for diagnosis purpose. Thus statistical methods of evaluating and comparing the performance of such tests are of great importance. A test is associated with an observed variable which is able to discriminate between a diseased and non-diseased population. If this variable lies on an ordinal or metric scale an assessment of the overall performance of the test can be made through the use of the Receiver Operating Characteristic (ROC) curve. Correlated ROC curves arise when two or more different tests are performed on the same individuals. The poster presents an approach to display and compare correlated ROC curves with the SAS Software. SAS code using Base SAS, SAS/STAT and SAS/GRAPH is reported |
roc curve, proc logistic, logistic distribution, proc step, sample | source | 8 |
| 49 | Electronic documentation of statistical workflow in clinical research using a SAS application | Merras Teo | Presentation | clinical research | source | 9 |
| 50 | Enhancement to SAS/Warehouse Adminstrator Software | Scott Anderson | Presentation | source | 17 | |
| 51 | Enterprise computing with Windows NT and Intel | Mark Friedman | Presentation | sample, key performance indicator, fullstimer | source | 46 |
| 52 | ERA-MIS: A business information delivery system for the new millennium | Arthur Quinn, Grant MacIntryre, Stephen McCrory |
Towards the end of 1997 Breakout Solutions Limited was formed and contracted to develop a Management Information System and provide consultancy on the telebanking process for Standard Life Bank - a company which had recently been set up by Standard Life Assurance Company (the largest life assurance company in Europe with £52bn plus funds under management). Out of this came the product ERA_MIS. | cpu time, customer satisfaction, management reporting, proc sql | source | 11 |
| 53 | European Commission RICA-2 Project | Marc Dehan, Thierry Vard |
This presentation describes briefly the RICA-2 system used by the Directorate General VI of the European Commission to support the Common Agricultural Policy. The system has been developed in 1997 by CSC Computer Sciences in collaboration with SAS Institute. Mr. Thierry.Vard is Administrator at the DG VI and one of the key users of the system. He has been strongly involved in the development phase as users representative. M. Dehan was the CSC Project Manager | sample, bubble plot | source | 13 |
| 54 | Extending the data collection services of IT Service Vision with PATROL | Michael Kearney | Presentation | correlation | source | 12 |
| 55 | Financial impact of forecast and analysis of economics and finances of the Russian regions | Alexander Nikolsky, Igor Kadoshchuk, Larisa G. Shchukina, Ludmila Bakhareva, Tatiana A. Ilyina |
The regional economic and financial analysis and forecast system -- AFFECT -- helps its users, such as regional Central Bank managers, local administrative and legislative bodies and others, take correct business-decisions. The AFFECT system can deeply AFFECT the manner in which Russian regional economic, financial and social spheres are administered and helps to: Optimize and manage the regional financial and social risks; Analyze and forecast trends underway in the regional banking system and commercial banks; Optimize the regional payment and monetary aggregates turnover; Optimize usage of state-owned resources to achieve maximum economic growth; Provide external recording, analysis and forecasting of non-monetary and shadow turnovers; Reach a new level in financial accounting; * etc | correlation, sas analyst | source | 8 |
| 56 | Financial Risk Management at "Banca Popolare di Novara" | Carlo Gobbi, Massimiliano Gianotti, Renzo Traversini |
Presentation | source | 19 | |
| 57 | Forecast Solution with the SAS System | Lars Peter Busch | Presentation | source | 12 | |
| 58 | Forecasting Software - A sales planning tool for the Marketing Department | Christophe Bonnart | Presentation | clinical trial, insurer, quality control | source | 11 |
| 59 | Geographic mapping of information: Improving communication between decision makers | Patricia McDowell | Social Security Statistics Branch is located within the Department of Health and Social Services (DHSS), Northern Ireland. The overall aim of the Department is to improve the health and social well-being of the people of Northern Ireland. Within the Department, the Social Security Policy and Statistics Directorate has responsibility for the implementation of social security legislation in parity with Britain. Statistics Branch provides an independent statistical service to the Department and the Social Security Agency, which has responsibility for the payment of welfare benefits. Social security benefits are a major area of government expenditure in Northern Ireland, accounting for almost a third of the total expenditure in the province. | time series data, where statement | source | 7 |
| 60 | Getting the most out of SAS/PH-Clinical Software: The future is now | Patrick O'Donoghue | This document provides a general overview of the changes and enhancements included in the new software release - comprehensive usage and reference information accompanies the software. To help you identify changes of particular interest, the summaries have been grouped into seven broad categories. These categories and their component features are listed below. | clinical data, clinical trial, dataset, data cleaning, clinical data management system, audit trail, variable list, clinical data management, data governance | source | 49 |
| 61 | Glasgow City Housing's experience of EIS and SAS software | Fin McElhinney | Presentation | phase i, phase ii, management reporting | source | 28 |
| 62 | GLM and MIXED procedures to treat longitudinal data | Sandrine Laguerre | The defining characteristic of longitudinal data or repeated measures is that individuals are measured repeatedly through time. We are going to talk about repeated measures for quantitative variables and particularly of their analysis using analysis of variance. Methods of analysis of variance for repeated measures which allow to take into account the correlation between measures made on the same subject will be detailed, but more classical methods of analysis of variance can also be run on repeated measures. At first, we are going to see how to use classical methods of analysis of variance with longitudinal data. After we will present some specific methods: firstly multivariate analysis and secondly univariate one. Within univariate method, the special case of mixed model will be detailed. | anova, proc glm, covariance, proc mixed, proc genmod, longitudinal data, multivariate analysis, repeated measures, correlation, missing value, response variable, univariate analysis | source | 9 |
| 63 | How do you manage 2000 state policemen using advanced management information systems? | Danny Donnen | Presentation | data mining | source | 12 |
| 64 | How OLTP revolution leads to data warehouse evolution and quality testing execution | Richard Miller | The Euroclear system is the world's largest settlement system for internationally traded securities. Participants, via a proprietary telecommunication environment, or other methods, can trade in securities, take advantage of custody services, which includes security safekeeping, collection of income and redemption proceeds, portfolio valuation and a number of other related activities. They may also take advantage of lending and borrowing services or money transfer which is used to resolve cash positions. Many other services are available on top of the most popular ones listed above. Up to now all transactions submitted during a working day are processed and settled overnight. However, there is a growing demand within the banking and financial industry to settle in real time, i.e. to have on line transaction processing. It is to meet this demand that Euroclear initiated the NEXT project. | data warehouse, filename statement, dataset, audit trail, financial services, lookup, macro definition | source | 33 |
| 65 | How to build human-like, fuzzy applications with SAS Software | Markku V. Suni | In this paper there are three points to direct our attention to: people, computers, and people and computers together. People do not usually think in exact terms. Instead of having a fixed amount in mind, they tend to ponder, whether a car, an insurance policy, a house, or something, feels expensive. The customer might be willing to go somewhat higher in terms of price if the offer is otherwise interesting. On the other hand, a not so interesting offer may be felt expensive even at a lot lower rate. This is well known by all sales- persons. On the other hand, computers are most exact in their thinking - or should we say, reasoning. When building applications of the people, by the people, and for the people, we should keep in mind those differences in thinking. As the raw processing power has become relatively cheap, we can afford to concentrate in making applications to imitate the human way of thinking | insurer, data step | source | 4 |
| 66 | How to design your MDDB | Geert Peeters | One of the most valuable add-ons to SAS6.12 is the introduction of the multi-dimensional database (MDDB). Although the advantages of the MDDB are clear to all, i.e. better performance while accessing enormous detailed data, still a lot of people fail to bring them in practice. This can mainly be put down to fact the users of MDDB's make the wrong choices during the design of their system, resulting in a bad performance. This article tries to give some answers in how to build a data model using MDDB technology. They are based on practical experience, and gathered during an implementation of a large EIS-system, making use of SAS6.12 technology. The main topics addressed in this article are: the size of a SAS MDDB and the way to circumvent the 2GB limit; the choice between a mono-cube structure and a multi-cube structure and the implementation of it in SAS; MDDB in a client/server environment ; and difference between ROLAP, MOLAP and HOLAP and their practical use in SAS | class variable, relational database | source | 4 |
| 67 | Hybrid OLAP: an Introduction | Richard Doherty | Presentation | source | 35 | |
| 68 | Hybrid OLAP: Techniques for viewing structures | Richard Doherty | Presentation | source | 21 | |
| 69 | In BED with the VSB Bank | Michael Gomes, Ries Visser |
Presentation | management reporting | source | 19 |
| 70 | Information systems for metro lines and bus depot managers | Luis Garcia Torrent | Presentation | source | 36 | |
| 71 | Installation of an MIS and data warehouse in Bank Handlowy in Warsaw: Business Benefits | Zdzisław Dec | Senior Managers of Bank Handlowy in Warsaw, have already prepared themselves for the realization of Data Warehouse since 1994. Staff of this bank has participated in many training involved with Data Warehouse and world-famous experts on this field were invited with seminar and lectures. At the beginning of 1997. Bank Handlowy have decided to start the implementation of Date Warehouse system and to create Management Information System on this base. | product profitability, data standard | source | 8 |
| 72 | Introduction to and Aims of the Project: Infocamere and Data Warehousing | Stefano Corsi | Infocamere is the Italian Chambers of Commerce Consortium for Information Technology and as such it is in charge of the gathering, storing and management of public data regarding all Italian businesses. All of these businesses are obliged to submit such information to the Chambers of Commerce to which they subscribe, one for each of the 103 Italian provinces. The Chambers' most important data-base, and in all respects the largest and most up-to-date source of information on the economic structure of the Country, is the Business Register. This Register was officially set up within the confines of Law n. 580 of 1993 and is the only completely computerised register in Europe, as it was not the result of the processing of a paper register, since it was not in existence before being set up as a computerised register. The Register contains information that is updated on a daily basis, regarding roughly 5.5 million currently active businesses and roughly 4.5 closed businesses, amounting to a total of roughly 10 million business data statuses. The information in this Register is accessed daily through thousands of Chamber of Commerce computer terminals, as it constitutes the most important source of information for public and private operators seeking official information about prospective clients, suppliers, lists of possible business partners, statistics regarding the distribution of businesses throughout the country, the legal status of businesses or their size | proc standard, data wrangling | source | 5 |
| 73 | Knowledge Discovery and Data Mining on the Example of Clinical Databases | Leon Bobrowski, Magdalena Topczewska |
During the last decade, progress in computer technology has lead to the possibility of collecting of a large amount of both quantitative as well as qualitative data in databases. In many specialists' opinions the ability to collect information has surpassed our ability to analyze it. This fact motivated the creation of a new field of research with strong associations with current practice known as "Data mining and knowledge discovery in databases". Two international congresses have been devoted so far to this line of research and a first specialised magazine entitled "Data Mining" has been issued [1], [2]. During the development of new techniques for data mining, methods from other scientific disciplines are often adopted [3]. These include: multidimensional statistical analysis, machine learning, decision trees, neural networks, Bayesian networks, genetic algorithms, rough and fuzzy sets approach. Data visualisation techniques also play an important role. | data mining, proc hpsplit, clinical database, neural network, data science, proc freq | source | 6 |
| 74 | Looking at business from customer's perspective or how to improve sales and reduce cost | Vesna Sikic | The objective of this paper is to give an overview and share experiences from the process that took place in one part of a large organisation which decided to move from the monopoly driven to the customer focused organisation. Based on positive experiences and measurable results the author would like to encourage all organisations facing the need to change, reorganise etc. to leverage on huge potential value hidden in organisation's own data. It might look like a "wishful thinking" for strategic decision making to rely on a "messy" legacy data coming from historically developed heterogeneous systems. Adopting the user driven, as oppose to the technology driven approach, supported by superior information delivery technology the new vision becomes a reality. The result: increased sales, reduced costs and most importantly higher customer satisfaction. It simply feels good and it is good for the company. | source | 3 | |
| 75 | Macroeconomic Planning Based on Development Results and Data Warehouses of Hungarian Tax Adminstration Modernisation Project | Korolly Brull | This paper intends to review the results of the Management Information System (VIR) project running under the Hungarian Tax Administration Modernisation Project till now and to sketch the further activities. The Environment of the Development: the Hungarian Tax Admini- stration System APEH, the Hungarian Tax and Financial Control Office was established in the year of 1988. The aim of the establishing was to develop a system of national taxation- with the exception of local taxes and duties - in which the tax administration apparatus should assess, collect, manage and audit taxes irrespective of groups of taxpayers and act as single tax authority to- ward citizens. A president, supervised by the Minister of Finance leads the Head Office of the tax administration. The county directorates (one per county, four in Budapest) perform the functions. All the directorates - including APEH - have there own IT Centre for some pre- processing and registration activities | data warehouse, mis, management reporting, cash management | source | 7 |
| 76 | Making the most of dictionary views in the SAS Help Library | Simon Wilcock | The SASHELP library which comes automatically with the Base SAS software is an often neglected tool which can be used both by advanced programmers looking to create robust code and by a variety of users trying to perform quick ad-hoc queries and data checks. This paper looks at a number of the dictionary views maintained within the SASHELP library and looks at some of the utility macros written at British Biotech, which put the library to good use in ensuring programs run error free across different data structures. The paper will also show how one of these views in particular goes some way towards solving the tricky problems involved in the management of macro variables (problems which often appear as requested enhancements in the SASWARE ballot). | macro variable, proc sql, proc step, create view, sashelp, options statement, adverse events, catalog entry | source | 10 |
| 77 | Managing the network - a graphical Web-based real-time solution | Oliver Weismantel | Presentation | source | 12 | |
| 78 | Marketing Information System for Heidelberg: How the world leader in printing presses takes advantage of SAS/EIS Software | Andreas Mangold | When we build data warehouse systems, SAS software gives us the tools and the framework so we can concentrate on the demands of our customers. 15 years of experience with SAS software and the quality partnership with SAS institute help us to choose and combine the right tools. And we add value to them. HEIDELBERG, world leader in printing presses, gave us the opportunity to prove this when they ordered their new marketing information system from HMS. The marketing information system delivers information about the world market for printing presses. Attendants of this SEUGI paper will get some ideas about how SAS/EIS modules, MDDB storage technology and object oriented programming are combined to achieve a user friendly, professional information system. An online presentation of the system will illustrate this. One important focus of this paper is the features that go beyond standard SAS/EIS functionality. What has been added to SAS/EIS? HMS style user interface: suitable for novices as well as for experts. Secure data warehouse: Logins, groups, grant of access for subsets, analysis variables and program functions, security driven data replication for notebook users. More than figures: Written reports from agency and product managers (e.g. word processor documents, html pages) can be integrated along common reporting dimensions (ActiveX/OLE technology). |
excel, star schema, data step, access control, flat file, output delivery system | source | 45 |
| 79 | MARWIN: Market and competitor information system for passenger airlines | Jürgen Jacobs | Presentation | source | 20 | |
| 80 | Maximising the lifetime value of chosen customers: Closing the Loop | Chris Thompson | Presentation | data mining, data warehouse | source | 20 |
| 81 | Migration to Internet | Francois-Xavier Berclaz | The 'Eidgenössische Oberzolldirektion' was confronted with the task of making the application "Swiss Foreign Trade Statistics" which was developed conventionally with SAS/AF available to over a thousand external subscribers thus offering them the same information service as the internal users. Based on a prototype that was built by the SAS Institute at the beginning of 1997 on the basis of SAS/INTRNET, the customer decided to migrate the application to the Internet. The actual conversion followed in the winter of 1997/98 carried out by CSC Ploenzke in cooperation with the customer and the SAS Institute. Based on this example, the presentation demonstrates which steps are to be taken when persuing such a migration, which design decisions are to be made (especially concerning distribution aspects between client and server), and what experiences the development team gained during the task |
source | 40 | |
| 82 | MIS systems for customer and product profitability in Den Norske Bank | Odd Petter Nythe, Tom Erik Falla |
Presentation | output delivery system | source | 33 |
| 83 | Module for the Central Bank Analysis of Economic Situation of Enterprises | Piotr Boguszewski | A set of macros used for analysis of non-identified unique data provided by enterprises in scope of the F-01 GUS (Polish Central Statistical Office) Report Sheet has been presented. The macros are used to create time series type databases and perform economic analysis of those data. The sub-macros used for graphical analysis are also presented. The presented system is applied in the National Bank of Poland for completion of the reports on the economic situation of enterprises. | time series analysis, raw data | source | 13 |
| 84 | Money or nothing: Making the ATM pay | Peter Oudshoorn, Peter Van Gils |
Automated Teller Machines have become an indispensable part of banking all over the world. From the viewpoint of it's customers ATMs are among the most visible parts of a bank. Every time a customer goes to an ATM and finds it out of service a lot of irritation is caused and a loss of confidence in the bank as a whole. In 1997 Abn Amro started a project to increase the availability of its Automated Teller Machines. It was calculated that a one percent increase of ATM availability would result in one million guilders (about $500,000) a year extra revenue for the bank. An important part of this project was to increase insight into the reasons why ATM's become unavailable. Because of the number of people involved and the different locations at which they work we chose to build a new set of Intranet based reports | capacity planning, credit card | source | 12 |
| 85 | Multiple correpondence analysis in bank services | Dusan Mramor, Igor Horvat, Joze Rovan |
In this paper we are applying multiple correspondence analysis (MCA) to identify the groups of potential customers of some bank services in the Republic of Slovenia. For statistical analysis of our large financial data set, the SAS System was used. It has served us for all data manipulation tasks, for multiple correspondence analysis (PROC CORRESP and SAS IML) and for the presentation purposes (PROC PLOT). |
proc freq, proc corresp, multiple correspondence analysis | source | 13 |
| 86 | Network accounting: An opportunity to control network-related expense through usage-based billing methodologies | Nell Cote | For years, technological and cost constraints have held people back from implementing network accounting systems. With rapidly growing network usage due to such factors as Internet access, global communications, distributed client/server applications, as well as audio and video data transmission, network accounting has never been so critically important. Fortunately, new technologies and SAS Institute's IT Charge Manager now make network accounting implementation not only feasible but also surprisingly affordable. What is network accounting and why should I implement it? Network accounting: A definition Network accounting is the process of monitoring network traffic and associating it with the business units and applications that are generating it. This information is retained in a database, permitting tracking of application and network usage over time. The importance of network accounting cannot be over-emphasized | capacity planning, traffic data | source | 9 |
| 87 | Network management and telecommuncation | Friedrich Worndle | Presentation | fault management, excel | source | 14 |
| 88 | Network management on phone system with IT Service Vision | Jurgen Wengorz | IT managers need effective support services to measure, manage and plan the delivery of IT services and bring IT goals into line with business objectives. These IT services include the phone systems which represent a sub-network within the global network. There is a set of standard services that can be offered by most modern digital switching systems. These are residential services (i.e. custom calling features, combination of digital voice and data on one line), business services (i.e. frame relay data transmission) and long-distance services (i.e. wide area business networks). Using the example of the SIEMENS HICOM phone system, this paper will show how to transfer the relevant data to SAS IT Service Vision. With a technical focus, it describes how to realize the principal support elements such as service-level management, accounting and chargeback, capacity planning and performance management. | source | 4 | |
| 89 | Norwegian eating and drinking habits; a business intelligence solution using OLAP functionality | Stig Roar Bolkan | Presentation | business intelligence, trade finance | source | 29 |
| 90 | Panta Rei or DAWIS: Data warehous information system | Thomas Klaibeer | Presentation | distribution channel, management reporting, mis, health insurance, insurer, proc sql | source | 27 |
| 91 | Pension expenditure projections: the legal/institutional model of the State General Accounting Office | Alessandra DeCastro, Antonella Menichetti, Paulo De Persio, Rocco Aprile |
Pension expenditure projections: the legal/institutional model of the State General Accounting Office. The increasing unbalance of the public pension systems has recently increased the interest in acquiring new prevision strategies to define the structural balances of the main pension funds. The studies concerning the medium-long term pension expenditures projections are based on two different research lines: the "demographic" pattern and the "legal-institutional" one. The first line includes models deriving from demographic structure indicators; they are able to approximate the evolution of the pension expenditure in relation to the social security tax base (total earnings) or to the GDP (Gross Domestic Product). These models use a very simplified scheme of the legal-institutional framework that is generally considered to be steady along the entire prevision period | transition matrix, proc freq, cpu time | source | 5 |
| 92 | Prebus pricing and invoicing IT: Production and service | Agneta Lindhe | Presentation | excel, ledger | source | 12 |
| 93 | Pricing System of Alcoholic beverages in Finland by ALKO Inc. | Jorma Peltoia | Presentation | when, logistic distribution | source | 21 |
| 94 | Problem and solutions in using SAS software as an insurance information tool: Extending SAS/EIS software capabilities | Stephen Dunn | Presentation | auto insurance, proc means, class variable, proc step | source | 36 |
| 95 | PROC TABULATE in a real WinWord table: a freeware macro | Roger Calvez | In the pharmaceutical industry, everybody uses the SAS system for statistical analysis and WinWord is commonly used in word processing to write statistical or clinical reports, but the interface between these two software is rather imperfect. The PROC TABULATE is a descriptive procedure which allows the user to create relevant and user-friendly tables for listings. However the integration of these Tabulates in a WinWord document by copying and pasting or with the Rich Text Format (RTF) is very disappointing. Actually, we do not transform SAS Tabulates into WinWord tables and formatting is impossible because it is a fixed character table. For reasons of effectiveness and Quality Control this interface must be improved because we can no longer be satisfied to transfer the SAS listings towards WinWord only to obtain a better presentation. Moreover creating WinWord tables from listings followed by tedious checking of data, is no longer possible because of the high risk of error. At Rhône-Poulenc Rorer Laboratories we developed a new and more practical approach : The export of a SAS output to WinWord by creating real WinWord tables. |
sas output, randomization | source | 6 |
| 96 | Rapid business benefit for customer relationship management through data warehousing and data mining | Nigel Wigram | Life assurers exist and make profits from people investing growing sums of money in life assurance policies and other financial products, and in leaving the money there. Our revenue essentially comes from having money under management. There are some ongoing administrative costs, but the largest parts of our variable costs are associated with starting money flow. | data mining, sample | source | 12 |
| 97 | Rapid implementation of Balanced Scorecard measurement systems using SAS software | Philip Mugglestone | Presentation | source | 40 | |
| 98 | Releasing the power of your database | Grant Denholm | Presentation | fact table, star schema | source | 31 |
| 99 | Reporting as a Function: Many Problems, Some Solutions | Markku V. Suni | There once was a headline stating: "Half of the people are dumber that the average". Could it be? Obviously it could, depending on what is meant by the average, and whether the meas- urement is reliable. Many of us have been reading a report or a table thinking that this information is of interest, but is it really true. Reporting is one of those things everybody has as idea of, but about which very few can give an exact definition. The purpose of this paper is to raise some thoughts about reporting and its problems. Earlier, in the Jurassic period of data processing, we built applications to take of accounting, for instance and to provide us with listings as a side product. Those listings became more complicated and more urgent and we began to speak about reports and reporting. Along the new idea of reporting we have created new problems associated with reporting | insurer, sas programmer | source | 4 |
| 100 | Reporting system for a commercial bank: A case study | Tadeusz Stawicki | Cooperation between Bank Przemysłowo-Handlowy S.A. in Cracow and SAWAN Company specializing in SAS system projects for banking area began in November 1996. Project and implementation of monthly obligatory reporting system for Polish central bank was the first topic in which such cooperation was taken up. Like in each such a case, works were began from recognition of information environment of the Bank. | balance, data standard | source | 6 |
| 101 | Running R/3 from SAP: Braun AG benefits from a Web-based performance warehouse | Hayo Hasselmann | Presentation | excel, proc sql | source | 13 |
| 102 | Sailing around Java: Experiences implementing SAS/IntrNet software in the global controlling arena | Rolf Annen | Presentation | investment banking, permanent dataset | source | 23 |
| 103 | Sales coaching with automated exception reporting and OLAP exploration: DVV Insurance's first data warehouse exploitation | Kristien Smets, Ludo Van Roey |
Presentation | data cleaning, customer retention, insurer | source | 17 |
| 104 | SAS data mining and neural networks: Powerful and efficient tools for customer-oriented pricing and target marketing in deregulated insurance markets | Stefan Lecher | As Zurich Insurance Company makes the transition from a product orientation to a provider of solutions for clearly defined customer groups, the detection of profitable target markets and the specification of solutions which meet customer's financial protection needs became one of the major tasks. Traditionally the pricing of insurance was mostly based on the product and not on the insured, whereas prices in deregulated markets have to be closely related to the each individual customer's exposure to risk. Deregulation and highly competitive insurance markets force insurance providers to increasingly follow this path. Zurich Switzerland uses Neural Networks to detect policyholder's attributes, which have a significant effect on the probability of higher losses or more claims. The results can not only be used to determine risk-adequacy, but also to allow marketing to identify potentially profitable customers | neural network, data mining, loss ratio, auto insurance, policy | source | 8 |
| 105 | SAS IT Service Vision and HP Openview integration (experience of installation and use in Cherus Ltd) | Dimitri Tseitline | Presentation | load, sas base, traffic data | source | 25 |
| 106 | SAS Software application on an application server in the intranet: first year experiences | Wilfried Schollenberger | With SAS/INTRNET software all users in an enterprise can easily access SAS applications without any need to install the SAS software on their workstations and even without any SAS know how. This paper discusses the basic differences between fat client and intranet applications and provides some hints how to quickly transfer fat client solutions to an intranet platform. Furthermore the paper discusses the different alternatives of implementing a SAS application servers and introduces an easy and straight forward method of developing intranet applications. The paper is based on extensive evaluations of the different available techniques and the implementation of a project management system at EURESCOM GmbH |
ods html, macro variable | source | 6 |
| 107 | SAS Software for analyzing the side effects of drugs | Irmgard Asnong, Annick Persoon, Christine Vander Vorst |
Presentation | proc freq, adverse events, output delivery system, sas output | source | 21 |
| 108 | SAS software within the Ernst & Young audit practice | Ton Buffing | Presentation | sas base, neural network, proc freq, predictor variable, data mining, standard deviation, response variable | source | 36 |
| 109 | SAS/Warehouse Administrator software and the 2 Rs (reading and writing) | Julie Pratten | Presentation | proc sql, sql server, data analyst, management reporting, excel | source | 16 |
| 110 | SCHARP: Survival Curve and Hazard Ratio Program | Angelo Tinazzi, Jayne Tierney, Lesley Stewart, Max Parmar, Valter Torri |
No commercial software package exists to analyse and plot the results of meta-analyses of randomised trials that use individual patient data (IPD). This has necessitated the development of SCHARP, a SAS application with point-and-click interface that produces publication-quality graphs and appropriate summary statistics for time-to-event data. Major features of SCHARP are that it: Utilises time-to-event for individual patients Provides estimates of the hazard ratio and associated 95% and 99% confidence intervals for each individual trial and combined over all trials (fixed-effects model) Performs subgroup analyses based on factors such as age, disease stage or histology Produces hazard ratio plots and survival curves by trial or subgroup * Performs test of significance for treatment effect, heterogeneity, interaction and trend Although SCHARP has been developed specifically for the purposes of IPD meta-analysis, the design permits the analysis of single randomised trials | hazard ratio, macro variable, confidence interval, treatment effect, dataset | source | 9 |
| 111 | Simplified user access to SAS/CONNECT software: "The SAS/CONNECT software management tool" | Julian Heritage | The principle of SAS/CONNECT is simple, allow the user access to multiple remote SAS sessions for distributed processing and data access from their local invocation of SAS . But in reality there are a number of complex interrelating concepts underneath (many outside the control of SAS). For many reasons these cannot be shielded from the user and may deter the user from exploiting and developing any knowledge. With some simple investigation, any organisation can conceal the majority of barriers that their users may face. This paper will show how the use of a simple GUI tool, developed in SAS/AF , will allow users to access data from a variety of different data sources from their desktop by a few clicks of the mouse and without any knowledge of SAS/CONNECT. It will also show how SAS/CONNECT and the SAS/CONNECT tool are used within Glaxo Wellcome. The benefit of improved access to live and legacy servers within any organisation is justification enough for such a small outlay |
macro variable, dataset | source | 9 |
| 112 | Simulation of the probability of disease due to a toxic release | Fuming Wu, Huei Wang, Raymond A. Gibley, Wanzer Drane |
The limit of the probability of an environmentally caused disease among a population as the continuous risk factor reaches its upper limit is the prevalence of the disease. Any upward change of this prevalence could be caused by increases in the intensity of the environmental risk factor. A defense of charges of environmental contamination can be constructed through simulations coupled with prevalence data. A SAS simulation program is presented, and the connection between the dose of chronic exposure and measures of harm are developed and presented for continuous risk factors: a) Probability of the disease at or less than given exposures, b) The log-odds ratio, and c) The instantaneous odds ratio. Continuous risk factors are not well treated in the literature either from a theoretical or an applications approach. In this paper is presented a theoretical basis for the above measures coupled with data based applications | cumulative frequency, odds ratio, logistic distribution | source | 5 |
| 113 | Single Patient Output List Application: A modern and flexible clean-file tool | Henrik Forsman, Martin Sjoholm |
Presentation | data cleaning, error message | source | 13 |
| 114 | Statistical database concept implemented in Oracle and automatisation of proceedings for Bank of Slovenia using the SAS System | Andrej Navodnik, Irena Komprej |
Data for Bank of Slovenia monthly bulletin containing slovenian macro-economic data is organised in statistical database implemented in relational database Oracle. The bulletin publishing proceedings are completely automatic and supported with specific tools. Tabular and graphical reports are part of the bulletin and are made with the interactive application written in the SAS System. This application is developed with SAS/AF module and operates in client-server environment. Data for those reports are downloaded from the statistical database implemented in Oracle and running on Alpha server to the Windows 95 environment. Those data are transformed and put into EXCEL spreadsheets. Graphical reports are developed with the SAS/GRAPH module and the result is saved as the CGM files. Tabular reports, graphical reports and textual part of the bulletin are integrated into final document in the desktop publishing tool Adobe Pagemaker |
excel, oracle, time series analysis, relational database | source | 4 |
| 115 | Strategic IT architecture and SAS software: A case study of SAS software within British Gas Trading | John Ingram, Ty Sapsford |
Presentation | dataset, access control | source | 22 |
| 116 | Survival analysis models in health care and their use for predictions of mortality | Jifi Vondracek, Keith Binks, Krystof Eben |
In public health or company healthcare, different risk factors and their impact on the event of interest (death, onset of disease, damage claim etc.) are investigated. A large part of the analyses is covered by the standard survival analysis procedures like PHREG or LIFEREG and we shall not deal with them here. Often, however, a particular risk factor influences the intensity of event occurrence in a manner that goes beyond the limits of these procedures. For instance, proportional hazards models with a parametric baseline are commonly used in demography and epidemiology. Lindsey (1996) proposed a technique to fit a broad class of parametric models. Shortly speaking, fitting the model is transformed to a Poisson regression task. In our applications we used yearly data for a cohort of employees of British Nuclear Fuels plc (BNFL), who have worked at the Sellafield site since 1948. In order to use Lindsey's approach, it is necessary to create an input data set, where each observation period in each individual is described by one row. Thus each worker contributed several data rows, starting with the year of entry and ending with the year of death or 1995 if alive. If we model overall mortality, i.e. the event of interest is death, then each data row involves the value of time, values of covariates (Z) and a dummy variable case indicating whether the worker died in the particular year (case=1) or either survived that year or was censored (case=0). | hazard function, calendar year, poisson distribution, poisson regression, relative risk, regression analysis, cumulative hazard, likelihood function | source | 6 |
| 117 | Taking an HTML Snapshot of a Data Warehouse: Just Say, Cheese! | Erik Simms, Jerry Kagan |
This paper will discuss how the New Hampshire Department of Health and Human Services implemented a system using SAS and web technology to validate and document data elements within their data warehouse. This paper is significant because the general approach taken allows the techniques used to be applied to any SAS based data warehouse. Furthermore, the use of web technology and the programmatic creation of HTML pages allows for instantaneous distribution and insures the accuracy of the information | dictionary tables, sample, data step, proc freq, proc step, data cleaning, sas base | source | 6 |
| 118 | Taking the SAS/MDDB Server for a test drive: does the performance outweigh the cost? | Simon Driscoll | With the 6.12 release of the SAS software comes a new data storage mechanism, the Multidimensional Database (MDDB). The SAS Multi-Dimensional Database provides a new method for creating read-only summarised information. An MDDB is actually a collection of summarised tables or sub-tables all controlled by a master NWAY table. This NWAY table is very similar in content to the NWAY table produced by the SUMMARY procedure with the sub tables being very similar to the specific _TYPE_ records. These tables are connected together in such a way as to form an indexed cube of summarised, hierarchical information held as a new MDDB data entity. It therefore becomes possible to drill down through a specified route within an MDDB. Several SAS/EIS objects can use this new data entity and become more efficient when using an MDDB as input. The objects are no longer required to calculate summarised statistics on the data displayed as these statistics have already been computed and placed in the MDDB during its creation. EIS simply consults with the MDDB and retrieves the relevant slice of data from the corresponding sub-table. The MDDB has the ability to create and store 21 different statistics ranging from Minimum, Maximum and Mean to Standard Error, Variance and Upper and Lower Confidence Limits. Use of an MDDB is not just restricted to use with SAS/EIS software however. MDDB tables can also be accessed by base SAS procedures via the SASSFIO engine and SAS/AF software provides methods for use with an MDDB. |
sas base, libname statement | source | 5 |
| 119 | Technical aspects of building a data warehouse in IPB | Zbynik Studnieka | Presentation | data mart, relational database, proc step | source | 22 |
| 120 | The "Web-powered" Warehouse: a survival guide | Roberto Gregori | The request of a better quality of life determines, in every industrialized country, a colossal raise of the sanitary expense. In the Azienda Ospedaliera of Ferrara (the S. Anna Hospital have about 1000 bed seats, 2400 employees and University Clinics) the concept of quality assurance, which in general results in reduced costs, enjoys great attention. The departments and clinics informative request, not only of economic type (induced costs, request of services), but also of medical type (results of therapeutical methods, check of case sheets) grows in a exponential way. The definition and implementation of an efficient data warehouse enables to answer to the analysis and manipulation of information demand: a next problem is represented by the necessity of immediate delivery of this information to every interested user, in simple and "painless" way | data warehouse, data wrangling | source | 6 |
| 121 | The 2 minute way to distribute new client versions to 1000 client/server users | Niels Duedahl | Presentation | customer satisfaction, proc upload, proc step | source | 18 |
| 122 | The actuary laboratory | Paolo Loi, Stephano Ferri |
Presentation | sas risk engine, proc freq, univariate analysis, bivariate analysis, pure premium | source | 7 |
| 123 | The Amadeus Reporting Toolkit demonstration | Andrew Wilcox | The Amadeus Reporting Toolkit is a suite of SAS products to enable users to create a wide variety of reports with an easy to use point and click interface. A SAS Solution for Business that complements and enhances your SAS Desktop. The Toolkit consists of an addition to your SAS Desktop Toolbar that gives you access to four screens: 1) The Tabulator creates cross- tabulations from SAS datasets without the need for programming. An easy to use Point and Click interface controls the generation of tables, allowing you to save and retrieve table definitions and set a wide variety of table options. 2) The Graphics Generator allows users to create a wide variety of graphics from SAS datasets. Users can view, save and print the graphics that are created. Graphics definitions can be saved and retrieved for later use. The Toolkit brings business solutions to a wide variety of users, with clear, concise, intelligent screens designed for ease of use and containing extensive functionality | dataset, where statement, sas base, txt | source | 12 |
| 124 | The development of a budget control system using client/server architecture for the Ministry of Agrilculture Fisheries and Flood | Bernadette Ruane, David Fisher, Nona Williamson |
Presentation | source | 18 | |
| 125 | The first data warehouse project at IMEC: A successful implementation strategy with SAS Software | Luc Huysmans, Paul Vandeloo |
Presentation | source | 19 | |
| 126 | The Implementation of a data warehouse at PTT Post International | Tadek Miller | PTT Post International (PPI) is part of the Dutch PTT Post organisation and deals with the collection, sorting, and distribution of international mail. These activities are done in co operation with other postal operators in the world. PTT Post recently acquired the Australian TNT company that specialises in time sensitive distribution and logistics of corporate mail. International mail is handled and remunerated in accordance with international regulations and multilateral or bilateral agreements. In order to determine our turnover and to remunerate, all incoming, outgoing, and transiting mail is registered. To accomplish this a number of information systems were developed. Within systems development reporting is a special issue. Wherever possible SAS software is used to generate management information. PPI is in the middle of setting up a data warehouse based on a mixture of legacy systems and newly developed systems. Currently, we use the data warehouse especially for analysis purposes like performance and quality control. In the near future we will also use the data warehouse to do analysis on product-market combinations. In this paper the position of the data warehouse within PPI's systems architecture and data management, and the relevant information systems in use with PPI will be discussed. The focus will be on how to organise, use, and maintain the data warehouse within our organisation. | data warehouse, data science | source | 10 |
| 127 | The methodogical integration between business and technology skills in a data warehouse | Daniele Vanzanelli | Presentation | excel, data warehouse, sensitivity analysis, work efficiency | source | 24 |
| 128 | The transformation of OLAP applications into OLAP multi-dimensional databas | Jana Ficová | Systems designed to provide fast data access, summarization and analytical processing a mass of data are called On Line Analytical Processing (OLAP) systems. OLAP systems give end-users an opportunity to make a data analysis through their analytical needs and categories represented by individual views or dimensions. This kind of view on data is called a multidimensional view. In nowadays we can register a rapid development of OLAP tools and multidimensional databases. The SAS System provides the OLAP tools mostly through the module SAS/EIS Motore as the extension of the module SAS/EIS. This module offers convenient tools for a rapid development of OLAP applications. In the Investment and Development Bank1 (IRB) with OLAP applications strategic bank's managers can rapidly examine key performance data through unlimited views of summarized data, even on very large data volumes. The data are summarized on various levels and are stored in so called base and summary tables. |
proc step, mis | source | 8 |
| 129 | The unique vision of the IT resource utilisation OK in Assicurazioni Generali | Claude Dunand | Presentation | access control, flat file | source | 29 |
| 130 | Tiku: Customer and sales information system for insurance company Pension-Varma | Eija Kaipainen-Perttula, Sari Salmi |
Presentation | excel, sas base | source | 4 |
| 131 | Time to market reduction: A methodological approach to the virual prototyping of stamped component | F. Placidi, Franca Vicino, S. Martire |
The Time To Market (TTM) can be generally defined as the time span between the idea for a new product and its launching on the market. The continuous requirements of automotive market force car-makers to be competitive not only in terms of quality, reliability, cost, performance and design, but also in terms of development rapidity. From this point of view, the new CAD instruments, their increasing integration with CAE and the rapid prototyping, together with the new job organisation and the new decision making procedures, are some of the instruments used to obtain reduction in TTM of a product. In this paper, a methodological approach is presented, which integrates CAE and rapid prototyping, new approaches to the product optimisation, based on Robust Design techniques, and decision making procedures, in the form of Analytical Hierarchy Process AHP techniques | proc mixed, proc hpsplit | source | 13 |
| 132 | Unpleasant data? A chance of powerful multi-variant analysis in clinical trials with data not meeting the conditions | Thomas Bregenzer | In the analysis of clinical trials one is often concerned with situations in which, for example when evaluating the treatment efficacy, several endpoints are of (equal) importance for the (clinical) judgement. The separate statistical analysis of such multiple endpoints in a comparison between two treatments results, however, in a multitude of p-values, whereas in many cases a single p-value would be preferable. Moreover, one is often concerned with equidirected treatment differences, where one is only interested in whether a treatment reveals some improvement upon placebo with respect to all response variables. Multivariate two-sample tests provide a solution to the latter problem by summarizing the differences between two treatments with respect to all endpoints in a global test statistic leading to a single p-value. This approach proposed by O'Brien (1984) turned out to be a considerably more powerful test for detecting restricted alternatives than Hotellings T2. A variety of such directional tests has been proposed during the last couple of years (e.g. Lachin (1992), Läuter et al (1996)). In practice, relevant endpoints may often be represented only on an ordinal scale, or quantitative and ordinal measures are of equal importance and should be analysed simultanously rather than performing separate analyses on groups of endpoints. It will be shown that the basic ideas of the parametric procedures can be used to construct powerful and widely applicable rank-tests which even allow mixed observation vectors consisting of both ordinal categorical and quantitative components or merely ordinal measures. Furthermore all tests can be applied to incomplete data, without being confined to the complete observation vectors, which is common practice in most of the statistical analysis systems, including the SAS system. The tests have been programmed as a SAS-IML Macro and can be implemented as a profitable supplement to existing SAS procedures for efficient parametric and nonparametric analysis of unbalanced multivariate data. |
covariance, treatment effect, probability distribution, sample, standard deviation, clinical trial, response variable, parametric test, data science, macro definition | source | 13 |
| 133 | Use of the SAS VARCOMP Procedure to estimate analytical repeatability | Anna Carroli | experimental conditions (analytical repeatability) and if it is reproducible among different laboratories (analytical reproducibility). The analysis of the components of variance is a powerful tool in order to achieve this information. Reproducibility and repeatability coefficients, indicating respectively the probability for an analytical measure to be reproduced among different laboratories or repeated within laboratories, can be easily calculated by the SAS VARCOMP Procedure (SAS/STAT). |
sample, proc calis, proc mixed | source | 5 |
| 134 | Using CIDS, a SAS/AF software application, to build a data warehouse and to provide OLAP tools for managers at PTT Post | Harm Schipper | For a business, the availability of high-level information is crucial for decision-making. To ensure the management of PTT Post International with a constant flow of well-organised data, a data warehouse has been designed using CIDS, a tool for data warehousing and OLAP and developed in SAS/AF. In addition, customised client/server architecture has been imple- mented, whereby the OLTP databases in ORACLE and the data warehouse are running on UNIX servers. The CIDS Data Warehouse Manager module is used to maintain the data warehouse and to add additional business subjects. Employees of PTT Post International at client workstations employ the CIDS Reporting & Analysis module to analyse data interactively and to generate (financial) reports. All information systems at PTT Post International are being re-designed so that in the future the company' s data will be transferred directly into the data warehouse and made available to the people in charge |
lookup, raw data, data warehouse, dataset, oracle, proc import, class variable, excel | source | 10 |
| 135 | Using SAS Software as a decision support system on top of the R/3 System FI financial accounting module | Ida R. Carapelle | This paper will give an approach to allow the different company departments to exploit the financial information coming from SAP/FI adding their own views, dimensions and information. Based on our knowledge in the understanding of the SAP product and our experience using SAS/ACCESS to SAP AG's R/3 in a data warehouse environment, we use the data coming from the General Ledger (FI-GL) and Account Receivable (FI-AR) modules of SAP R/3-FI to build multidimensional databases and an Executive Information System |
ledger, data standard, master data management | source | 14 |
| 136 | Using SAS software in developing the regional economy and finance analysis and forecasting system | Egor Liptchinski, Maxim Emelenko |
Server Ltd., in cooperation with some organisations of Russian Academy of Science, created a unique Regional economics and finance analysis and forecasting system (AERO) for a large industrial region of Russia - the Sverdlovsk region. AERO is implemented within the SAS System and utilize broadest resources in carrying out statistical investigations, realization data import, creating business graphs etc. The system gives users thoroughly developed user-friendly interface to the main features of the SAS system. The object oriented interface of the system is based on SAS/AF and is implemented using the SCL programming language. |
time series analysis, data wrangling | source | 8 |
| 137 | Why Not Use SAS/PRESENTS Software Instead...? | Philip R. Holland | Most of the papers at SEUGI and other SAS conferences are presented using Microsoft PowerPoint, and a few more are presented with Lotus Freelance Graphics. Both presentation tools are very powerful, and can produce very impressive final results, but both suffer from the same flaw when presenting SAS papers: They are not compatible with the SAS System! In version 6.12 SAS/EIS now includes its own presentation tool, SAS/PRESENTS, which, while it is nowhere near as comprehensive a presentation tool as its rivals, is totally integrated into the SAS System, allowing SAS programs to be demonstrated seamlessly with little impact on memory as only one application needs to be in use, the SAS System. This paper describes and demonstrates some of the uses and limitations of this new component of SAS/EIS, so that, in the future, more papers will be presented using SAS/PRESENTS. 1 |
sas function | source | 3 |
| 138 | Year 2000 compliance checking using the poweer of SAS Software | Guy R. Garrett | There is a quick and cheap solution to the Year 2000 problem within the SAS Delivery System, amend one of the system options, known as YEARCUTOFF to a reasonable date that suits your business and use this option at run-time. It would be nice if it was that simple. There is no doubt that this option will cater for the majority of two-digit year values, however published advice by the SAS Institute recommend to identify and change all | macro variable, dataset | source | 6 |
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.