Implicit vs Explicit Pass Through Connection in SAS

[@kadamachivenkatesh7884]

Super brother .. I got the difference now

[@MindfulDataMine]

Thanks

[@deveshkumar28]

Sir you are amazing

[@MindfulDataMine]

Thanks

[@Pandimoori_krish]

Kindly give difference beteeen implicit ant explicit queries which functions not work in proc sql

[@MindfulDataMine]

Apologies for the delayed reply. When we say Implicit pass through, we ask sas to convert our data step or proc step into a language which can be understood by the database(mysql, postgresql, db2, etc). Since SAS has its own set of fuctions which it understands so it is capable of converting them into a meaningful sql equivalent (using data step) and hence you will notice the basic string, numeric and date fuction will work fine if you use data step. In case of explicit pass through, we ask sas not to convert anything but pass the query as it is because we are writting it as per the database requirements or in a language which is understood by the database. Now talking about Proc sql. Proc sql is a procedure that supports basic sql to extract data from a data set. In previous versions of SAS proc sql might have limited functions but as per the latest documentation of SAS (ref: documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/sqlproc/p020urejdmvi7vn1t9avbvazqapu.htm#n1m7yq30xh775vn1m56ke6q810b7) it supports most of the functions.

[@jaideep1222]

After creating a linbname with PG, can we make the updates to the datasets that belongs to PG ? or PG libname datasets are only part of external db ?

[@MindfulDataMine]

Yes we can make the updates to the dataset but instead of set use modify statement.