Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Maps and Data Sets Supplied With SAS/GIS Software
- Several SAS/GIS sample maps and their associated data sets are supplied with SAS/GIS Software. These maps reside in the MAPS library, along with map data sets shipped with SAS/GRAPH Software. These maps can be used for exploring the software or for demonstration purposes. To open the sample maps, invoke SAS/GIS...
- Tags: Map, Data Set, GIS, Software
- White papers 2007-12-01
- Handle conditional data and data conversion using SQL Server 2005 Integration Services
- Converting data and splitting data are at the core of almost any type of data application. This tutorial presents an example that details how to perform data conversion and conditional data splitting using SQL Server 2005 Integration Services SSIS. The example I will begin this example where I...
- Tags: Task, Microsoft SQL Server, Field, CSV File, Grid, Microsoft SQL Server 2005, Data, Data Type, Figure F Data Conversion, Data Set, Control Flow Example, Tim, Databases, Enterprise Software, Software, Data Management, Tim Chapman
- Blog posts 2007-10-19
- Process Your SAS Datasets Anyway, Anyhow, Anywhere You Choose With SAS/Connect
- One of the challenges of an organization that has multiple computing platforms is accessing SAS data sets stored on other operating systems. For example, maybe the user does most of the work on SAS for Windows, but have to process SAS data sets stored on a corporate Linux server. Or,...
- Tags: SAS Institute, Server, Data Set
- White papers 2007-05-14
- Learn and Predict
- Many data sets collected are not as easily analyzed, though. Large data sets such as those related to housing, education, security, taxation, sales, and even sports are too large to analyze by hand. Not all patterns are easily recognized; many contain seemingly unrelated data. What if it were possible to...
- Tags: Oracle Corp., Predictive Analytics, Data Set
- White papers 2006-03-01
- ASP.NET supports classic MVC design pattern for Web applications
- The ability of a Web application to quickly respond to user requests relies on more than buying more hardware. Proper application design via design patterns provides the necessary performance. Follow one example using ASP.NET.When developers hear the term “design pattern,” they generally envision one of two scenarios. One group of...
- Tags: Scripting languages, .NET, Middleware, e Advantage, design pattern, MVC design pattern, ASP Page, Microsoft ASP, developer, Web application, Microsoft ASP.NET
- Technical articles 2002-09-11
- .NET business services help power the WiredChurch system
- Take a real-world look at the theory, design, and implementation of business services objects in a .NET-based system. This is the third article in a five-part series.The WiredChurch.com system we discuss in this case study is a .NET-based application that allows religious organizations to manage their community activities. In the...
- Tags: .NET, e Advantage, business service, Microsoft .NET, WiredChurch
- Technical articles 2002-03-18
- Make your life easier with this often-unnoticed Excel spreadsheet button
- Spreadsheets are loaded with options that only experienced users know about. Schoun Regan shows you a button option that will save time and make your life easier.I like toolbars with buttons adorned with small images on them that allow users to change the way an application works or the way...
- Tags: PRODUCTIVITY, Microsoft Excel, Social Security, Excel spreadsheet, Schoun Regan, cell, data set, Select Current Region button, Select Current Region
- Technical articles 1999-11-30
Additional Resources
- Let Your Data Power Your DATA Step: Making Effective Use of the SET, MERGE, UPDATE, and MODIFY Statements
- The "Plain vanilla" SET statement is ubiquitous in SAS programming. It feeds the contents of a data set to a DATA step. This usage only scratches the surface of the capabilities of the SET statement and its siblings (MERGE, UPDATE, and MODIFY). Data sets typically are more than collections of...
- Tags: Statement, SAS Institute, Programming, Development Tools, Software Development, Software/Web Development
- White papers 2005-03-09
- Using Data Set Options in PROC SQL
- Data set options are an oft over-looked feature when querying and manipulating SAS data sets with PROC SQL. This paper explores using the data set options DROP, KEEP, LABEL, COMPRESS, SORTEDBY, WHERE, and RENAME in the CREATE TABLE statement and FROM clause of PROC SQL. These options can help facilitate...
- Tags: SAS Institute, Option
- White papers 2006-02-28
- Data Profiling Using OWB10gR2 and the Data Quality Option
- The Data Quality Option enables to convert the raw, staging data that comes into the reporting database into quality information. Using the features in this option, one can gain insight into the data and identify previously unknown data quality problems. Subsequently, it can create data rules and generate mappings to...
- Tags: Data Quality, Data Quality Option, Databases, Enterprise Software, Software, Data Management
- White papers 2006-10-16
- SQL Set Operators: So Handy Venn You Need Them
- When it comes to combining data from multiple tables in the SQL Procedure, joins get most of the attention and subqueries are probably second. Often overlooked are the set operators (OUTER UNION, UNION, INTERSECT, and EXCEPT). This paper begins by relating OUTER UNION to similar functionality provided by the DATA...
- Tags: Operator, SAS Institute, SQL, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- White papers 2006-02-28
- A Hands-On Introduction to SAS Basics and the SAS Display Manager
- The SAS DATA step is one of the most powerful and versatile software tools available for handling and manipulating data. However, it is sometimes somewhat confusing to SAS programmers as to what the different statements do, what the correct syntax is for these statements, and how they can help to...
- Tags: SAS Institute
- White papers 2006-02-28
- Changing Data Set Variables Into Macro Variables
- To create a few macro variables, the %LET statement works extremely well. But if one wants to automate the production of macro variables, DATA steps with the CALL SYMPUT statement or PROC SQL provide a better method. If a large number of macro variables need to be created from data...
- Tags: SAS Institute, Macro Variable
- White papers 2007-05-14
- A Hands-On Introduction to SAS DATA Step Programming
- The SAS DATA step is one of the most powerful and versatile software tools available for handling and manipulating data files, especially large data sets. It is also sometimes somewhat confusing to SAS programmers as to what the different statements do, what the correct syntax is for these statements, and...
- Tags: SAS Institute, Programming
- White papers 2005-03-09
- Search for invalid data in your Excel file
- Less elegant but very quick way to validate dataGood tip! It may be "too much work" for some situations. For a "quick and dirty" way to check data validity, one can turn on the AutoFilter (Data|Filter|AutoFilter). Clicking the "down arrow" at the top of each column will...
- Tags: validation, excel, data validation, AutoFilter, CMB from Omaha, hardware, Microsoft Excel
- Discussion threads 2006-05-10
- Programming With the KEEP, RENAME, and DROP Data Set Options
- One of the more frustrating things for a new user learning SAS can be the multitude of ways of accomplishing the same thing, each with its own subtleties. The topic of dropping, keeping and renaming variables in data sets is no exception. Using a DATA step, there are two ways...
- Tags: SAS Institute, Programming
- White papers 2006-02-28
- Customize data transfers with DTS and SQL Server
- DTS is a set of related tools that enable you to manipulate or transform data from various sources. To create a DTS package, you can use the DTS wizards to move data. You can also use the more advanced DTS Designer, which lets you create a multitude of packages and...
- Tags: tool, multitude, DTS, Microsoft SQL Server, workflow, server, FTP, scripting language
- Image galleries 2006-09-13
- Gracefully Terminate a DATA Step if the Input Data File Is Not Available
- The standard method to read external data into a SAS data set consists of - allocating the data file using a FILENAME statement; and creating a DATA step to read the data using INFILE and INPUT statements. The allocation creates a link between the SAS program and the data file....
- Tags: SAS Institute, Allocation
- White papers 2006-02-28
- Really Easy Backup (exe)
- A backup utility for software developers, authors, and designers, who need to get control of their critical data files. It's easy to use, just define your backup set data, then make backups with just a single mouse click. Each backup file is a Winzip- compatible compressed file with a unique...
- Tags: Backups
- Software downloads 2006-05-31
- Service Data Objects for C++Specification
- Service Data Objects SDO is a data programming architecture and an API. The main purpose of SDO is to simplify data programming, so that developers can focus on business logic instead of the underlying technology. SDO simplifies data programming by: unifying data programming across data source types, providing support for...
- Tags: Data Source, BEA Systems Inc., Programming, Service Data Objects, Data Programming, Data Object, Data Object API, Development Tools, Software Development, Software/Web Development
- White papers 2005-11-01
- << Previous
- page 1 of 1
- Next >>
Harnessing the power of waves
Planting solar gardens
Fill your car for $1.10 a gallon?