Pular para conteúdo

2021

  • 1 min de leitura

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;

  • 1 min de leitura

Juntar tabelas com mesmo radical

Juntar tabelas com respectiva LIBNAME num macro
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
PROC SQL NOPRINT;
    SELECT 'DADOS.'||TRIM(MEMNAME) AS MEMNAME
    INTO :TABELAS SEPARATED BY ' '
    FROM SASHELP.VMEMBER
    WHERE LIBNAME = "DADOS"
    AND MEMNAME LIKE "TABELA_2022%"
;QUIT;


%PUT &=TABELAS;


DATA APRC_1;
    SET &TABELAS INDSNAME=DSNAME;

    ANOMES_ARQ = INPUT(SCAN(DSNAME, -1, '_'), 6.);
RUN;