Passionate about SAS Code and Python, we stay up-to-date regarding the latest developments thanks to the SAS training, the SAS Support , the SUGI , the SAS Global Forum, SASENSEI, the SAS Belux User group or the SAS communities.
This page contains interesting papers we collected throught the Web and are used for our coaching preparations and our specific consultancy activities. Download them for free and read them where you want!!!
after an introduction on the proc FedSQL, this paper compare it with the proc SQL, different topics are underlined: benefits, syntax, performance, supported data types.
Introduced in SAS 9,4 Proc FedSQL allows you to query tables of several DBMS systems in a single query. This paper, written in French, explain this procedure in detail and compare it with proc SQL.
This interesting paper start by presenting the Proc FedSDL and compare it with the Proc SQL (performance, data type, sytax..), . Then it shows, after defining what Proc DS2 is, how you can use FedSQL query into DS2.
Proc FedSQL does not replace proc SQL, they are different and should be used for different purpose. This PDF issued from an Ask the Expert session highlight these differences.