White Papers
Testing Your SAS Code Against Known Data
Category: Data Management, Software and Web Development
Tags: spreadsheet, database, data
Overview As SAS code becomes more complex and is run on large databases, how does one know if the results are correct? It is easy to assume that, if the code runs, it must be perfect. However, it is important to test SAS code against known data to ensure that one is getting the results one expects. This paper will describe a simple mechanism for testing SAS code that can be expanded easily. Methods for generating the test database can cover quite a range - from the very simple spreadsheet to more complex random number generation. These data are then imported into SAS, the code to be tested is run against the sample database, and the output is compared to expected results.
- Publisher
- SAS Institute
- File Format
- Date Published
- May 30, 2009
- Format
- White Papers
- Topics
- Programming Languages, Database Management
Similiar White Papers
Building a Hybrid Data Warehouse Model
This paper discusses the hybrid design and provides a fully functional reference implementation. The system runs on Orac
MSDN Webcast: Using LINQ With Relational Data (Level 100)
One of the most common forms of data used in applications today continues to be relational data that is stored in variou
Publisher: Microsoft | Tags: applications, data, database
MySQL Stored Procedure Programming: Error Handling
The perfect programmer, living in a perfect world, would always write programs that anticipate every possible circumstan
Publisher: O'Reilly Media | Tags: applications, business applications, server, shuttle, software
MSDN Webcast: geekSpeak: T-SQL Tips and Tricks in SQL Server 2008 With Andrew Karcher (Level 200)
This webcast is for Transact-SQL (T-SQL) lover. The presenter introduces to several new features of SQL Server 2008, inc
Efficient Use of PL/SOL String Functions for Unicode Applications
This white paper focuses on performing implications of PL/SQL applications for Unicode database server using a UTF-8 dat
Publisher: Oracle Corporation | Tags: applications, database, server
SAS Institute White Papers
A Clever Demonstration of the SAS SUBSTR Function
The SAS SUBSTR function differs from the substring function in other programming languages as it can be used on either s
Publisher: SAS Institute
Understanding Your Customer: Segmentation Techniques for Gaining Customer Insight and Predicting Risk in the Telecom Industry
The explosion of customer data in the last twenty years has increased the need for data mining aimed at Customer Relatio
Publisher: SAS Institute | Tags: crm, customer service, data, data mining
An Animated Guide: Proc Transpose
If one can think about a SAS data set as being made up of columns and rows, one can say Proc Transpose "Flips" the colum
Publisher: SAS Institute | Tags: data
Cool New Features in SAS Enterprise Miner 5.3
SAS released Enterprise Miner 5.3 in late 2007 with a veritable plethora of cool new features for data miners everywhere
Publisher: SAS Institute | Tags: data, software
An Introduction to SAS Character Functions
SAS software is especially rich in its assortment of functions that deal with character data. This class of functions is
Publisher: SAS Institute | Tags: data, software
Featured white papers
-
The Value of Location Intelligence in the Communications Industry
Public Services are under pressure, the challenge is to do more with less. How do you improve citizen satisfaction, increase cost efficiencies and improve service delivery? The power of location intelligence is helping many local authorities...
-
Best Practices for Translating Customer Satisfaction into Revenue
Today's support organisations are focused on two top-level metrics: financial results and customer satisfaction. For most, it's easy to track financial performance, but customer satisfaction is akin to speaking a foreign language...
-
HP print solutions and 3M
The objective for 3M was to optimize office printing infrastructure at 3M locations worldwide, reduce total cost and environmental footprint. Some of the business benefits acheived by switching to HP print solutions...
-
Check out these top business apps for your iPhone
-
Inside a Microsoft datacentre
-
Green IT without losing your edge
-
Peter Cochrane's latest video blog
-
What you need to know about Windows 7