Transcription of 261-30: Manipulating Data with PROC SQL
{{id}} {{{paragraph}}}
Example: bankruptcy
261-30: Manipulating Data with PROC SQL
1 Paper 261-30 Manipulating data with PROC SQL Kirk Paul Lafler, Software Intelligence Corporation ABSTRACT PROC SQL is a popular database language with numerous extensions for working with numeric and character data including an assortment of operators, functions, and predicates. This paper presents coding techniques that perform text case conversions, concatenation of two or more character strings, pattern and phonetic matching operations, updates to data in a table, and other useful coding techniques for SAS and PROC SQL users. INTRODUCTION PROC SQL provides numerous arithmetic, statistical, and summary functions to manipulate numeric data .
1 Paper 261-30 Manipulating Data with PROC SQL Kirk Paul Lafler, Software Intelligence Corporation ABSTRACT PROC SQL isa popular database language with numerous extensionsfor working with numeric and character data
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
Related search queries
Language, SQL language, SQL Data Manipulation Language, SQL Facts SQL stands for Structured Query, SQL Facts SQL stands for Structured Query Language SQL, Language SQL, Without PROC SQL and, WITHOUT PROC SQL AND THE MACRO LANGUAGE, MERGING vs. JOINING: Comparing the DATA Step, SAS SQL, 1 Stored Procedures in PL/SQL, ORACLE: A HOW-TO GUIDE FOR PL/SQL USERS, Advanced Subqueries In PROC SQL