SEUGI 1995 Papers - Index

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

#	Title ×	Authors ×	Abstract ×	Keywords ×	Extras	Pages
1	A Concept on Data Delivery for Large Enterprisewide Information Systems	Stephan Tobler	Stephan Tobler Release 1.2 May 1995 This paper will discuss a practical approach to the gathering of information from a variety of data sources to any frontend application and focus on some typical problems in data delivery systems. The concept is based on a three level database architecture realized with the SAS system as a single point of control on a central platform. Source data may come from different platforms and databases and be integrated into an enterprisewide infobase which represents a neutral basis for distribution to application-specific subsets on central or decentral computing services. This concept is currently implemented under control of the SAS system on an MVS mainframe accessing SAPs Rl2, DB2 and flat files, including data distribution to a management information system of the PTT Telecom on an OSFIl server. Modularity in design and coding supports the universal usability of the system. 253	libname statement, raw data, lookup, data wrangling, dataset, data step	source	14
2	A Corporate Management Information System in the Insurance Industry	Markus Wettstein		management reporting, mis, insurance, calendar year	source	34
3	A Fin(ance)e Application for Consolidation	Aswin Bouwmeester	Consolidating is the proceSs of summarising financial data. This paper explains why and how consolidating is done. It also discusses the ways financial data can be stored in a database. In the last section of this paper an application is described which was built for reporting and analysing financial data. It is' built by PW Consulting and The Royal VanUerHave group. Consolidating Why? Summarizing financial data is not a straight forward process. Unlike most other data you cannot just add values to get a total. Totals have to be calculated according to certain rules, consolidation rules. For example: A company consists of two departments. Each department sells products. The sales of a department is calculated by adding the sales of all products for this department. Calculating the sales of the company by adding the total sales of both departments would result in a too high value if these departments are selling (a part of their) products to each other	data dictionary, proc step	source	4
4	A Graphical Decision Support System for Typology Elaboration	Franck Jamin		stage 1, dataset, macro definition, stage 3, txt	source	13
5	A Mainframe Based System for Data Exchange Between Various Application Systems an Different Platforms	Michael Fehringer, Norbeert Semmelbauer		flat file, macro variable, raw data	source	10
6	A Multi-dimensional EIS System in a Data Warehouse Environment	Sergio Motta		dataset, proc compare	source	9
7	A Network Accounting Solution	Mikael Westerlund		trend analysis, output delivery system	source	12
8	A School Population Forecast Model	Pasqualino Castaldi		proc freq, proc princomp	source	10
9	A Simulation Study Using the SAS System - Stepwise Rejective Stopping Boundaries for Clinical Trials with Multiple Treatments	Barbara G. Schneider	Often it is necessary to avoid editing in official documents as far as possible, for eXample in integrated medical-statistical reports of clinical1ria1s. However, there may be a need for further processing of your SAS output (for example: headings, page numbers etc.). Documenting all your edit-steps instead of fmalizing your ou1put with undocumented mouse clicks is a suitsble way to bypass the problem. You can govern and con'trol all further processing bynmning a SAS `DATA STEP`; arid you can document all changes to the original SAS ou1put by storing your SAS source code. General Document Setup, Include Header Page Setup Start with Page Number TIP: To avoid error messages, state rules as "WinWord is always opened" or "WinWord is never opened" when you start with DDE. Shuffle Tables Bookmarks Table of Contents Fields Include FileslFigures TIP: Use bookmarks or links for easier updating	sample, sample size, type i error, clinical trial	source	11
10	A Survey of Version Control Strategies for SAS Application Development Teams	Philip R. Holland	There is no utility which will control the versions of SASe catalog entries provided by the SAS Institute, so `SAS/AF`· application development teams must provide their own. ·This paper will discuss the big question of how much effort is really needed to create adequate controls for different sized development teams, giving the risks and benefits of a spectrum of version control strategies. These strategies described range from having no version control at all, where the risks to a software development could be great, to software solutions, where the cost of production could exceed the benefits to a small development team. Each SASI AF application development team must select the appropriate strategy which provides a balance between the risk and the development costs from those available	catalog entry, dataset, proc step	source	8
11	A Survival Analysis on Critical Components of Nuclear Power Plants	Valerie Durbec		relative risk, proc phreg, predictor variable, hazard function, data science, binary variable, main effect, likelihood function	source	9
12	A Way to Handle Pharmacokinetic Studies with SAS Software	Jean-Michel Cardot	In order to meet the need for the re-deployment of an application allowing the study of pharmacokinetic data, elBA-GEIGY has chosen SAS because of its functional resources and the scope of its potential. The main constraints to this operation were to take back the existing data (hundreds of studies) and to set up a data model allowing to work on either a single study or on several studies at the same time. Originally based on a relational craft-oriented data model, as well as on a set of reusable macros, the technical approach has been supplemented by a secured data input process and a relevant packaging. The whole led to an application allowing the storage of the data of a study, the calculation of the model-independent pharmacokinetic parameters, diverse simulations, reports (tables and graphics) that can be exported into office automation softwares. Besides, specific meta analyses that concern a set of studies are available	excel, sample, raw data, lookup, t1/2, proc sql, pk parameter	source	8
13	A Working Model to Build Data Warehouse Applications	Niklas Karlsson		quality assurance, data warehouse	source	9
14	Adverse Event Surveillance Using the SAS System	Julian Singer		adverse events, clinical trial	source	12
15	ALCATEL CIT's Unix Network Monthly Management Reporting System	Andre Leconte			source	9
16	AMIS: Developing a Data Warehouse for Actuaries	Jan Willem van der Grijp	The Actuarial Department of the Dutch business unit of Swiss-based Zurich Insurance Group, needed a (information) database with data on all their life insurance products to support two of the main tasks of the actuaries: Regularly reporting to the Dutch Insurance Chamber (obligatory by the Dutch Insurance Law) To support policy making with Cash Flow projections, Profit Analyses etc. of their insurance portfolio. A Data Warehouse has been designed and implemented that contains the necessary information for all products to support both tasks (and others). The Data Warehouse is refreshed on a monthly basis with data coming from eleven different administrative systems. These administrative systems vary from SQUDS databases on the IBM mainframe to SQU Windows databases on the OS/2 platform	insurer, policy, life insurance	source	10
17	An Enterprise Wide Systems Management Strategy Supported by a SAS/EIS Application	Willy Vanroy		capacity planning, management reporting	source	12
18	An Introduction to SAS/CPE Software	Julin Ginevro		raw data, dataset	source	25
19	An Overview of Information Visualisation Techniques in the SAS System	Bengt Bengtsson			source	3
20	An Overview of New Data Analysis Features in the SAS System	Gerhard Held		neural network, sample	source	6
21	Applications Development Environment (ADE)	Keith Collins		data dictionary, data validation rules	source	13
22	APPS - a 5th Generation Sales Planning and Forecasting System	Sven Viergutz	This paper describes the Meta Planning capabilities of the Sales Planning and Fore casting System APPS, which was developed at the Scientific Center Heidelberg of IBM Information Systems, Germany for a large German producer of brand goods. APPS is developed entirely on the basis of the SAS@ System. 2 Sales Planning as a Process In a passive approach, sales planning can be thought of being the quantitative extrapolation of sales data from the past into the future. In this regard, forecasting of time series and planning are synonymous, and the major challenge of a large company is to master many such series each day, in particular in the case of a broad and highly diversified product portfolio, with a large number of customers addressed through various distribution channels. In fact, good forecasts are the core of any reliable planning, for they attempt to anticipate the future on a rational basis	time series analysis, outlier	source	12
23	Building a Client/Server EIS	Walter Lanzani		traffic data, batch job	source	6
24	Building a Data Warehouse with SAS Software in the UNIX Environment	Karen Grippo	A c;ommon trend in corporations today is "downsizing" ~ moving applic;~tions from expensive mall'lframes to more affordable mid-range platforms. The Information Center or OLIn & Bradstreet Information Systems, faced with the challenge of mOiling fulfi"ment off the mainframe, has chosen SAS software not only as the vehicle for its data analysis and delivery but also as its database management system. Twenty gigabytes, extracted from mainframe legacy databases, have been loadecl C?nto an ~IP-UX platform as indexed SAS data file.. Two data structLlres (8 table mapping the data files to tile systems and a clata dictionary mapping data elements to data flies) and a set of SAS macros have been developed to give the Information Center developers and business users transparent ac:c:ess to the data, freeing them from the need to know data file or data element locljllions. In a future release of the SAS System, SAS Institute plans tO$UPport an integrated data dictionary	dataset, proc step, macro definition	source	7
25	Clinical Data Review Using SAS/PH-Clinical 2.0 Software (Demonstration)	Susan Carroll			source	2
26	Clinical Dual Entry Principles and Implementation Using FSEDIT	Jayantha Peiris	Dual data entry of clinicalddata is a well established method in the pharmaceutical industry (1,2), and is used to ensure mistakes occurring at the entry stage are detected and resolved. Two dual data entry	clinical data, key, proc step, proc compare	source	8
27	Computer Performance Evaluation: Will your Data Warehouse stand the Test of Time	David Annis		lookup, proc step	source	12
28	Data Warehouse: A Mandatory Initiative For Survival in the 1990s	Aaron Zornes		data warehouse, business intelligence	source	17
29	Data Warehousing and CANDA Concepts for Biometry	Ulrich Burger		clinical research, pharmaceutical industry	source	7
30	Developing a DDE-Utility-Server for SAS System Version 6.10 under Windows 3.1	Nils Dehn		exception handling, excel	source	11
31	Developing Applications the SAM Way	Steve Binning		access control, catalog entry	source	5
32	Developing RADical SAS Applications	Julian Ashworth		data science, cross-sectional data	source	8
33	Development of an Integrated SAS Based Drug Safety Information System at Geoden Richter	Ferenc Sipos		data science, anova	source	4
34	Development of the Decision Support System for the Executive Management at the Investment and Development Bank	Ivan Slota		analytics platform, data science	source	8
35	DoPE: A Tool for D-Optimal Planning & Experimentation	Christoph F. Berding	We introduce DoPE, a tool for experimental design in an industrial R&D environment. In DoPE flexibility is provided by utilizing D-optimal designs on the basis of the routines `SAS/FACTEX`· and `SAS/OPTEX`·. A convenient and simple handling of the application has been realized on the basis of the SAS/ AF* system	regression analysis, sample, degrees of freedom, sample size	source	16
36	Dynamic Report Writing	Mark Crawford		proc print, filename statement	source	12
37	Early Experiences Using the SAS/CPE Software	Allan McBain		raw data, input statement	source	4
38	Easy Query and Reporting from DB2 with SAS/ASSIST Software	Georg Morsing		proc sql, dataset	source	2
39	EIS at LVM: Experiences, Ideas, Strategies	Thomas Koschlig	In this presentation the use of the SAS-system at the LVM-Versicherungen and its benefits for this insurance-company will be presented. The first part oft\lepresentation will focus on Data Warehouse with 250 users and more than 10,000 statistics. This "backbone" gives the company the flexibility and transparency it needs especially on the new European market. Based on Data Warehouse more than 40 EIS systems have been developed within the last 5 years to give executives the possibility to get the answers to their questions immediately. More than 350 users in the headoffice and 200 laptop-users elsewhere in Germany work with these systems today. The key-issues for developing the EIS-Systems will finish this paper. As data-problems, programming-aspects and system-requirements are discussed in this final chapter any EIS developer will get some hints and tips. As a result of this presentation he should be able to plan his EIS-project more realistically		source	10
40	Empower Your User Community with a SAS Information Warehouse	Stephen C. Scott		dataset, cpu time	source	9
41	Enhancing SAS Output on Mainframes with IBM's DCF	Christel Ott	by Christel Ott & Rolf Annen Swissair Information Systems On the mainframe-platform SAS output tends to look rather poor. Instead of enhancing the appearance by transferring the output to PC applications, an elegant solution to the problem uses IBM's DCF on the mainframe. Your text SAS Output (`PROC PRINT`, `PROC TABULATE`) will look more professional and the integration of scalable `SAS/GRAPH` page segments will enrich your DCF documents. Text SAS Output To enable the use of DCF/GML together with SAS output you have to put your data on a file either by the procedure `PROC PRINTTO` or by PUT-statements together with the FILE-statement. In doing so you specify the appropriate DCF/GML tags by means of TITLE or FOOTNOTE statements or directly with PUT-statements	sas output, proc step	source	10
42	Enterprise Wide Performance Management Using SAS/CPE	Chris Luckman			source	6
43	Executive Information System for Production Cycle Time Performances Monitoring	Gaetane Van der Borght		proc sql, sas base	source	12
44	From Cost Accounting to Service Levels and Capacity Planning	Silvio Orsini	In 1992 the Bank of Italy needed a procedure to charge back the utilization of EDP resources of the mainframes (running MVS) to the end users. The base of this activity is the measurement of resource utilization (CPU, DASD, TAPES, PRINTERS) and the summary for specific different user groups for long term periods. The measured resources were: CPU in Service Units; DASD in GigaBytes; CONTROL UNITS in Start Subchannel; Automaf~c Tape Library in number of mounts; Tapes in number of tapes; Printers in number of lines printed. The chargeback procedure was developed to allocate the computer resource utilization to different use~ groups who are part of the Functional Units of the Bank of Italy. · Before starting with the project we considered the Capacity Management needs which also involved Capacity Planning, Service Levels and Performance Measurements. These activities were already running with different products and disomogeneous databases	capacity planning, batch job	source	14
45	From the Neolithic to the Nineties: The Evolution of Capacity and Performance Reporting	Douglas Clarke	We all collect vast amounts of data for CPE, but how to tum this into "information"? Over the past three years the Capacity Planning team at General Accident have evolved this from an almost prehistoric technological level into a coherent, online reference system using a SAS/ AF@ GUI application, whilst remaining firmly rooted in SAS@ and MXG@. "The way we were" centred upon voluminous (b&w) paper reports which were both unreadable and unread, suffered from inconsistent "workload" definitions, and took forever to produce. We are now able to present meaningful (and usable) information to managers, online at their own desks. This MI is readily available and quickly updated, and is presented through a "manager-friendly· PC-based system. The evolutionary path involved structuring workloads, combining data from multiple monitors, standardizing reports, and (eventually) building the Capacity/MI FRAME system for PC/LAN	capacity planning, sas base, macro definition	source	5
46	Future Directions of SAS/CPE Software	Daniel J. Squillace			source	4
47	Has the Mainframe Become Obsolete?	Renza Cristofani	An epidemiological application, born on mainframe platforms, evaluates mortality rates of tumors certified. in Italy in the period 1981-84 and it relates them to the migratory phenomena hold in the country from the fifties to the seventies. The application uses a data set with about 500.000 observations and 10 variables per record	data step, proc step	source	7
48	How Setting up Links between SAS/EIS and Current Available Tools of Analysis used in the Company	Fabienne Hassan		excel, insurer	source	9
49	How to Have a Successful Client-Contractor Relationship	Karin Pepping			source	6
50	Hungarian Medium and Long-Term Forecasting System of Labour Supply and Demand	Ferenc Lakó		data wrangling, sas base	source	10
51	Identifying Hospital Peer Groups According to Case Mix	Peter Benton		proc princomp, cluster analysis, r-squared	source	10
52	Implementation of a Class Libary to Model Fuzzy Sets and Operators Using SAS/AF	Bogdan Lelutiu		numeric variable, txt	source	16
53	Implementation of the Data Warehouse Concept at the Catholic University of Leuven (K.U.Leuven)	Hans Hulpiau		data dictionary, proc sql, excel	source	5
54	Information Delivery Through a Data Warehouse - The Business Need	Simon Barker			source	10
55	Integrated Validation of Data	Mike Thomson		data cleaning, numeric variable	source	5
56	Issues Facing IT Managers in Managing Enterprise-Wide Systems	Claes Stahl		management reporting, data wrangling	source	12
57	LACO's Financial Reporting System	Kristien Smets		data integration, financial reporting	source	18
58	Let's Talk about CASE	Wilfried Schollenberger	The quality of application development is of crucial importance for success in the long term. CASE, computer aided software engineering should provide appropriate means to achieve quality without reducing productivity in the short term. First I will give an introduction to the development cycle I usually prefer and present the main problems which may be solved by using software engineering tools. Then I will introduce an integrated approach, which supports - the design of a SAS database, - the development of `SAS/AF` applications, - the documentation of `SAS/AF` applications, - maintenance	catalog entry, relational database	source	12
59	Libre Accès: an Intuitive Query Tool Complementary to the SAS System	Olivier Dumas				2
60	Macro Procedure for Equivalence Testing	Francois Montestruc	The classical statistical methodology in clinical trials of pharmaceutical drugs aims at proving the superiority of one drug on the other. In case of a not significant difference, one is not allowed to conclude to the equivalence of the two drugs~ If one aims at demonstrating the equivalence of two drugs, one has to use a special study design. First, one must fix a limit AL, clinically relevant to demonstrate the superiority of one drug on another (if the difference between the two drugs is greater than AL, we conclude that the two drugs are not equivalent). Then a study will be conducted to test between the null hypothesis of inequivalence and an alternative hypotheSiS of difference. This paper presents a SAS macro-program, based on macro-windows, which can interactivelly compute several statistical methods for testing equivalence. It also calculates the number of subjects needed to ensure a given power. Key words: Equivalence. Macro-windows. Number of subjects	confidence interval, odds ratio, null hypothesis, ordinal variable, numeric variable, clinical trial	source	16
61	Management Budgeting, Accounting, Sales Reporting and Forecasting System in the Helsinki Telephone Company	Jarkko Sipponen		proc step, sas base	source	17
62	Management Information Telephone Calls	Walter Diele		management reporting, proc freq	source	6
63	Management of Patient Files in Psychiatric Institutions with the SAS System	Sabrina Buellens	A patient file in a psychiatric institution consists of all important information about a patient and is used by psychiatrists, psychologists, nurses, social workers and other personnel of the institution who are' involved in the treatment of a patient. Data that are'ofinterest are administrative data as well as strategic data, reports on the patient's therapy, reports on the patient's history, results and reports on (medical) examinations and tests, ... Also the definition of a patient file depends in fact on the psychiatric institution	character variable, dataset	source	12
64	Management Reporting and Information Delivery in a Credit Institute	Luigi Covi	For the past ten years ago CARIPLO basearried out a data base on mainframe which bas been used for the production of many prospects. to' help the functions of	proc report, development year	source	5
65	Manufacturing Money with Your Own Data - The Business Case for Data Warehouse	Mike Ferguson		data warehouse, proc sql	source	23
66	MIS based on CSF	Lars Odd Petersen	MIS based on CSF Lars Odd Petersen Jens Bisballe Planning Management information has been a great concern to public as well as pri vate enterprises during the years. Although it may seem a simple banality to select a number of management key figures, it is rather difficult in practice to establish systems as Management Information Systems (MIS) and integrate their use in management practice. It is basically a matter to be discussed what should be selected as correct information or key figures. Often management does not spent the needed and sufficient time on such clarification. It often proves that although too much information is available, important information is lacking. Information must be concentrated in order not to loose the comprehensive view. The CSF procedure as a tool Based on the CSF procedure (Critical Success Factors) the most critical in formation needed by the management team in the daily management is se lected	management reporting	source	7
67	MIS Swiss Telecom PTT	Jurg Winzeler		output delivery system	source	14
68	Model Building for the Cox Proportional Hazards Model with the SAS System	Richard Vonk	To fit a Cox proportional hazards model, the SAS procedure `PROC PHREG` can be used. For variable selection, the 'forward', 'backward' or 'stepwise' options are available. These are useful if the explanatory variables are dichotomous. However, factors with n> 2 main effects can not be readily included. In a `DATA STEP`, indicator variables have to be created for each factor. The automatic selection options should not be used if such factors need to be included in the model. A 'manual' model selection involves comparing the values of the -2 Log Likelihood statistics of many nested models on multiple outputs. It is, however, more efficient to use macros which provide the relevant information in a condensed way. Macros facilitating model selection for the Cox proportional hazard model using the -2 Log Likelihood statistic will be presented. In particular, these macros could be used where multi-level variables are involved	likelihood function, proc phreg, proc step, out=, binary variable, confidence interval, regression analysis, relative risk, proc sort, feature selection, macro variable, macro definition	source	12
69	Money Management Reporting System	Marcin Romanowski		dataset, excel	source	7
70	Moving to a Client/Server Network within a Commercial Environment - The Agony and the Ecstasy	Andrew Beasley		data warehouse, proc robustreg	source	8
71	Multi-Dimensional Viewing Techniques in the SAS System	Craig Drury, Mikael Hagstrom		reporting	source	5
72	Multi-Dimensional Viewing, OLAP, and Beyond with OLAP++	Craig Drury			source	5
73	Multi-Media in the SAS System	Nigel Law	Presentation		source	9
74	New Features for Object Oriented Applications Development with the SAS System	Robert Owen		bar chart, catalog entry, dataset	source	23
75	New Features in Release 6.11 for Windows and OS/2	Ulrike Scheuble		excel	source	5
76	Open Acces to SAP AG's R2 and R3 Data	Richard Evans		business intelligence, extract	source	13
77	PQRST, a Clinical Trial	Inger Malmaeus		clinical trial, data governance	source	6
78	Practical Experiences in Open Systems Network Performance Management and Benefits of Using SAS/CPE	Bernard Detrembleur		sample, proc step	source	10
79	Providing an Integrated User Guide and Help System	Tony Payne	Good on-line help facilities and a comprehensive user guide benefit even the most user-friendly applications. However these are often given low priority or even left out due to the work involved. This paper presents a system whereby the effort of preparing both user guide and help screens is replaced by an integrated system, using an electronic version of the user guide to automatically generate the help screens .. Why is help often poor? Every time a user receives a "Sorry, no l1elp available" message, or is given inaccurate or insufficient information from help screens, their confidence in the help system, and in the application as a whole, is reduced	ascii, sas base	source	4
80	Query and Reporting of Trading Data by the World's Largest Retail Betting Organisation	Andrew Alan Pearson	This presentation will highlight-how Ladbroke Racing Limited were able to access, query and make decisions based upon enormous volumes of trading data utilising a number of SAS Institute Modules, in a very' short space of time. It will brieflyexplain-_: - 'rheLadbroke Racing Organisational and IT structure - The:application providing the base trading data, known as "the Fieldbook" - The specific' requirements of our Head Office Trading Function, and - 'The SAS Institute Modules already in use, and those which were trial led It will thenexphun in more detail the trial itself, and the conclusion of the project. Ladbroke Racing is the world's largest commercial off track betting organisation, with operations in the UK, Belgium, Ireland, the United States and South America, and a UK annual turnover of around £2.5 billion. The Betting and Gaming Division have recently announced a record year, boosted by betting on last year's Soccer World Cup		source	8
81	Rapid Applications Development with the SAS System	Thomas J. R. Emmerich			source	15
82	Regional Econometric Modeling An Application of SAS/IML Software	Jorgen Lauridsen		residual, correlation, maximum likelihood estimation, likelihood function, proc reg	source	20
83	Remote Library Services	Bernadette Ruane	This paper investigates when and why Remote Library· Services should be used within an application, and discusses the way in which SPS implemented a particular solution. Over the past few months SPS has been involved in a number of client-server projects where large volumes of data were stored in a server environment. In one pat1icular instance, data was stored on a Unix server within Ingres. The application in question demanded that some of this data should be used as selection lists within a SASI AF front end, running on the client under Windows. The hardware involved was	where statement, libname statement	source	4
84	Reporting Clinical Adverse Events and Concomitant Medications - How to Compress Several Days Work into a few Minutes	Christoph Vidy	Reporting clinical adverse events and concomitant medications -- .. ~ How to compress several :days work into a fewm]ilutes. ,', ' , Christophe VIDY Reporting clinical adverse events requires complex programming due to the many ,specific requirements of clinical data. This is often time oonsumingand therefore we have developed a Frame application which allows the end user to build reports with a point and click'system requiring little khowledge of SAS. The application consists of three screens. The first screen allows specific variables such as header, row and group to be defined. The second requires the user to enter the layout characteristics such as title, footnote, page-size, linesize, sort ciiteria or first page number. Once this information has been entered, the user can decide to view the report format in an out-put window or store it in a file. In addition, the macro call used to generate the report can be stored	adverse events, macro facility	source	6
85	SAE: SAS Application Environment	Pieter van Driel		dataset, catalog entry	source	6
86	SAS & DB2: Automization of View	Markku V. Suni	Markku Suni SampoGroup Turku, Finland' DB2 tables can be read easily with SAS programs by means of access and view descpriptors. Creating and updating all those descriptors can be a considerable challenge. I have tried to automatize it leaving the grunt work to the computer. A batch job creates the despcriptors nee ded for testing and production, compares the descriptors now created to the ones created previ ously, collects the differences, and mails the names of the changed tables to all concerned lea ving the list of differences available for browsing. This paper presents the SAS programs nee ded to accomplish this and discusses my methods, means and future plans	batch job, txt, proc sort, sas programmer, proc step	source	8
87	SAS Data Warehousing: Open System Designs for Enterprise Class Environment	Don Lutter	The trend in empowering an organization's decision-makers to make better, faster, and broader-based decisions is up. The SAS System is meeting this challenge and SAS data warehousing emerges as the best choice to store the critical information needed in enterprise class environments. This paper discusses several key technical challenges in deploying SAS data warehousing in the Open Systems Arena and some practical solutions available to meet today's needs and tQmorrow's vision. The impact of deploying SAS data warehousing on conventional production OLTP systems is detailed and solutions presented in both SMP and cluster computer design centers. Several issues are discussed about data storage in the 10Gb to 200Gb range: using a DBMS via `SAS/ACCESS`, SAS datasets, and disk device management. The value of SAS job management via queue and load balancing software is shown	dataset, data warehouse, parallel processing, batch job	source	12
88	SAS is an Effective Tool to keep Control over Production in the Process Industry	John Jessesand		quality control, proc sql	source	3
89	SAS Macro Routines for Developing Guidelines to Measure the Appropreateness of Medical Care Applying the RAND/UCLA Method	Giovanni Filardo	Because of the complexity of medical care, some patients are not receiving procedures that they need, and others are receiving procedures that they do not need. RAND/UCLA hypothesised that producing explicit guidelines for care would help to improve the health status by addressing both the overuse and underuse of care. The RAND/UCLA method includes the following elements: . a) Identification of an expert panel. b) Development of a list of clinical indications that categorises patients in terms of their symptoms, past medical history, and results of previous diagnostic tests. In this way it is possible to describe clinically homogenous groups of patients. c) Transforming clinical indications in scenarios for which a judgement is sought from each panellist using a 1-9 rating (very inappropriate to very appropriate). d) Re-evaluation of the initial rating to only those scenarios judged as equivocal andlor inappropriate during the first round. e) Final Analysis	proc step, proc freq, proc format, macro facility, macro conditional	source	12
90	SAS Macros for Nonparametric Tests in the Case of Multivariate Incomplete Data from two Populations	Thomas Bregenzer		covariance, treatment effect, null hypothesis, sample, response variable	source	7
91	SAS Meets WinWord	Peter Jahnig	Often it is necessary to avoid editing in official documents as far as possible, for eXample in integrated medical-statistical reports of clinical1ria1s. However, there may be a need for further processing of your SAS output (for example: headings, page numbers etc.). Documenting all your edit-steps instead of fmalizing your ou1put with undocumented mouse clicks is a suitsble way to bypass the problem. You can govern and con'trol all further processing bynmning a SAS `DATA STEP`; arid you can document all changes to the original SAS ou1put by storing your SAS source code. General Document Setup, Include Header Page Setup Start with Page Number TIP: To avoid error messages, state rules as "WinWord is always opened" or "WinWord is never opened" when you start with DDE. Shuffle Tables Bookmarks Table of Contents Fields Include FileslFigures TIP: Use bookmarks or links for easier updating	data step, error message	source	1
92	SAS System Performance under UNIX	Hans-Joachim Kirsten	This paper discusses performance issues and considerations and provides some hints for the UNIX systems programmer who is working with" the SAS System. Topics covered include: UNIX process management, file system throughput, memory and CPU utilization, architectural differences between UNIX flavors, network JJO, and other issues related to SAS applications development under UNIX. Computer Pedormance under UNIX Computer performance management under UNIX is at once very complex and very straight forward. On one hand, the UNIX operating . system provides little in the way of dynamic tuning controls, so there are very few things a systems administrator can do to tune the operating system in the classic sense	cpu time, sample, capacity planning, key performance indicator	source	10
93	SAS/SPECTRAVIEW: Building a Three Dimensional Periodic Table	Dave Apter		bar chart, missing value	source	8
94	Simultan Data Collection to a DB2-table with FSEDIT and the SQL Cartesian Product	Thorleif Maudal		proc freq, sample	source	12
95	SIPP Project	Miriam Dell'Orsa	Miriam Dell'Osa, Leonardo Caronia		source	4
96	SPHINX: An Interactive Object-Oriented Petroleum Application to Enhance the Production of an Oil Reservoir at ELF AQUITAINE	Michel Lariviere		sample, histogram, dataset	source	7
97	Statistical Production Databases Using the SAS System	Silvia Sima	The new Romanian statistical system's requests and the recent hardware and software endowment allow a new public statistic functions approach and the shift to data processing distribution, specific to a Client/Server architecture. The SAS System has the mission to provide the large data amount management, to allow data improvement/imputation using statistical and mathematical analysis functions, to enhance the quality of the statistical information utilization. Considering the power of the SAS System in data processing and management and the necessity of using adequate procedures in statistical analysis activities, as early as this year the SAS System will be used for central level processing of complex statistical surveys (Annual Enterprise Structural Survey, Integrated Household Survey)	data wrangling, dataset, data science, oracle	source	14
98	Statistics and Democracy Preference Mapping in Opinion Poll Analysis	Guido Cuzzocrea	The Italian socio-political context has been recently characterised by important events such as the introduction of the majority electoral system and the disappearance or substantial transformation of traditional parties: these changes have highlighted the necessity of analysing the new characteristics, motivations and needs of potential voters. Opinion polls should focus their attention not only on voting behaviour forecasting, but on voter profiles as a complex phenomenon. The analysis of results by traditional tabular layout is not suitable for the joint treatment of multivariate data matrices, emphasising singular aspects and often leading to biased interpretations. Itl our approach we combine the use of statistical multivariate techniques with techniques for data organisation: we will show how to give the view of the entire forest rather than that of singletrees using the SAS System. 1	proc corresp, sample, proc freq, median, proc step, proc princomp	source	6
99	Strategic Marketing Information System as a Complete Solution for all Management Levels at the VSB Bank	Ries Visser		output delivery system, management reporting	source	11
100	Support your Organization Using SAS Software	Gunilla Sköllermo		sas consultant, ledger	source	7
101	Territory Management Application at Groupe AG	Roger Olivy		excel	source	23
102	The Analysis of Cross-Over Study with Repeated Measures within PEriods by Using Different Covariance Structures	Juhani Tuominen, Sanna Hinkka		covariance, covariance structure, restricted maximum likelihood, proc mixed, proc calis, likelihood function	source	12
103	The Data Warehouse Unlocking Your Corporate Data; Part I	Craig Drury			source	7
104	The Data Warehouse Unlocking Your Corporate Data; Part II	Craig Drury			source	3
105	The Executives' Executive Information out of the Executives' Enterprise Application	Jack van den Dungen			source	10
106	The Implementation of a Data-Driven Selection Procedure for the Smoothing Parameter in Nonparametric Estimation Using SAS/IML Software	Olaf Gefeller	Several nonparametric approaches to functional estimation have received considerable at tention in the statistical as well as the applied literature. In this context, the nearest neighbour kernel estimator represents one attractive technique. For the practical appli cation of the nearest neighbour kernel method, the actual number of nearest neighbours to, be included into the calculation, which corresponds to the "bandwidth parameter" in the more general setting of nonparametric functional estimation, has to be specified. Ad hoc rules applied in practice have only a lhnited theoretical foundation. In the paper, the problem is considered in the special case of hazard rate estimation from censored data. In this framework, the so-called "modified likelihood criterion" has been suggested as an automatic data-driven procedure to select an appropriate bandwidth parameter. An effi cient algorithm and its computational realization in `SAS/IML` have been developed and are discussed in detail	hazard function, likelihood function, censoring, data cleaning	source	13
107	The Importance of IN	Anders Skollermo		dataset, merge statement	source	11
108	The Information I Need - and What I get...	Goran Hallman			source	38
109	The Migration Trauma of Client/Server	Edward O'Hara			source	11
110	The PIL: An Alternative Approach to Forecasting System Load	Peter Van Gils		capacity planning, best response	source	22
111	The SAS Application for Road Safety Analysis	Marzena Nowakowska		dataset, gamma distribution, poisson distribution, posterior probability, macro facility	source	8
112	The SAS Research Application 2.1	Patrick O'Donoghue		excel, regression analysis	source	3
113	The SAS System A Long Term Strategy For Financial Information Delivery	Philip J. Winters			source	7
114	The SAS System for Financial Planning in AS Norske Shell	Elnar Bonnevie			source	2
115	The SAS System for the Macintosh	Alan Pyne			source	2
116	The SAS System for the Pharmaceutical Industry	Patrick O'Dononghue		pharmaceutical industry, data science	source	6
117	The Service Level Supplied by the Information Services Function: Societa' Italiana Per II Gas Experience	Marco Marchioni		proc freq, capacity planning	source	19
118	The Times They are a Changing - The Increasing Case for a Multidisciplinary Approach to Statistical Applications	Nicholas Graham Dyson	This paper outlines the changing nature of computing within a statistical production environment of a government Department (DSS) where the rapid development of Information Technology (IT) in recent years and the increasing involvement of statisticians with computing, has resulted in many statistical users now being of least equally, if not more, proficient in the areas of IT related to their particular needs than many IT professionals. Such changes raise important organisational issues since the traditional approach, used by the Department, in providing IT support by means of a separate section/organisation, outside the direct control of the statisticians, is now not efficiently providing the level of support required. The integration of IT support and statistical user functions, driven by user needs, is therefore discussed and the use of matrix organisation structures to address these issues outlined	data science, sample	source	11
119	The Use of SAS for Developing a Client/Server Application Inspection Administration System(IAS)	Albert Jacobs		proc sql, proc step, management reporting	source	14
120	Through Versions and Platforms via Connect	Eva Papp		dataset, data wrangling	source	8
121	Tips to Merge Large Datasets or Views, and Tips to Percent in PROC TABULATE	Per Andersen		proc step, proc sql, data merging, proc tabulate, proc sort	source	6
122	TLO - Targetting Labour Offer	Flavio Bonifacio		population, proc freq, proc princomp	source	7
123	Transforming and Presenting Information From Raw Data to an Organized Document Through the SAS System Version 6.08 for Windows Features	Paola Balardi	To successfully obtain information from large amounts of data it is necessary to integrate a DBMS, statistical software and a carefully prepared presentation of results. Inner in-data information can be elicited at 3 levels: raw data, readable data, elaborated data. Analyzing raw data can be prohibitively time consuming. Moreover data volume contributing to the information is usually massive (many observations for many variables) and quantitative information from a tabulating process can constitute the readable-data stadium of information. It is necessary to combine different views and to organize analysis results in order to fully benefit from all the information, and to prepare a clear, informative· and exhaustive document (elaborated data)	raw data, sample, proc step, dataset, macro definition, proc sql, macro variable, proc freq, macro loop	source	11
124	Tuning the SAS System Release under MVS Release 6.08: An Update	Daniel J. Squillace		excel	source	9
125	TV-Maps: TV Programs Positioning Maps with the SAS System	Dionino Di Florio, G. Marcon, M. Columbo	TV MAPS is a SASI AF application designed to map the competitive position of Prime Time TV programs by means of people meter data. These maps can help the evaluation of alternative program scheduling strategies. Socio-demographic concentration and total viewing data, stratified by sex, age, geographic area, education, and 16 life styles are collected day by day for each program aired on the 6 main Italian networks and for the total viewers. Data collected for other local commercial networks are aggregated and represented as a single netWork. Starting with 105 variables measured in a pre selected relevant period, `PROC FASTCLUS`/STAT and `PROC CANDISC`/ST AT are applied to select the most significant socio-demographic concentration variables in order to obtain the best clustering. First of all the distance matrix between cluster centroids is computed with `PROC IML`, then this matrix is used by `PROC MDS`/STAT to perform a Multi Dimensional Scaling	proc step, bubble plot	source	11
126	UBIRIS - A System to Support Investment Research and Publications at UBS	Beat Moser	UBIRIS (Union Bank Investment Research Infonnation System) is a central infonnation system to support the investment and economic research in Switzerland's largest bank. Its core part (UBIRIS Kernel) supplies analysts with both financial market and economic time. series data and tools for data analysis and the production of high quality research publications. These products are then fed into an infonnation delivery system which supports portfolio managers and investment advisers all over Switzerland (UBIRIS VISion). This paper describes the basic functionality of the research part of UBIRIS Kernel (URI: UBIRIS Research Interface) which has been realized using the frame technology of the SASiIl System and special features of Release 6.10 for WindOWSill. The application currently consists of four modules: Database Access: selection, processing and download of financial and economic time series	time series analysis, data science, time series data, proc freq, data standard, data warehouse, data cleaning, excel	source	10
127	Understanding Remote and OPEN Access to Enterprise Data	Richard Neale			source	4
128	Uses of Neural Nets in the SAS System	Derek Powell, Martin Duffy	In the past 5 years Neural Networks have moved from the world of academia ~ to being a recognized data analysis tool for business. Neural Networks can be	neural network, seed, proc freq	source	11
129	Using the SAS System for Market Research	Gerhard Held		conjoint analysis, sample	source	3
130	Using the SAS System in the Development of Frameworks for the Analysis of Accelerated Life Testing Experiments	Alan John Watkins		likelihood function, binary variable, maximum likelihood estimation	source	10
131	Using the SAS System to Acquire a Set of Golden Ten Orbits from Two Populations	Hans de Vos		time series analysis, macro variable, macro conditional, macro definition	source	12
132	Why SAS in Contact Group? - An Integrated AccountingBilling System And a Lot of Other Good Things As Well	Angel Lozano Membrilla		sas risk engine, batch job	source	4
133	Wouldn't it be Good if we Understood what Drives our Claims	Kevin Williams	One of the main keys to a successful business is the ability to forecast total claims incurred costs accurately. The resulting benefit to the business would be :- 1) identification of the key drivers of the claims costs 2) knowledge of the financial effects of changes to the external factors 3) understanding of the financial effects of internal decisions Two approaches were used and compared. The XII procedure produced a seasonally adjusted series which we then modelled using `PROC ARIMA`, as we could not make use of the automated ARIMA statement on XII due to lack of observations. The second method used was a combination of the `AUTOREG` procedure on the raw data and the ARlMA procedure. This paper explains the value of SAS System in enabling us to forecast claims incurred in terms of the modules used, their Consultancy skills and the procedures used. Also the problems that we encountered and how we overcame these problems using SAS	proc step, proc reg, acf plot, lag function, time series analysis, proc autoreg, predictor variable	source	9

Back to Conf go 1996 go 1994

This site serves as a convenient hosting location and does not work as a publisher. All copyrights belong to their respective owners.

The information on this site is provided for general reference purposes only. Whilst every effort is made to ensure that the site is up to date and accurate, no warrant, nor any responsibility or liability for, the accuracy or completeness of the content or for any loss which may arise from reliance on information contained in this site is provided. Links to other sites are provided for your convenience but no responsibility or liability for the content of those sites or of any external site which links to this site is accepted. References to any specific commercial product, process, service, or corporation are also for information only, and do not constitute endorsement, recommendation or favoring.

SAS is a registered trademark of SAS Institute Inc. SAS, Statistical Analysis System, and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration.