SCSUG 2014 Papers - Index

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

#	Title ×	Authors ×	Abstract ×	Keywords ×	Extras	Pages
1	A Review of "Free" Massive Open Online Content (MOOC) for SAS Learners	Kirk Paul Lafler, Charles E. Shipp	Leading online providers are now offering SAS users with "free" access to content for learning how to use and program in SAS. This content is available to anyone in the form of massive open online content (or courses) (MOOC). Not only is all the content offered for "free", but it is designed with the distance learner in mind, empowering users to learn using a flexible and self- directed approach. As noted on Wikipedia.org, "A MOOC is an online course, content, or other resource aimed at unlimited participation and made available in an open access forum using the web." This presentation illustrates how anyone can access a wealth of learning technologies including comprehensive student notes, instructor lesson plans, hands-on exercises, PowerPoints, audio, webinars, and videos	sas base, sas studio, sample		16
2	Baltimore City Data Analysis to Identify High Risk Towing Zones using SAS Enterprise Guide 6.1	Karush Jaggi, Ameya Jadhavar, Prithvi Raj Srolikar		proc freq, output delivery system, heatmap		39
3	Basic SAS PROCedures for Producing Quick Results	Kirk Paul Lafler	As IT professionals, saving time is critical. Delivering timely and quality looking reports and information to management, end users, and customers is essential. The SAS System provides numerous "canned" PROCedures for generating quick results to take care of these needs ... and more. Attendees learn how basic SAS PROCedures such as PRINT and FORMS produce detail output; CHART, FREQ, MEANS, PLOT, SQL, and UNIVARIATE summarize and create graphical, tabular, and statistical output; and utility PROCedures to manage data libraries; Additional topics include techniques for informing the SAS System which data set to use as input to a procedure, how to subset data using a WHERE statement (or WHERE= data set option), and how to perform BY- group processing	proc step, proc means, numeric variable, proc sort, libname statement, proc freq, proc univariate		19
4	Building Better Credit Scores using Reject Inference and SAS	Steve Fleming	Although acquisition credit scoring models are used to screen all applicants, the data available to create the scoring model typically only has outcomes for applicants who were previously approved for a loan (Siddiqi). Since approved applicants tend to be less risky than those that were previously rejected, building the acquisition score in this manner may produce biased results. In this paper, four methods for dealing with missing outcome data are compared. The first, Ignore Rejects, uses only approved loans to build the model. The remaining three methods use a two-step approach where the model built on the approved loans is used to infer outcomes for the rejected applicants. A final model is then built using the known and inferred outcomes. The three methods evaluated here are Hard Cutoff, Parceling, and Individual. In this assessment, Parceling and Individual performed the best but, surprisingly, not much better than Ignore Rejects	pd, default rate, correlation, logistic regression, logistic distribution, predictor variable, regression analysis, proc step		15
5	Conditional Processing Using the Case Expression in PROC SQL	Kirk Paul Lafler	The `SQL` procedure supports conditionally selecting result values from rows in a table (or view) in the form of a case expression. Similar to an IF-THEN construct in the `DATA STEP`, a case expression uses one or more WHEN-THEN clause(s) to conditionally process some but not all the rows in a table. An optional ELSE expression can be specified to handle an alternate action should none of the expression(s) identified in the WHEN condition(s) be satisfied. This paper will illustrate the basic syntax associated with the two forms of case expression along with examples of each	proc sql, if-then-else, character variable, missing value, proc step, select		8
6	Connect with SAS Professionals Around the World with LinkedIn and sasCommunity.org	Kirk Paul Lafler, Charles E. Shipp	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 millions of SAS users worldwide, anytime and anywhere. This presentation explores how to create a LinkedIn profile and social networking content, develop a professional network of friends and colleagues, join special-interest groups, access a Wiki-based web site where anyone can add or change content on any page on the web site, share biographical information between both communities using a built-in widget, exchange ideas in Bloggers Corner, view scheduled and unscheduled events, use a built-in search facility to search for desired wiki-content, collaborate on projects and file sharing, read and respond to specific forum topics, and more	sample		15
7	Design of Experiments (DOE) Using JMP	Charles E. Shipp	JMP has provided some of the best design of experiment software for years. The JMP team continues the tradition of providing state-of-the-art DOE support. In addition to the full range of classical and modern design of experiment approaches, JMP provides a template for Custom Design for specific requirements. The other choices include: Screening Design; Response Surface Design; Choice Design; Accelerated Life Test Design; Nonlinear Design; Space Filling Design; Full Factorial Design; Taguchi Arrays; Mixture Design; and Augmented Design. Further, sample size and power plots are available. We give an introduction to these methods followed by a few examples with factors	quality control, sample size		4
8	Downloading, Configuring, and Using the Free SAS University Edition Software	Kirk Paul Lafler, Charles E. Shipp	The announcement of SAS Institute's free "SAS University Edition" is an exciting development for SAS users and learners around the world! The software bundle includes Base SAS, `SAS/STAT`, `SAS/IML`, Designer Studio (user interface), and `SAS/ACCESS` for Windows, with all the popular features found in the licensed SAS versions. This is an incredible opportunity for users, statisticians, data analysts, scientists, programmers, students, and academics everywhere to use (and learn) for career opportunities and advancement. Capabilities include data manipulation, data management, comprehensive programming language, powerful analytics, high quality graphics, world-renowned statistical analysis capabilities, and many other exciting features. This paper and presentation describes and illustrates the process of downloading, configuring and using the SAS University Edition software	sas studio, proc step, sas base, data governance, proc sql, excel	presentation	15
9	Exploring the PROC SQL _METHOD Option	Kirk Paul Lafler	The `SQL` Procedure contains powerful options for users to take advantage of. This presentation explores the fully supported _METHOD option as an applications development and tuning tool, and learn how to use this powerful option to understand and control how a query processes	proc sql, proc step, sas log, where statement, error message, options statement, data merging		4
10	Exploring the SAS Metadata DICTIONARY Tables and SASHELP Views	Kirk Paul Lafler	SAS users can quickly and conveniently obtain useful information about their SAS session with a number of read-only SAS data views called DICTIONARY tables or SASHELP views. At any time during a SAS session, information about currently defined system options, libnames, table names, column names and attributes, formats, indexes, and more can be accessed and captured. This paper explores the purpose of DICTIONARY tables and views, how they are accessed, and what information is available to SAS users. Attendees learn how these important tables and views can be accessed and applied using real-world scenarios	dictionary tables, proc sql, proc step, options statement, sas library, select		7
11	Five Little Known, But Highly Valuable and Widely Usable, PROC SQL Programming Techniques	Kirk Paul Lafler	The `SQL` Procedure contains a number of powerful and elegant language features for SQL users. This presentation highlights five little known, but highly valuable and widely usable, topics that will help users harness the power of the `SQL` procedure. Topics include using `PROC SQL` to perform FIRST., LAST. and Between in BY-group processing; constructing and searching the contents of a value-list macro variable for a specific value; data validation operations; data summary operations to process down rows and across columns; and using the MSGLEVEL= system option and _METHOD SQL option to capture and gain greater insight into the processes during query evaluation, the algorithm selected and used by the optimizer when processing a query, testing and debugging operations, and other processes	proc sql, proc step, dictionary tables, where statement, macro variable, select, create table, inner join, sas log, order by, sas library, group by, macro facility, view, macro call, right join, options statement		20
12	Functions vs. Macros: A Comparison and Summary	Mahipal Vanam, Phaneendhar Reddy Vanam, Srinivas Vanam	SAS is rich in various built-in functions, and predefined SAS supplied macros. Similarly, functions and macros can also be developed by user based on his needs and requirements. In this paper, we will walk through the various types of functions, macros, and how the functions and macros are stored and processed internally	stored macro, macro facility, macro definition, proc step, macro variable, options statement		6
13	Google Search Tips and Techniques for SAS and JMP Users	Kirk Paul Lafler, Charles E. Shipp	Google (www.google.com) is the world's most popular and widely-used search engine. As the premier search tool on the Internet today, SAS and JMP users frequently need to identify and locate SAS and JMP content wherever and in whatever form it resides. This paper provides insights into how Google works and illustrates numerous search tips and techniques for finding articles of interest, reference works, information tools, directories, PDFs, images, current news stories, user groups, and more to get search results quickly and easily			6
14	JMP Visual Statistics	Charles E. Shipp	For beginners, we review the continuing merging of statistics and graphics. Statistical graphics is the forte of JMP software and the JMP team pioneered the way for SAS Visual Analytics. Moving forward into Version 11, JMP has easy navigation, a graph builder, advanced algorithms in 85 platforms, and robust statistics you can trust. For olde-timers, we celebrate JMP success and discuss evolving and emerging developments, which we saw at the JMP Discovery Summit 2013 with the new Design of Experiments additions and other additions to JMP Version 11. New also is the entry of the 12th platform for experimental design, the Definitive Screening Design, adding selected midpoints. Many of the views will be shown in the presentation, and a lively discussion will continue in the hallway!	correlation, quality control		7
15	Loading a MS Access Database from Submitted Excel Templates	Rob Caudill	This paper is about using SAS to retrieve financial data from submitted on-line `EXCEL` templates	dataset, proc step, macro variable, excel		7
16	Mapping your way through the data with Information Map Studio	Alejandro Farias	This reference document can serve as a summary instructional tool for SAS Information Studio and is written to assist those responsible for providing access to data, such as an information architect, for data consumers. Topics covered include: Selecting Tables Table Relationships Selecting Data Items Organizing Data Items Creating a Custom Category or Calculated Data Item Single and Combination Filters Prompted Filters Test Queries * Resource Replacement/Moving/Saving Information Maps	data dictionary, dataset		17
17	Output Delivery System (ODS) Tips and Techniques	Kirk Paul Lafler	Are you looking for ways to improve or enhance the appearance of your SAS output? Output Delivery System (`ODS`) can help turn tired-looking output into great-looking information that has a purpose. Gone are the days when the only available formatting choice was the boring output listing that contained lifeless monospace fonts. `ODS` introduces exciting features that improve the appearance of your output. Using built-in format engines, `ODS` provides SAS users with a powerhouse of exciting capabilities to produce publishing-quality output. This presentation provides an introduction to `ODS`, including basic operation and syntax; how specialized output can be created, including RTF, PDF, HTML, Microsoft `EXCEL` spreadsheets, and SAS data sets; and how selection (or exclusion) lists can be constructed to handle basic content customizations	excel, proc univariate, output delivery system, sas output, ods rtf, libname statement, ods pdf, dataset, proc step, proc export, ods html, sas 9		15
18	Point-and-Click Programming Using SAS Enterprise Guide	Kirk Paul Lafler, Mira Shapiro	SAS Enterprise Guide empowers organizations 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 graphical 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, proc means, data governance, delimited file, sas output, proc sql		18
19	SAS Debugging 101	Kirk Paul Lafler	SAS users are almost always surprised to discover their programs contain bugs. In fact, when asked users will emphatically stand by their programs and logic by saying they are bug free. But, the vast number of experiences along with the realities of writing code says otherwise. Bugs in software can appear anywhere; whether accidentally built into the software by developers, or introduced by programmers when writing code. No matter where the origins of bugs occur, the one thing that all SAS users know is that debugging SAS program errors and warnings can be a daunting, and humbling, task. This presentation explores the world of SAS bugs, providing essential information about the types of bugs, how bugs are created, the symptoms of bugs, and how to locate bugs. Attendees learn how to apply effective techniques to better understand, identify, and repair bugs and enable program code to work as intended	options statement, sas log, data cleaning, hash table, proc step		13
20	Selection and Transformation of Continuous Predictors for Logistic Regression	Bruce S. Lund	This paper discusses the selection and transformation of continuous predictor variables for the fitting of binary logistic models. The paper has two parts: (1) A procedure and associated SAS macro is presented which can screen hundreds of predictor variables and 10 transformations of these variables to determine their predictive power for a logistic regression. The SAS macro passes the training data set twice to prepare the transformations and one more time through `PROC TTEST`. (2) The FSP (function selection procedure) and a SAS implementation of FSP are discussed. The FSP tests all transformations from among a class of "FSP transformations" and finds the one with maximum likelihood when fitting the binary target. The FSP has been presented in full detail in a 2008 book by P. Royston and W. Sauerbrei	logistic distribution, discriminant analysis, logistic regression, regression analysis, sample, proc logistic, likelihood function, proc step, macro definition, maximum likelihood estimation, predictor variable, normal distribution, histogram, type ii error, proc ttest, standard deviation, hypothesis testing		13
21	Survival tips for the Lone SAS programmer in an office full of stata , SPSS, and excel users	Mary G. Crissey		proc step, dataset, excel, proc export, proc import, proc tabulate, cpu time		18
22	The Call Execute Routine with Metadata: A Powerful Tool for Dynamic Data Loading	R. Scott Alcorn	CALL EXECUTE is a `DATA STEP` routine which interacts with the SAS Macro Facility. It is a versatile tool which enables the user to stack numerous SAS statements and run them together. This is an especially useful function in the realm of extracting, transforming, and loading (ETL) numerous SAS datasets in a single folder , without having to manually write repeated macro calls. Because the CALL EXECUTE function interacts with the SAS Macro Facility during the `DATA STEP`, the user can pass in metadata directly, in the form of a master list. For our purposes, we will use a character expression to resolve a macro te xt expression. Using this feature, along with the concept of metadata, makes ETL processing a breeze. This paper will teach a simple method of passing metadata through the CALL EXECUTE routine by example. This example is in no way meant to represent all possible uses of the CALL EXECUTE routine	call execute, dataset, macro definition, macro call, proc print, macro facility		8
23	Using Enterprise Guide for Table Joins and Sets	Warren Schlechte, John Barry Taylor	Enterprise Guide (EG) 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, account, savings account, full join, sas enterprise guide, proc step, order by, right join, data merging, missing value		13
24	Using SAS to Manage Biological Species Data and Calculate Diversity Indices	Paul Montagna	Species level information is necessary for conservation, management, and research into ecological and environmental systems. A common problem is that one doesn't know what the community composition will be, so data management is complex because it has to be managed by species and not by samples . Once the data management probl em is solved, there will be a need to summarize information at the sample level, and perhaps calculate a diversity index. This presentation will describe algorithms for commonly used diversity indices, and demonstrate how SAS was used to solve the data management and computational problems	sample, sample size, do loop, data governance, proc step		5
25	What's Hot, What's Not - Skills for SAS Professionals	Kirk Paul Lafler, Charles E. Shipp	As a new generation of SAS user emerges, current and prior generations of users have an extensive array of procedures, programming tools, approaches and techniques to choose from. This presentation identifies and explores the areas that are hot and not-so-hot in the world of the professional SAS user. Topics include Enterprise Guide, `PROC SQL`, `PROC REPORT`, `PROC FORMAT`, Macro Language, `ODS`, `DATA STEP` programming techniques such as arrays and hashing, business intelligence, sasCommunity.org, JMP, `SAS/GRAPH`, `SAS/STAT`, and `SAS/AF`	sas 9, sas base, proc step		6

Back to Conf go 2015 go 2013

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.