Adjusting your PROC SQL Know-how When Using FEDSQL
11/05/2021 by Kim Battaglia
Maybe you have heard FEDSQL is compliant with the Core ANSI 1999 standards, but what does this mean when writing queries? How does it differ from the queries you are used to writing under PROC SQL that were more aligned to the ANSI 1992 standards?
This paper explores these questions and more. You will find information about the FEDSQL expansion of data types, changes in quoting, implicit and explicit passthrough, as well as many more topics.
If you have a specific area of interest, the appendix provides a quick reference to allow the reader to drill down to those sections of interest.