sql server 2008 r2 - SAS SQL Pass Through -

i know gets executed first in sas sql pass thru in code:

connect oledb mydb ( %dbconnect( catalog = mydb ) ) ;   create table mydb_extract    select put(parent,$abc.) parent,           put(pfx,z2.) pfx,*      connection mydb      ( select            appointment,parents,children,cats,dogs         mydb.dbo.flatrecord         appointment between '20150801' , '20150831'             , children > 2); disconnect mydb; 

since ms sql-server doesn't support put function query cause of records processed locally or resultant records dbms?

the explicit pass-through query still process , return sas returns (however many records is). then, sas perform put operations on returned rows.

so if 10000 rows in table, , 500 rows meet criteria in where, 500 records go sas , put; sql handle 10000 -> 500.

if had written in implicit pass through, it's possible (if not probable) sas might have done of work.