| Publisher | SAS Institute | ||
|---|---|---|---|
| Format | 91.5KB PDF | Date added | 28 Mar 2001 |
| Topics | Knowledge and Data Management | ||
| Downloads | 1048  popular | ||
A custom query tool written for a broad audience presents certain problems for the programmer. Some users are content with the point and click interface while power users want to type in code. In variable transformations such as logs and ratios, both approaches can result in errors if the data is at all dirty. The authors wanted to protect their system against mistakes in user-entered code as well as data problems, while still providing the flexibility of user defined variables. The new string functions rxparse and rxsubstr provide a clean approach to the problem that is easy to implement. This paper presents two SCL methods that utilize these functions to generate code-saving code: checks that prevent defined run-time errors.
Did you find this white paper useful?
30 out of 50 users found this white paper useful
Related white papers
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...
Support Strategies: Customer Experience Management
Customer experience is the most powerful tool available today for distinguishing your company from competitors ? each contact with the customer offers an opportunity for strengthening your relationships by delivering...
3 Strategies for Reducing IT Support Costs
As companies brace for more bumps in the economic downturn, many organisations are indiscriminately cutting costs. To ensure a seamless transition into the post-recession market, however, slashing and burning is...
Forrester Strategies for Assessing IT Business Satisfaction
If you aren't assessing customer satisfaction you are overlooking a potential goldmine. This valuable data is crucial to creating a successful IT strategy. But where do you start? This new...
Realising the benefits of going green
Cross over to greener communications with improved data accuracy. Many organisations have processes in place to improve the quality of their contact data to address business drivers, such as cost reduction...
Centrinet case study
Centrinet launched an innovative business service - Smartbunker - based on renewable energy and energy-efficient technology(efficient IBM BladeCenter servers and Cisco networking hardware), It's the UK's first managed data centre...
IBM Virtualization Services
Virtualization is a powerful technology and can have profound effects on the datacenter; however, it should be viewed as a component of an overall IT strategy that will be able...
