Consulta de Passagem - SQL Pass-trough

Consulta de passagem com AUTHDOMAIN
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
proc sql;
    connect to db2 (DATABASE=DB01 AUTHDOMAIN=USUARIO);
    create table dados as 
    select * from connection to db2 (
        SELECT 
        *
        FROM schema.tabela 
        WHERE data_ref = current_date;
    ) a;
    disconnect from db2;
quit;

``` SAS title="Consulta de passagem sem AUTHDOMAIN" linenums="1" proc sql; connect to postgres (server='192.168.0.1' port=5432 user=usuario password=senha db=banco); create table dados as select * from connection to postgres ( select * from schema.tabela; ) a; disconnect from postgres; quit;