HOME QUICK SEARCH AUTHORS KEYWORDS HELP BUGS

SCSUG 2010 Papers - Index

41 papers. Source: SCSUG (South-Central SAS Users Group) conference proceedings.

Back to Conf
go 2011
go 2009
# Title
×		 Authors
×		 Abstract
×		 Keywords
×		 Extras Pages
1 A SAS Primer for Health Care Data Analysts Christopher W. Schacherer As in other fields, analysts in healthcare come to their vocation from a variety of paths-statisticians with formal training in predictive modeling, IT professionals with experience in programming and report writing, billing and claims professionals who possess a wealth of subject-matter expertise, and accounting and finance professionals who understand the methodologies for valid reporting of financial results. Analytics and Business Intelligence groups within healthcare organizations are strengthened by this diversity of expertise, but individuals coming into a business intelligence or healthcare analytics department from these other areas often struggle to acquire the skills that will help them leverage their particular backgrounds against the analytic challenges they face. The current work focuses on helping these analysts acquire the SAS programming skills necessary to turn raw data into analysis-ready data sets proc step, proc sql, proc format, proc transpose, proc compare, where statement, sas function, libname statement, numeric variable, proc freq, by group processing, dataset, sas output, raw data, sql server, user-defined format, proc means, proc univariate, options statement, oracle, sas library, index, missing value, proc sort, if-then-else, sql pass-through, format statement, subsetting if, sas programming, character variable, standard deviation, macro definition source 24
2 An Introduction to SAS Hash Programming Techniques Kirk Paul Lafler SAS users are always interested in learning techniques that will help them improve the performance of table look up, search, and sort operations. SAS software supports a DATA STEP programming technique known as a hash object to associate a key with one or more values. This presentation introduces what a hash object is, how it works, the syntax required, and simple ap plications of it use . Essential programming techniques will be illustrated t o sort data and search memory-resident data using a simple key to find a single value hash table, lookup, sas log, composite key, proc sort source 6
3 Application of DICTIONARY Tables and SASHELP Views Kirk Paul Lafler DICTIONARY tables and SASHELP views provide useful information about your operating environment, d atabase objects (tables, indexes, views), and SAS session. At any time during a SAS session, information about system options, librefs, table names, column names and attributes, formats, indexes, and more can be accessed. This presentation illustrates the positives and negatives with traditional approaches to capturing metadata, explores the content-filled DICTIONARY tables and SASHELP views, and the application of DICTIONARY tables and SASHELP views for producing system management requirements including v ariable cross -reference listings, database object listings, table (data set) row (observation) counts, column and index analysis listings dictionary tables, proc sql, proc step, create table, options statement, select source 9
4 Beyond the Simple Merge in SAS Vanessa Cox proc sql, proc step, merge statement, sample, set statement source 6
5 Boost Your Confidence (Intervals) With SAS Peter Langlois confidence interval, proc step, proc freq, logistic distribution, logistic regression, proc logistic, regression analysis source 42
6 Breaking Up Isn't Hard To Do After All Toby Dunn In the ever varying world of the SAS programmer, there comes a time when either the specs or a DBGB (Dilbert Pointy Haired Boss) demands either a data set be broken into N number of data sets or individual reports. While there are many ways to achieve this either through hard coding or using the Macro language, the question remains "are these solutions the most efficient"? I say Nay, what follows in this paper is an easy one step solution for each of these problems. The solutions are designed to be both easy to read, write, and maintain, thus effectively minimizing the programmers job to merely writing a general solution for either problem. Key Words: Hash, ODS, NewFile, FileVar, Call System hash table, data step source 6
7 Coding ICD-9 and Charlson Index Score in R for SAS Users Vanessa Cox sample, survival analysis source 16
8 Connect with SAS Professionals Around the World with LinkedIn and sasCommunity.org John R. Gerlach Accelerate your career and professional development with LinkedIn and sasCommunity.org. Establish and manage a professional network of trusted contacts, colleagues and experts. These exciting social networking and collaborative online communities enable users to connect with mi llions of SAS users worldwide, anytime and anywhere. This paper explores exciting features found in both virtual communities. Topics include creating a profile and social network content, developing a network of friends and colleagues, joining special -interest groups, accessing a Wiki - based web site where anyone can add or change content on any page on the web site, sharing biographical information between both communities using a built -in widget, exchanging ideas in Bloggers Corner, viewing scheduled and unscheduled events, using a built-in search facility to search for desired wiki-content, collaborating on projects and file sharing, reading and responding to specific forum topics, and much more source 13
9 Creating Customized Word Tables with Table of Contents using SAS ODS RTF for Clinical Studies Sue X. Zhang SAS ODS RTF destination allows the output tables to be directly copied into Word documents by the users. It creates the linked table of contents (TOC) pages that take you directly to the desired output with just a mouse click. The TEMPLATE procedure can customize SAS output reports by having control over the margins, font type, font size and justifications etc. This paper demonstrates the step by step procedures on how to apply the ODS RTF CONTENTS option and PROC TEMPLATE to generate informative TOC and customized reports with specified formats. It also describes the methods for generating publication quality tables using PROC TABULATE and PROC REPORT in addition to the ODS RTF CONTENTS option and PROC TEMPLATE. Some issues with these procedures will be discussed. The data used in this paper is either directly obtained or modified from SAShelp.CLASS for demonstration purposes only proc step, proc print, proc template, proc report, proc tabulate, title statement, output delivery system, clinical trial source 12
10 Data Visualization Using SAS/Graph Keith Cranford With the increase use of Business Intelligence, data visualization is becoming more important as well. SAS/GRAPH provides many tools to perform data visualization quite well. Some procedures, particularly the new Statistical Graphics procedures, can be used for this function without much data manipulation, while other procedures may require a bit more work. This paper will present several data visualization techniques, such as cycle plots, heatmaps, dot plots and deviation graphs. The use of these techniques will be illustrated along with SAS/GRAPH code to generate the visuals. In some cases alternative approaches are presented. Data Visualization The increased use of Business Intelligence has brought data visualization a higher profile heatmap, data visualization, proc step, response variable, proc report, proc sql, macro definition source 12
11 Demystifying the SAS Macro Facility - by Example Marje Fecht The SAS macro facility enables you to apply a wealth of useful, uncomplicated, real-world solutions to enhance your coding pleasure, reduce coding effort, and minimize error. As your business applications inevitably become more complex, the SAS macro facility is indispensable to: reduce code repetition increase control over program execution minimize manual intervention create modular code. Unfortunately, the SAS macro facility is often perceived as confusing, difficult to use, and only really comprehensible by a few long-time macro masochists. This presentation removes the mystery of macros and provides coding tips, macro solutions, and methodologies you can take away and implement immediately macro variable, macro definition, macro facility, macro put, proc sql, macro loop, date variable, proc step, symbol table, if-then-else, keyword parameter, %macro parameters, macro trigger, do loop, put statement, macro call, macro parameter, &variable, character functions, in=, macro function, sas 9, %if-%then-%else source 14
12 Easy Ways to get SAS Enterprise Guide to Send Tables and Graphs to Microsoft Office Suite, Without Writing Code! William E. Benjamin Jr. This paper will demonstrate several ways to output tables, graphs, databases, and files that are in formats that Microsoft products are able to process. All of these methods require no programming, and just use little known or hidden techniques that are available directly from the SAS Enterprise Guide user interface. The focus will be directly on how a new user to SAS Enterprise Guide can prepare and deliver data to the Microsoft Office (MS Office) suite of tools sas enterprise guide, txt, excel, cdisc source 19
13 Efficiency: How Your Data Structure Can Help or Hurt!!! Toby Dunn Once one gets past the simplistic idea that efficiency is only about the speed at which a program runs, a whole new world opens up. Too many SAS programmers fall into the trap of thinking that they must write program code based on the data structure they are provided. This paper introduces the paradigm shift that instead of making SAS fit the data structure, the data structure should be made to fit SAS. One of the most striking aspects is how important the data structure becomes to the overall efficiency; i.e. quality, readability, and maintainability. We will cover some of the basic topics of data structure and how it affects the overall look, complexity, maintainability, and speed of a SAS program. Starting with the basics of what constitutes efficiency, we will review common data structure mistakes and how they adversely affect the overall efficiency of the code. Finally, examples will demonstrate how simple and not-so-simple fixes improve the overall efficiency proc step, proc transpose source 15
14 Exploring DATA Step Merges and PROC SQL Joins Kirk Paul Lafler Explore the various DATA STEP merge and PROC SQL join processes. T his presentation examines the similarities and differences between each, and provides examples of effective coding techniques . Attendees examine the objectives and principles behind merging and joining, as well as the coding constructs associated with inner and outer merges and joins, hash techniques, and selected Set operators proc sql, proc step, inner join, if-then-else, create table, data merging, right join source 11
15 Exploring Joins with EG J. Warren Schlechte Enterprise Guide (EG) 4.1 provides a painless way to learn how to implement SQL joins. Basic SQL joins (inner and outer) can be created using the Filter/Query tool. Enterprise Guide allows the user to see the coding used for these joins, thereby giving the user the ability to learn SQL coding in a point-and-click environment. In addition to joins, SQL can be used for set operations. However, set operations require the user to code in SQL. By copying the SQL code from EG and slightly modifying it using keyword syntax, the user has a tremendous set of tools for combining and manipulating data sets proc sql, inner join, savings account, account, full join, sas enterprise guide, order by, proc step, right join, data merging, missing value source 14
16 Exploring Output Delivery System (ODS) Programming Techniques Kirk Paul Lafler Explore various SAS output formatting and reporting techniques with this Introduction to Output Delivery System hands-on workshop. Numerous examples are presented to improve mastery of ODS capabilities while providing a better understanding of ODS statements and options to perform common tasks. Topics include ODS Formatting statements and options; using the Escape character and forma tting output; and various output destinations including RTF, PDF, Output SAS data set, EXCEL spreadsheet, and HTML output proc univariate, output delivery system, sas output, dataset, ods html, ods pdf, ods rtf, file statement, proc step source 12
17 Get it Done Faster with Proc Datasets Linda J. Adams proc step, proc datasets, run, dataset, index source 7
18 How Good is Your School Steve Fleming With the widespread standardized testing put in place by the No Child Left Behind Act (NCLB), there is more performance data available on schools than ever before. Can this data be used to judge school effectiveness? For example, are performance results attributable to the school or to the community from which the school draws? These questions will be explored in the context of four accountability models: status, improvement, growth, and value-added. SAS code for implementing the four models and reporting the results will be demonstrated. For the data in this study, the first three models yielded similar results while the value-added model was less related to the other three and to school demographics. A familiarity with regression analysis will be helpful to get the most from this presentation regression analysis, logistic regression, sample, logistic distribution, proc step, confidence interval, proc mixed source 16
19 Impact of model mis-specification on conditional power in interim survival analysis Chao L. Chen For survival analysis used in clinical trials and other types of experiment, constant hazard ratio model is commonly used to compare the survival rate of active treatments with that of placebo group. If active treatments do not become effective immediately after treatment initiation, constant hazard model is not exactly applicable. Nevertheless, with the expectation that as the trial duration becomes longer, the effect of non-constant hazard ratio at the initial stage of the trials will dimini sh and becomes negligible. Even this argument seems intuitively acceptable for a long-term trial, in an interim analysis with data collected and analyzed during the course of the trial, impact of non-constant ratio may not be ignored, especially when the interim statistical results is to be used for the calculation of conditional power, a projected probability of final study outcome based on existing dataset hazard ratio, sample, conditional power, interim analysis, null hypothesis, survival analysis, hypothesis testing, normal distribution, clinical trial, sample size, treatment effect, regression analysis, proc phreg source 9
20 Intro to Arrays: A Grad Student "How-To" Paper Elisa L. Priest Grad students learn the basics of SAS programming in class or on their own. Often the lessons focus on statistical procedures. Data management techniques are limited to the DATA STEP and common methods like functions to create new datasets and variables. IF-T HEN statements are also introduced as a simple way to create and recode variables. These programming tools allow students to perform most simple data management tasks needed to prepare data for analysis. Although these tools are sufficient for in-class exercises with small datasets, new tools such as arrays may be better suited for larger datasets. Once students begin working on their own research projects with 'real' data, they quickly realize that manipulating the data so it can be analyzed is its own time consuming challenge. In the real world of messy data, we often spend more time preparing the data than performing the analysis do loop, missing value, proc step, conditional do loop source 14
21 It's Five O'Clock Somewhere!!! Handling Dates And Times In SAS Toby Dunn,
Sarah Woodruff		 Dates and Times - we use these concepts every day and they are strewn throughout our SAS code. So what about dates and times cause us problems? Why do they cause so many programmers, both new and seasoned, headaches? More importantly, do they have to be so hard to deal with? We are here to say "No, they don't." In this paper we will take you through the ins and outs of working with SAS date, DATETIME, and time values. Once armed with a range of concepts and functions you will come to see just how easy it is to work with date and time values in SAS, whether used in open or macro code. Once you have mastered these skills you too will be singing "It's Five O'Clock Somewhere" and looking to kick back with your favorite beverage. Keywords: Date, Time, DATETIME, sysdate9, date variable, datepart, put statement, macro function, macro facility, attrib statement, format statement, datetime, time variable, year, proc step, input statement, macro put, decimal, macro variable, time, weekday, informat statement source 21
22 Macro Quoting Toby Dunn One of the more perplexing things for any SAS programmer to learn is the effective use of macro quoting functions. This confusion is of little wonder, given the number of quoting functions, their similarity, and the subtle differences between when each may be applied. Choosing the optimal function or combination of functions to use is often a daunting task for even advanced programmers. The difficulties in debugging macro errors increase the complexity even more. To intelligently choose the optimal quoting function the programmer needs to know what symbols to mask and when they need masking, and how this depends on the compilation and execution of the macro and surrounding program. This paper surveys macro quoting, with an emphasis on which quoting function to use and when to use them. The paper assumes working knowledge of macro processing and the intended audience is journey-level SAS programmers and above macro variable, macro facility, macro quoting function, macro put, macro definition, macro function, put statement, substr function, %if-%then-%else, macro call, &variable source 13
23 Merging Historical Data Automatically While Dynamically Sorting the Variables Tim QF Wang When one merges yearly based tables together to form one historically aggregated table, variables are often arranged naturally by order of time (y ear), such as VarA_07, VarB_07, VarC_07, VarA_08, VarB_08, VarC_08, VarA_09, VarB_09, VarC_09. Howe ver, in order to perceive a trend of one particular variable over the time, it's often desired to re-arrange same variables but from different years together, such as VarA_07, VarA_08. VarA_09. There is no one direct SAS procedure to fulfill this kind of task. But SAS system table DICTIONARY.COLUMNS stores variables in alphabetical order, and SAS CONTENTS procedure can also generate an output ta ble with variables ordered. Together with SAS Macro language, this work presents two approaches to merge historical data automatically and at the same time to have the variables sorted dynamically. Using similar approaches, one can also apply formats to certain group of variables without typing the variable names macro variable, proc step source 4
24 Mobile Macros - Get Up to Speed Somewhere New Fast Patricia Hettinger Have you ever been faced with this scenario? It's your first day on the job and you know absolutely nothing about the data you're supposed to be working with. The documentation is scanty and people are too busy to give a detailed orientation - if they know enough to do so in the first place. This paper gives some macros the reader can use anywhere and explains some SAS concepts behind them. It also details how you can use SAS Enterprise Guide to create input screens for more flexibility macro variable, where statement, if-then-else, dataset, proc step source 17
25 Point-and-Click Programming Using SAS Enterprise Guide Mira Shapiro,
Kirk Paul Lafler		 SAS Enterprise Guide empowers orga nizations exploiting the power of SAS by offering programmers, business analysts, statisticians and end -users with powerful built-in wizards to perform a multitude of reporting and analytical tasks , access multi-platform enterprise data sources, deliver data and results to a variety of mediums and outlets, perform important data manipulations without the need to learn complex coding constructs, and support data management and documentation requirements quickly and easily. Attendees learn how to use the gra phical user interface (GUI) to access tab -delimited and EXCEL input files; subset, group, and summarize data; join two or more tables together; flexibly export results to HTML, PDF and EXCEL; and visually manage projects using flowcharts and diagrams excel, sas enterprise guide, dataset, data governance, delimited file, sas output, proc sql source 13
26 PROC DATASETS: The Swiss Army Knife of SAS Procedures Michael A. Raithel The DATASETS procedure provides the most diverse selection of capabilities and features of any of the SAS procedures. It is the prime tool that programmers can use to manage SAS data sets, indexes, catalogs, etc. Many SAS programmers are only familiar with a few of PROC DATASETS's many capabilities. Most often, they only use the data set updating, deleting, and renaming capabilities. However, there are many more features and uses that should be in a SAS programmer's toolkit. This paper highlights many of the major capabilities of PROC DATASETS. It discusses how it can be used as a tool to update variable information in a SAS data set; provide information on data set and catalog contents; delete data sets, catalogs, and indexes; repair damaged SAS data sets; rename files; create and manage audit trails; add, delete, and modify passwords; add and delete integrity constraints; and more dataset, proc step, constraint, audit trail, run, key, libname statement, foreign key, sas library, proc datasets, sas programmer, modify statement, sas log, proc contents, proc sql, attrib statement, data integrity, proc append source 25
27 Retrieving Sound Information from MIDI and Other Multivariate Data: SAS to the Rescue Cecil R. Hallum proc freq, proc princomp, txt, proc step, proc iml source 22
28 SAS and Relational Databases: What You Must Know Patricia Hettinger It is a rare shop that has data in just SAS format. DB2, Teradata, Oracle, SQL Server - all of these relational databases have their own quirks that may not become apparent until your DBA calls. Just because you can assign a LIBNAME to a database and use PROC SQL doesn't mean it will run the same way as it would against a SAS source. This paper will address what you must know before using SAS/ACCESS for more efficient queries and consistent results proc sql, key, dataset, foreign key, lookup, proc step, data integrity, cpu time, sas enterprise guide, relational database, group by, data step source 18
29 SAS Enterprise Guide: It's for Programmers Too! Marje Fecht Have you been programming in SAS for a while and just aren't sure how Enterprise Guide can help you? It isn't just a pretty face! This presentation will demonstrate how SAS programmers can use SAS Enterprise Guide as their primary interface to the SAS system while maintaining the flexibility of writing their own customized code. We will look at navigating the views and menus using SAS Enterprise Guide to access your existing programs and enhance your processing leveraging the more complex built-in capabilities ava ilable in SAS Enterprise Guide to further enhance the information you deliver using Report Builder (new to Vers ion 4.2 of SAS Enterprise Guide) * adding Project Prompts and dynamic pr ompts, to generalize the usability of your programs and processes. We will also share best practices for working in a server environment. Version 4.2 of SAS Enterprise Guide will be used sas enterprise guide, bar chart, sas programmer, excel, dataset, sas log, proc print, macro variable, work library, proc step, temporary dataset source 19
30 SAS Information Delivery Portal: Organize your Organization's reporting Kevin Davidson The SAS Information Delivery Portal (IDP) is a web application that allows you to present reports, graphs, document links, and web links in an easy to use interface. This paper will provide an overview of the IDP and how content can easily be surfaced. An example will show how a regular SAS program can be utilized within the IDP via stored processes. Options related to setting reporting permissions will also be presented. SAS Enterprise Guide also allows surfacing reports and graphs and there will be an overview of the advantages provided by IDP sas enterprise guide, sas management console source 10
31 SAS WOW! How to Streamline Your SAS Programs by Shedding Lines and Adding Substance Lisa A. Mendez,
Lizette Alonzo		 Would you like to slim down your Base SAS programs by eliminating needless lines of code while adding substance? Join us for some real life examples that we came across when we were tasked to update our SAS programs. We'll show you how to "transpose" data when PROC TRANSPOSE doesn't seem to work, condense your input when inputting multiple files with the same file structure, and how to use macro variables wisely, not carelessly. All this can be yours by adding some sample code to your SAS toolbox. But wait, there's more! See the value of program headers and comment boxes, for no additional cost! That's right! All this can be yours just by reading this paper! Act now! macro variable, sample, data step, proc step, do loop, dataset source 9
32 Simple Rules to Remember When Working with Indexes Kirk Paul Lafler SAS users are always interested in learning techniques related to improving data access. One way of improv ing information retrieval from a SAS data set or table is to create and use an index. An index consists of one or more columns that are used to uniquely identify each row within a table. Functioning as a SAS object containing the values in one or more colu mns in a table, an index may be defined as numeric, character, or a combination of both. This presentation will emphasize the rules that users should know when creating and using indexes to make information retrieval more efficient proc sql, where statement, index, proc step, sas library, dataset source 5
33 So, You've Got Data Enterprise Wide (SAS, ACCESS, EXCEL, MySQL, and Others); Well, Let SAS Enterprise Guide Software Point-n-Click Your Way to Using It William E. Benjamin Jr. This paper will walk a SAS user through the process of opening and using files from different (not SAS) generated sources and processing the data with SAS Enterprise Guide. The focus of this paper will be to get access to the data, since most functions available to SAS Enterprise Guide are drop-down menus and wizards which help teach a new user how to process data. This paper will not show how to get the data into files that are SAS files; it will be assumed that the user's enterprise will guide them through that process sas enterprise guide, excel source 10
34 Solving Kenken Puzzles - By Not Playing John R. Gerlach Solving Kenken puzzles requires more than making sure that numbers are used only once in a row and column of a matrix. Unlike Sudoku puzzles that can use any symbol and have sub-matrices, Kenken puzzles require actual integers and have contiguous cells, called cages. And, unlike a sub-matrix that contains a unique collection of numbers or symbols, Kenken puzzles have cages that must contain natural numbers representing a total as a function of its assigned arithmetic operation. For example, consider a 4x4 Kenken puzzle having a cage containing 3 cells whose total is 11 as a function of simple addition . One possible set of 3 numbers would be: 4+3+4=11. The objective is to complete the grid using numbers ranging from 1 to N that satisfies both cage arithmetic and row / column uniqueness . Depending on the size of the NxN grid, the number (and size) of the cages, as well as the arithmetic operations used, a Kenken puzzle offers a formidable challenge for logic puzzle fans do loop, macro variable, macro loop, missing value, dataset, proc sql, macro definition source 10
35 Take Control: Understanding and Controlling Your Do-Loops Sarah Woodruff,
Toby Dunn		 The term "loop" describes any control structure that causes a set of programming logic to be executed iteratively. Not knowing when and how to use these structures properly cause many to produce SAS code that is at best an illegible jumble and at worst a virtually useless quagmire. This paper performs an in-depth examination of the underlying concepts involved in DO-loop construct theory, including basic constructs such as DO While and DO Until loops as well as advanced constructs such as the DO-loop of Whitlock (DoW). In addition, the paper describes sound yet simple methods to help determine which loop is needed and rules for how to easily create them. "Using loops is one of the most complex aspects of programming; knowing how and when to use each kind of a loop is a decisive factor in constructing high-quality software" - Steve McConnell (Code Complete, 2 nd Edition ). Keywords: DO-Loop, DO While, DO Until, DoW conditional do loop, macro loop, by group processing, if-then-else, put statement, set statement, continue, macro facility, macro variable, goto, return, output, where statement, macro put, sas programmer, do loop, macro definition source 21
36 Using SAS for multivariate analysis of water quality parameters to determine freshwater inflow needs of estuarine organisms in Texas bays Paul Montagna Freshwater inflow is important to mai ntain estuary health. Effects of water flow are dynamic, and it is impossible to sample all conditions as they vary over space and time. Benthos, however, are fixed in place, continuously sample the overlying water conditions, and benthic indices of biotic integrity (BIBIs) are useful for assessing aquatic health. Many biotic characteristics can be measured. Likewise, the water column condition can be described using multiple water quality parameters. So, how do we relate multivariate water column condition with multivariate benthos response? The metrics were reduced to two variables using principal component analysis (PCA). Then the BIBI metrics and water column PC variables were significantly correlated, indicating that benthic communities respond t o changes in salinity and do so in a relatively predictable manner sample, proc princomp source 5
37 What Happens When You Push the Easy Button? - Migrating to BI 9.2 Faron Kincheloe It has been said that the utility for migrating a Business Intelligence (BI) installation from version 9.1 to version 9.2 is supposed to be like pushing the "Easy Button". Baylor University has successfully completed a migration of Enterprise Business Intelligence to version 9.2. This paper will describe the migration experience and present some lessons learned in the process credit migration, business intelligence source 8
38 Win With SAS, JMP, and Interest In-House Groups Charles E. Shipp,
Kirk Paul Lafler		 Have you considered an in-house group for SAS, JMP, or special interests? We discuss how to start and maintain an in-house group. Benefits include leadership opportunity, peer -to-peer interaction, tutorials, collaboration of users and also departments, a focal point for proper requests, and getting to know other users and providers. We present differences in corporate cultures and examples of successful school, company, and government user groups. We then summarize with critical success factors. Expect a lively discussion to follow sas programmer, clinical trial source 6
39 Yes! SAS ExcelXP WILL NOT Create a Microsoft Excel Graph; But SAS Users Can Command Microsoft Excel to Automatically Create Graphs From SAS William E. Benjamin Jr. With everything becoming more "Security Aware", hearing that Microsoft EXCEL 2007 can ignore DDE is no surprise. The SAS ODS Tagset ExcelXP creates .xml output, and .xml output cannot contain graphs. Nowadays, no one wants EXCEL spreadsheets with any kind of macros in the workbook. Most default security settings will not open "Macro Infected" workbooks (without an authorized Digital Signature - just try to get one of those) excel, xls, proc print source 12
40 You Could Be a SAS Nerd If . . . Kirk Paul Lafler Are you a SAS nerd? Wiktionary, a wiki-based Open Content dictionary, defines "nerd" as a person who has good technical or scientific skills, but is genera lly introspective or introverted. Another definition is a person who is intelligent but socially and physically awkward. Obviously there are other definitions for "nerd", many of which are associated with derogatory terms or stereotypes. This presentation focuses not on the negative descriptions associated with being a nerd , but on the many positive traits SAS users possess. So let's see how nerdy you actually are using the mostly unscientific, but fun, "Nerd" detector sas programmer, sas log source 4
41 You Use SAS, Your Boss Uses Excel. Guess Where Your Results Are Going to Appear! Using ODS to Create Your Results in Excel William E. Benjamin Jr. This paper digs into the use of ODS on the SAS side to prepare EXCEL spreadsheets directly. SAS code and macros will be demonstrated to create multi -page EXCEL spreadsheets, giving the programmer the ability to build tools to exploit data and display information for the end user. As a re sult, the SAS programmer will be able to create spreadsheets for distribution, automate the standardization of reports and the building of powerful spreadsheet applications with access to information built by offline SAS processes that the end user can ref resh excel, proc print, ods excel, proc step, sas base, output delivery system source 10

Back to Conf go 2011 go 2009

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.