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.
Did you find this white paper useful?
15 out of 27 users found this white paper useful
Related white papers
Connecting international businesses securely
Globalisation, efficiency and responsiveness in an incresaingly regulatory environment
Harnessing technology for competitive advantage
The Leisure, Entertainment and Travel Services ICT transition.
PCI Compliance
The new reality for European retail companies
Stakeholders' management and collaboration
How to devise an effective communication strategy
The need for real-time communications in European logistics
Value-added services beyond transportation
e-booking and e-ticketing
How to achieve sustainable competitive advantage in the Leisure, Entertainment and Traval industry.
Live Webcast: Telecoms 2.0 - Where is telecoms heading?
Telecoms 2.0 - Where is telecoms heading? UK telecoms is at a crossroads. IT managers face new demands to enable flexible working, deliver converged networks and provide support for multiple applications...
