because the data is not included in the table?

wrosario — Tue, 24 Mar 2015 13:45:30 GMT

/* INICIO CONTROLE DE CARGA INCREMENTAL E INICIAL */

%macro test;

PROC SQL;

CREATE TABLE TMP_SIAR.W1ZZ34(

NUMFUNC NUM FORMAT = 10. INFORMAT = 10. ,

NUMVINC NUM FORMAT = 9. INFORMAT = 9. ,

DTINI NUM FORMAT = DATETIME20. INFORMAT = DATETIME20. ,

DTFIM NUM FORMAT = DATETIME20. INFORMAT = DATETIME20. ,

FUNCAO NUM FORMAT = 7. INFORMAT = 7. ,

SETOR CHAR(15) FORMAT = $15. INFORMAT = $15.,

EMP_CODIGO NUM FORMAT = 3. INFORMAT = 3. ,

SK_NUM_PROCESSO_JOB NUM);

SELECT COUNT(1) AS CONT1 INTO :CONT1 FROM SIAR_CGA.CONTROLE_CARGA_JOBS WHERE COD_UNI_JOB IN (1,3);

SELECT COUNT(1) AS TAB1 INTO :TAB1 FROM FAT_SIAR.FAT_PROV_DESIG_SUBST WHERE COD_ORIGEM_TABELA = 1;

QUIT;

%IF &CONT1=0 %THEN %DO;

%IF &TAB1=0 %THEN %DO;

PROC SQL PRINT;

INSERT INTO TMP_SIAR.W1ZZ34

SELECT

ODS_DESIGNACOES_EV.NUMFUNC,

ODS_DESIGNACOES_EV.NUMVINC,

ODS_DESIGNACOES_EV.DTINI,

ODS_DESIGNACOES_EV.DTFIM,

ODS_DESIGNACOES_EV.FUNCAO,

ODS_DESIGNACOES_EV.SETOR,

ODS_DESIGNACOES_EV.EMP_CODIGO,

0 AS SK_NUM_PROCESSO_JOB

FROM ODS_SIAR.ODS_DESIGNACOES_EV AS ODS_DESIGNACOES_EV INNER JOIN

DIM_SIAR.DIM_VINCULO AS DIM_VINCULO

(

ODS_DESIGNACOES_EV.NUMFUNC = DIM_VINCULO.NUM_SERVIDOR

AND ODS_DESIGNACOES_EV.NUMVINC = DIM_VINCULO.NUM_VINCULO

AND ODS_DESIGNACOES_EV.EMP_CODIGO = DIM_VINCULO.COD_EMPRESA

);

QUIT;

%END;

%ELSE %DO;

PROC SQL PRINT;

INSERT INTO TMP_SIAR.W1ZZ34

SELECT

ODS_DESIGNACOES_EV.NUMFUNC,

ODS_DESIGNACOES_EV.NUMVINC,

ODS_DESIGNACOES_EV.DTINI,

ODS_DESIGNACOES_EV.DTFIM,

ODS_DESIGNACOES_EV.FUNCAO,

ODS_DESIGNACOES_EV.SETOR,

ODS_DESIGNACOES_EV.EMP_CODIGO,

CONTROLE_CARGA_JOBS.SK_NUM_PROCESSO_JOB

FROM

ODS_SIAR.ODS_DESIGNACOES_EV AS ODS_DESIGNACOES_EV

INNER JOIN DIM_SIAR.DIM_VINCULO AS DIM_VINCULO

(

ODS_DESIGNACOES_EV.NUMFUNC = DIM_VINCULO.NUM_SERVIDOR

AND ODS_DESIGNACOES_EV.NUMVINC = DIM_VINCULO.NUM_VINCULO

AND ODS_DESIGNACOES_EV.EMP_CODIGO = DIM_VINCULO.COD_EMPRESA

)

INNER JOIN SIAR_CGA.CONTROLE_CARGA_JOBS AS CONTROLE_CARGA_JOBS

(

CONTROLE_CARGA_JOBS.NUM_SERVIDOR = ODS_DESIGNACOES_EV.NUMFUNC

AND CONTROLE_CARGA_JOBS.NUM_VINCULO = ODS_DESIGNACOES_EV.NUMVINC

AND CONTROLE_CARGA_JOBS.COD_UNI_JOB IN (1,3)

);

QUIT;

%END;

%mend test;

Re: because the data is not included in the table?

ballardw — Tue, 24 Mar 2015 14:23:26 GMT

And the question is???

Re: because the data is not included in the table?

wrosario — Tue, 24 Mar 2015 14:55:06 GMT

Friend, I am running a macro in DI or Guide and neither he is entering the data in the table

to perform separate command by command, works ... I think it may be something in the IF, already checked the tables and the same are loaded

Re: because the data is not included in the table?

RW9 — Tue, 24 Mar 2015 15:17:35 GMT

Hi,

Might I suggest some debugging. I.e.

options mlogic mprint symbolgen source source2;

Run it, find out what errors/warnings come up. Then look at the code causing it, what do the macro variables resolve to etc. We can see nothing from the code you have posted, as we don't know your data. What happens when you run just the first proc sql, what macro variables are created?

topic Re: because the data is not included in the table? in SAS Programming

because the data is not included in the table?

Re: because the data is not included in the table?

Re: because the data is not included in the table?

Re: because the data is not included in the table?