Pular para conteúdo

2021

  • 1 min de leitura

SAS Criando DATETIME

Sintaxe criação DATETIME no PROC SQL
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
PROC SQL;
    CREATE TABLE AUX AS
    SELECT 
        MEMNAME
        ,NOBS
        ,dhms('23nov21'd, 23, 6, 11) format datetime20.  as posicao
    from dictionary.tables
    where 
        libname = "ASD" AND 
        MEMNAME IN (&MEMNAMES)      
;QUIT;
  • 1 min de leitura

Criando LIBNAMEs

Conectando LIBNAMEs
1
2
3
4
5
6
/* Conectando com AUTHDOMAIN */
LIBNAME SCHEMA01 DB2 DATABASE=DB01 SCHEMA=SCHEMA01 AUTHDOMAIN=USUARIO;


/* Conectando sem AUTHDOMAIN */
LIBNAME PGCDS postgres SERVER='192.168.0.1' DATABASE='database' PORT='5432' USER='usuario' PASS='senha' schema='schema01';