HOME QUICK SEARCH AUTHORS KEYWORDS HELP BUGS

VIEWS 2003 Papers - Index

27 papers. Source: VIEWS (International SAS Programmer Community) conference proceedings.

Back to Conf
go 2004
go 2001
# Title
×		 Authors
×		 Abstract
×		 Keywords
×		 Extras Pages
1 A Proc Print to Be Proud Of Lynn Pope We all use PROC PRINT, it is one of the simplest procedures in the book. So, if this is the case why don't we use to its full capabilities. The aim of this paper is to show you how much more you can do with PROC PRINT. All those options that we know are there but have never got around to using, or have long since been forgotten. Also, we will be looking at how we can significantly enhance our reports using ODS. PROC PRINT is more than just PROC PRINT;Run; so explore the procedure and I think you will be pleasantly surprised proc print, proc step, by group processing, label statement presentation 6
2 A Successful Implementation of a Complicated Web Based Application through WebAF and SAS Integration Technologies Clare A. Nicklin Amadeus Software Ltd. has been involved in analysing, designing, and imple menting a complicated, web -based, tax modelling system. The system was built to be a browser based application, available internally through a company intranet. This paper, initially, details the applications software requirements where a combination of SAS software (including webAF from AppDev Studio , Integration Technologies , SAS/AF software, and Base SAS Software Release 8.2) and additional software (such as Apache, Tomcat, and JDK) was used collectively. Secondly, the systems architecture is summarised to describe how the specified s oftware and hardware components are organised. Thirdly, the applications design features and defining characteristics are explained. Finally, a number of difficulties that emerged during the process of creating the application using the specified software are described sas base, dataset presentation 4
3 Analysing Binary Outcome Data from a Crossover Design Study using the SAS System Anna Pictor The crossover design is frequently used in clinical trials due to the various advantages gained from each patient receiving more than one treatment and hence acting as their own control. Statistical methods are available for analysing binary outcome data from these trials. There are three common methods of analysing such data collected from a 2-period, 2-treatment crossover design study - McNemar's test, the Mainland-Gart test and Prescott's test. These three tests have their own advantages and disadvantages that will be considered along with the methods for performing these tests using the SAS System. McNemar's test and the Mainland-Gart test can be performed using PROC FREQ in the SAS System. However, the main focus will be on Prescott's test that takes into consideration those patients with the same binary outcome in both periods of the study proc freq, confidence interval, numeric functions, treatment effect, null hypothesis, clinical trial, proc step presentation 8
4 Annotating SAS Graphs Simon Williams Getting information from a SAS data set to a graph is relatively simple. Gchart and GPLOT Procedures can be done in only 4 or 5 lines of code. Making the graph look nice and displaying other information for users, well that's a completely different matter. Symbol, Pattern and Axis statements, Annotate data sets, Device drivers, Reference Lines and User defined templates are all available to the programmer when they create graphics via the medium of the SAS System. This paper will look at these options and more in detail and demonstrate the way in which SAS can produce better-looking graphics sas programmer, dataset presentation 6
5 ASP.Net and SAS - A new model for Developing Web-Based SAS Applications Graham Murray Microsoft has invested heavily in the .NET architecture as its vision for the future of the Windows platform. One of the primary components of this 'big idea' is the ASP.NET Framework. SAS System features can be utilised from within ASP.NET applications through the Integration Technologies product and this paper sets out how to make full use of the power of the SAS System using ADO.NET, XML and 'Web Services'. All the enabling technologies, development environment options and system requirements for building web-based SAS applications will be described and a suggested 'development architecture' will be outlined. The paper will build on the Microsoft Reports Quick Start sample provided at www.ASP.NET and describe how the freely available Web Matrix ASP.NET development tool can be used to quickly build SAS System applications web service, sas base, sample, in=, stored procedure, proc sql, dataset, proc step presentation 7
6 Box-and-Whisker Plots with The SAS System David Shannon One regularly used graphical method of presenting data is the box-and-whisker plot. Whilst the vast majority of pharmaceutical statisticians produce their statistical output with The SAS System, until V8 producing box - and-whisker diagrams to a high standard was only achievable through custom macros and annotating graphics. With the introduction of PROC BOXPLOT to the SAS/STAT module statisticians now have the power to produce several styles of box-and-whisker plots, thus enabling comparative displays of data groups to be easily presented. This paper examines the statistical capabilities of PROC BOXPLOT, the styles of box -and-whisker plot it can produced and points out the pitfalls those programming the procedure should consider box plot, proc boxplot, proc step, class variable, sample, sample size, confidence interval presentation 9
7 Building SAS Based Web Services Jonathan Williamson Many IT observers are heralding Web Services as the next great thing. But what are Web Services? And how can we build SAS based Web Services? This paper is intended for developers new to Web Services. Some knowledge of Visual Basic will be advantageous. In this paper, we will introduce Web Services, what they are and why we might use them. Using a simple scenario, we will then run through the process of building a basic web service using the Microsoft .NET architecture and SAS software . Finally, we will use this to show how different types of client system can access web services web service, macro variable presentation 14
8 Building Windows Front Ends to SAS Software Katie Essam Version 8 of SAS Software introduced far greater interoperability with other software provider's technology. Combining this with the exciting functionality available in Microsoft's .NET framework provides us with the perfect partnership for creating easy-to-use, highly functional, attractive and effortlessly deployable Graphical User Interfaces (GUI) that utilise the power of SAS Software. This paper will discuss the methods available for communication between a Visual Basic .NET GUI and SAS Software, including ADO .NET, SAS Workspaces and the SAS COM components presentation 7
9 Customer churn - An operational comparison of logistic regression, decision tree & neural network models. Arun Parekkat The objective of this study was to compare logistic regression (LR), decision trees (DT) and Neural networks (NN) techniques for prediction modeling of churn amongst mobile subscribers at Orange PCS U.K. The study also assessed these techniques with reference to their implementation on SAS Enterprise Miner 4.1 for Windows. On development of the models the accuracies were compared. While the sensitivity of the NN model was significantly better than the LR, there were no significant differences between the NN and LR on many of the other performance parameters. The results f ound NN models to be effective in predicting churn, while LR being a good starting point for model derivation and in understanding the model structure. With a rigorous methodology, SAS Enterprise Miner provides the facility to develop models faster, with a comprehensive set of techniques, and a considerable ease of usage with its close integration with the SAS environment roc curve, proc hpsplit, logistic regression, churn prediction, logistic distribution, regression analysis, data mining 4
10 Design Considerations when Developing Applications using SAS Vijay Rajandram The concepts of application development have been rapidly changing over the last decade. Careful consideration is required to utilise the right technology and architecture to maximise your return on investment (ROI). The present technology facil itates the flexibility to integrate the power of SAS software with a wide selection of programming languages such as Java and Visual Basic (VB). Differences between Java and Visual Basic will be discussed. Applications should be structured into separate tiers, hence maintaining the division between the interface layer, the business logic layer and the data layer. Organising conceptual n -tier architecture will result in rapid development, minimum disruption, enhanced scalability and most importantly, will form a sound foundation for future enhancements. Overall advantages will be discussed giving guidelines in choosing the right tool to develop a successful application dataset, data validation rules presentation 4
11 Developing the Micro-Simulation Service System Josef Csicsman Microsimulation models are used for forecasting, policy advice and development of economic theory. This paper begins with a short description of microsimulation, then we summarise the concepts and results of the development data protection, sas programming pdf 8
12 Development of a DSS System for a Major Bank Ferenc Kiss At the Budapest University of Technology and Economics Department of Information and Knowledge Management a new software development project have started in April, 2002. The goal is to build a Decision Support System for banks based on SAS technology, integrating the common controlling, CRM and risk management functionalities, Balanced Score Card techniques, standard and OLAP reporting services and interfaces to the accounting systems, for "real life" education demonstration purpose. The core decision model is quite unique: a combination of a specially structured balance sheet and some scoring models. Among the building elements can be found our data handling and metadata manager developed for our microsimulation system at the department in the last two years, some portfolio scoring models prepared for financial institutions and two working BSC models developed for Hungarian banks. The paper presents the state of the project, the future steps and the first experiences credit scoring, financial services 4
13 Easy, Elegant, and Effective SAS Graphs LeRoy Bessler Are you an existing SAS/GRAPH user who would like to create charts that are more communication-effective? Or are you one of those software users who crunch their data with the SAS System, but then export their output to some other tool to graph it? This tutorial assumes no prior knowledge of SAS/GRAPH. It cuts through all the documentation and bypasses the "Options OverChoice" to empower you to make elegant and effective pie charts, bar charts, and trend charts- to get them right from the start. You will come away with widely applicable design principles and examples, and with supporting code that you can understand, and can point at your own data when you get back to the office. SAS/GRAPH can be easy, and, based on good design and good examples, communication-effective use of SAS/GRAPH gives you The Power to Show: to inform and influence, to reveal and persuade, with charts and data bar chart, proc step, vertical bar chart, horizontal bar chart, proc gchart, proc sort, proc gplot, macro loop, macro definition, output delivery system, class variable presentation 10
14 Enterprise Guide - Now and the Future - A Case study Philip R. Holland Until now Enterprise Guide software has been marketed as a separate product to be used as a thin-client front-end for the SAS System. This paper investigates the benefits gained by novice users of Enterprise Guide software, who are also unfamiliar with SAS version 8, and looks forward to the newer versions of SAS software and the advantages these same users will have when they convert to SAS version 9. What is Enterprise Guide software? Enterprise Guide software is a Windows-only thin-client application, which uses the Microsoft Data Access Components to communicate with the SAS Integration Technologies component. While access to SAS installations on remote Windows or UNIX platforms requires SAS Integration Technologies to be licensed on that system, Enterprise Guide software can act as a front-end to a locally installed SAS System, referred to as the Local Server, even if only Base SAS has been licensed sas enterprise guide, excel, dataset 14
15 Enterprise Performance Reporting: Software-Intelligent Web-and-Email-Based Communication LeRoy Bessler,
Francesca Pierri		 The communication effectiveness and communication efficiency of your information delivery are essential to the success of Enterprise Performance Management. This is true regardless of the management discipline or implementation (such as Balanced Scorecard), used for Key Performance Indicators, Critical Success Factors, or whatever you call your performance measurement parameters. This paper shows that you can design and build a web based and email based Enterprise Performance Reporting System with just Base SAS, ODS (Output Delivery System), and SAS/GRAPH, an incisive system that makes best use of the time, and seizes the attention, of its users. Its output designs can serve the communication needs of any enterprise. Software Intelligent construction techniques were used, so the system can adapt to performance data of any enterprise dataset, sas base, proc step presentation 8
16 Having it your own way in ODS Frank Poppe The Output Delivery System (ODS) of SAS makes it possible to influence the output of an application in a great many ways: the format in which it is delivered (HTML, PDF, etc.); the organisation of the output; what exactly goes where; how it looks like in general (the style); change several aspects of the above for particular items depending on the data. This is both true for the procedures developed for customised output (REPORT and TABULATE in particular) and for the other output producing procedures (often used procedures like MEANS, FREQ, UNIVARIATE but also all the others). However, it is not always clear where to look when one has to change the output in some way. In this paper I first want to treat the different elements of ODS, and the way they together determine the final output. I then will describe how one can change and enhance the behaviour of these elements. I then want to go on to describe how one can link different parts of the output together. This will focus on HTML output. The actual presentation will contain live demos as much as possible. In this summary on paper you'll have to with some screenshots. Some of the code I use however can be downloaded to serve as a starting point for your own endeavours in the world of ODS. excel, proc step, proc template, file statement, ods html 12
17 More _Infile_ Magic Peter Crawford Some facilities, limited to INPUT statements, have become more generally available (for example, reorganizing data from other rdbms) because _INFILE_ can be updated (since at least v8). This is hardware-platform independent so it is available everywhere INPUT statements are available (more difficult in SAS/SCL). This paper is targeted at programmers and other users of intermediate and advanced skill sets infile statement, excel presentation 3
18 SAS System 9 Architecture Explained Pete Snelling With the slow down of the global economy, profit margins are under pressure and market share is decreasing. Companies are demanding greater efficiency from their operations while the amount of data stored and analysed explodes due to faster hardware and cheaper storage. An increasing number of people in the enterprise need to interact with and make sense of the growing mountain of data and do it in a way that best suits their abilities and needs. The browser has revolutionised and enabled the democratisation of information delivery. It has also significantly increased expectations. Faster, more in-depth intelligence is needed to drive changes in business strategy. SAS System 9 provides a platform to meet these requirements. The 4 cornerstones of SAS System 9 are usability, scalability, manageability and interoperability. proc step, sas management console, sas base, sas enterprise guide 5
19 Saving Time: Large reports using SAS Macros and ODS RTF Jonathan Goddard Large surveys or clinical trials will often generate many variables which need to be reported in a similar way. Tabulating a large number of categorical variables by a particular grouping variable is one such task. This paper presents a macro method of performing repetitive reporting tasks without having to explicitly name or count all the variables involved. This method is made more useful by the ability of SAS software (in version 8.2) to write output directly to a rich-text file, via the Output Delivery System command, ODS RTF. The generated reports can be written to a single Microsoft Word file, together with an indexed table of contents. The code behind the idea is explained and illustrated with an example from a data set supplied with SAS. The paper discusses base SAS (including macros) and is primarily aimed at IBM PC and Microsoft Windows users with intermediate SAS programming skills macro variable, proc step, proc tabulate, macro loop, txt, macro definition, proc freq presentation 3
20 The Future's Bright, the Future's .NET David Shannon Today is an exciting time to be a user of applications that make use of SAS. SAS Institute are steadily using more and more alternatives to SAS/AF, for building interfaces to the SAS System. Such examples are Enterprise Guide and the forthco ming Studio Reporter, written in C++. This sends a clear message from SAS Institute with regards to application development strategies for our front ends that harness the power of the SAS system. Much has been made of web browsers for easy management and deployment of applications which make life easy for administrators and groups of users who are widely dispersed; however less is understood about the possibilities of rich client applications, that is, traditional desktop applications which provide the user with considerably more interactivity than your browser. This paper gives an overview of application development strategies with an appraisal on the uses of both web browser and desktop application approaches with Microsoft's .NET technology presentation 5
21 The Power of Pictures LeRoy Bessler You might want to use a logo. You can create images with SAS/GRAPH, other software, or a digital camera. Hardcopy photos or illustrations, or even a 3D object, can be converted to image files with a scanner. There are stock photos and clip art, free or for fee, on the web or bundled with software. This tutorial shows how to create image files with SAS/GRAPH, and how to imbed an image in a graph, but emphasis is on numerous ways to imbed image files, from any source, in web pages (and other output), using the SAS Output Delivery System. Besides imbedding images in tables, graphs, web pages, etc., you can import images into Microsoft Word or PowerPoint, for use as is, or after adjustments there (clipping, resizing, and other manipulation) without fancy expensive image editing tools. You will learn a trick to export image files for use elsewhere, after editing them in Word. The tutorial compares characteristics, advantages, and disadvantages of image file types (GIF vs proc step, proc template, output delivery system, proc print presentation 8
22 The SAS Certified Professional Program Ruth Talbot The world of statistical programming, application development, data management and providing business solutions is competitive and continues to grow in complexity as new technology emerges. As a result, the demand for qualified, knowledgeable professionals also increases. As the number of SAS users and consultants continues to grow, the need to distinguish between those who have mastered a specified level of competence in their use of SAS products and/or solutions versus those who have not becomes increasingly important. sas base, data warehouse, data governance, sas programming, proc sql presentation 6
23 The Use of Java with The SAS System Clare A. Nicklin As a Java experienced SAS consultant, I have spent much time in the last three years developing Java interfaces to The SAS System. Whether the style of interface has involved client - side or server -side processing, a variety of programming techniques and software has been used to complete the necessary tasks and projects. From my experience of developing such tools, I have come to realise that there is much confusion surrounding the use of Java to interface with the power of The SAS System. This pa per hopes to alleviate some of that confusion by providing a number of different, potential routes into SAS from Java applications. The different ways of accessing The SAS System can prove to be confusing, but they need not be as expensive as using complic ated, specialist development kits. Different tools and software products can be employed to provide the connection to SAS from stand -alone or browser -based applications proc sql, sas/access presentation 4
24 This is the Enterprise Guide Reporting Captain Lynn Pope SAS believe that Enterprise Guide provides a true Windows point-and-click interface to the full power of the SAS System. Also, that is uses interactive dialogs that guide users easily through SAS analytical and reporting tasks, provides transparent data access to both SAS and non-SAS data, and has the ability to export results to other Windows and server based applications. This paper will look at Enterprise Guide working through a project and demonstrating the key aspects of this product at a simple user level sas enterprise guide, dataset presentation 4
25 Understanding Customer Behaviour through the Extraction, Analysis, Reporting and Modelling of Customer Data. Andy Twaits This paper will examine how an integrated approach to data management - the extraction, storage, analysis, reporting and modeling of customer data - can add significant value to an organisation throughout the customer lifecycle. This includes delivery of significant business benefits in the areas of prospect targeting and marketing, customer acquisition and take -on, customer management (cross -sell, retention etc.), and collections and recoveries. The subject is approached from a business rather than a technical point of view likelihood function, application scorecard, credit card, sample, cluster analysis, credit risk presentation 3
26 Web Communication Effectiveness LeRoy Bessler Web Presence is no guarantee of Web Accessibility or Web Usability. Communication effectiveness on the Web requires you to: (a) get your message found (you want those search engines to find your web pages); (b) deliver your message quickly (download time is the Number One web user concern); assure that the receiver sees the same message that you, the sender, saw when you created it (this is NOT automatic, since unexpected things can happen with, e.g., colours and fonts); and (d) have the meaning of your message understood (superfluous dimensionality and other paraphernalia routinely introduced for graphs or tables can actually obstruct or delay, rather than enhance or accelerate, communication and comprehension). This is a tutorial about best technical practices, key design ideas, and The Power of Simplicity for publishing information on the Web. This tutorial is suitable for all skill levels. Design principles and ideas are software independent proc step, output delivery system, macro loop, sample, %if-%then-%else, macro definition, ods html, ods listing, sas output presentation 10
27 Which Merge? Steve Hanks Whether we work in Data Warehousing, Data reporting, Statistics or Pharmaceuticals we are continually asked to merge two, or more SAS data sets together in order to get the data we require. This paper compares and contrasts a number of different ways of merging SAS files. We will determine what method should be used when, and what the pros and cons of each method are. Some of the methods we look into are the match merge, using formats as a look up, using SAS/SQL and using indexed SET statements. Finally, this paper looks at how things vary if the data is in an external source or in Scalable Performance Data Server. proc sql, dataset, set statement, proc sort presentation 3

Back to Conf go 2004 go 2001

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.