1 The SAS System 09:03 Wednesday, January 30, 2019
1 ;*';*";*/;quit;run;
2 OPTIONS PAGENO=MIN;
3 %LET _CLIENTTASKLABEL='BTOT';
4 %LET _CLIENTPROCESSFLOWNAME='Flujo del proceso';
5 %LET _CLIENTPROJECTPATH='';
6 %LET _CLIENTPROJECTPATHHOST='';
7 %LET _CLIENTPROJECTNAME='';
8 %LET _SASPROGRAMFILE='\\10.1.1.55\Gerencia_Credito\Administración de Portafolio\5. Reporting & Monitoring\Proyectos y
8 ! Herramientas - P&P\Proyectos SAS & SQL - P&P\Portafolio\PROYECTO SAS&SQL\CODIGOS SAS&SQL\BTOT.sas';
9 %LET _SASPROGRAMFILEHOST='BANEM052';
10
11 ODS _ALL_ CLOSE;
12 OPTIONS DEV=PNG;
13 GOPTIONS XPIXELS=0 YPIXELS=0;
14 FILENAME EGSR TEMP;
15 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR
16 STYLE=HtmlBlue
17 STYLESHEET=(URL="file:///C:/Program%20Files%20(x86)/SASHome/x86/SASEnterpriseGuide/7.1/Styles/HtmlBlue.css")
18 NOGTITLE
19 NOGFOOTNOTE
20 GPATH=&sasworklocation
21 ENCODING=UTF8
22 options(rolap="on")
23 ;
NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR
24
25 GOPTIONS ACCESSIBLE;
26 OPTIONS COMPRESS=YES;
27
28 /*CORRER EL CÓDIGO "BASETOT ENDF600" EN SQL Y MODIFICAR PLANTILLAS DE ENDF600 Y GESTOR - IMPORTAR A WORK LAS BASES:
29 -ENDF600 TOTAL Y LA NOMBREO ENDF600
30 -LSGESTOR Y LA NOMBRO GESTOR
31 -JERARQUIA Y LA NOMBRO JERARQUIA
32 -BASE TOTAL ANTERIOR (NOMBRE DEL PROYECTO,GESTOR MES ANTERIOR,BANCA MES ANTERIOR)
33 Y LA NOMBRO BTOTANT
34 -BASE TIPOS DE ENDEUDAMIENTO Y LA NOMBRO ENDEUD
35 -BASE QR Y LA NOMBRO QR
36 */
37
38 PROC SQL;
39 create table ENDf6002 as select
40 NROIDENTIFICACION,
41 NROOBLIGACIONT,
42 NROOBLIGACION,
43 ENDPRO,
44
45 case when ENDPRO = 1638 then '4 x 1000'
46 when ENDPRO in (1410, 1427) then 'Constructor'
47 when ENDPRO = 8066 then 'Corresponsales No Bancarios'
48 when ENDPRO in (1106, 1108, 1110, 1111, 1115, 1602, 1603, 1604, 1605, 1615) then 'Fomento'
49 when ENDPRO in (1102, 1401, 1413) then 'Hipotecario'
50 when ENDPRO = 5840 then 'Leasing Inmuebles'
51 when ENDPRO = 5822 then 'Leasing maquinaria'
52 when ENDPRO in (5852, 5867) then 'Leasing otros'
53 when ENDPRO in (1327, 5812) then 'Leasing vehiculos'
54 when ENDPRO in (1101, 1501, 1502, 1505, 1506, 1507, 1509, 1513, 1514, 1517, 1601, 1765, 1783, 4010, 4011, 11015, 11018,
2 The SAS System 09:03 Wednesday, January 30, 2019
54 ! 11024)then 'Ordinaria'
55 when ENDPRO in (1781, 1782, 11012, 11013, 11025, 11027, 11030) then 'Otros'
56 when ENDPRO = 1325 then 'Plan Menor'
57 when ENDPRO in (1113, 1114, 1613, 1614, 1738,1778, 2207, 2252, 2275, 2595, 2598, 2720, 2722, 2724, 2725, 8071) then
57 ! 'Pymes'
58 when ENDPRO in (8006, 8052, 8053, 8056, 8065, 8073, 8074) then 'Sobregiro'
59 when ENDPRO in (7040, 7041) then 'Tarjeta de Crédito'
60 when ENDPRO in (1107, 1608) then 'Tesoreria'
61 when ENDPRO IN (1178, 11022, 11029) then '#N/A'
62 else 'Revisar' end as PRODUCTOANTIGUO,
63
64 PRODUCTONUEVO,
65 NOMBRECORTO,
66 NOMBRECLIENTE,
67 NOMBREDELPROYECTO,
68 GESTORMESANTERIOR,
69 GESTORQUERY,
70 VALIDGESTOR,
71 GESTOR,
72 GERENTE,
73 GERENTEZONA,
74 BANCAMESANTERIOR,
75 VALIDACION,
76 BANCARECONSTRUIDA,
77 SEGMENTO,
78 QR,
79 TIPOCUENTA,
80 TIPOMONEDA,
81 SALDOCUENTA,
82 COMPCONTRACICL,
83 COMPPROCICLICO,
84 SALPRV,
85 VARICONTRACICL,
86 VARIPROCICLICO,
87 VARPRN,
88 VARPRN2,
89 VALIDACION,
90 RECUCONTRACICL,
91 RECUPROCICLICO,
92 RECPRV,
93 GASTCONTRACICL,
94 GASTPROCICLICO,
95 GASPRV,
96 CODIGOENTIDAD,
97 TIPOCREDITO,
98 TIPOIDENTIFICAC,
99 DIGITOCHEQUEO,
100 AÑODECORTE,
101 MESDECORTE,
102 DIADECORTE,
103 SALDOPROVISION,
104 VALORGARANTIA,
105 CLASEGARANTIA,
106 TEMPORALIDADBANCO,
107 DIASDEMORA,
108 RANGOMORA,
109 CALIFARRASTSARC,
110 HOMOLOGACIONCALIFICACION,
3 The SAS System 09:03 Wednesday, January 30, 2019
111 RANGOCALIFICACION,
112 CLASIFCARTERACIAL,
113 PROVITOTALINDIV,
114 PROVIINDIVIDUAL,
115 PROVICONTRACICLICA,
116 ENDVLR3,
117 ENDVLR9
118 from ENDF600
119 quit;
WARNING: Variable VALIDACION already exists on file WORK.ENDF6002.
MVA_DSIO.OPEN_CLOSE| _DISARM| STOP| _DISARM| 2019-01-30T11:52:56,924-05:00| _DISARM| WorkspaceServer| _DISARM| SAS|
_DISARM| | _DISARM| 50698| _DISARM| 26644480| _DISARM| 12| _DISARM| 20| _DISARM| 31240| _DISARM| 7102960| _DISARM| 0.180000|
_DISARM| 0.178466| _DISARM| 1864486376.746088| _DISARM| 1864486376.924554| _DISARM| 0.150000| _DISARM| | _ENDDISARM
NOTE: Compressing data set WORK.ENDF6002 decreased size by 35.09 percent.
Compressed is 246 pages; un-compressed would require 379 pages.
MVA_DSIO.OPEN_CLOSE| _DISARM| STOP| _DISARM| 2019-01-30T11:52:56,930-05:00| _DISARM| WorkspaceServer| _DISARM| SAS|
_DISARM| | _DISARM| 50698| _DISARM| 26644480| _DISARM| 12| _DISARM| 20| _DISARM| 31496| _DISARM| 7103216| _DISARM| 0.180000|
_DISARM| 0.182647| _DISARM| 1864486376.747759| _DISARM| 1864486376.930406| _DISARM| 0.150000| _DISARM| | _ENDDISARM
NOTE: Table WORK.ENDF6002 created, with 50698 rows and 58 columns.
120
PROCEDURE| _DISARM| STOP| _DISARM| 2019-01-30T11:52:56,930-05:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| |
_DISARM| 61263872| _DISARM| 26644480| _DISARM| 12| _DISARM| 20| _DISARM| 31504| _DISARM| 7103216| _DISARM| 0.180000| _DISARM|
0.187367| _DISARM| 1864486376.743491| _DISARM| 1864486376.930858| _DISARM| 0.150000| _DISARM| | _ENDDISARM
NOTE: PROCEDURE SQL used (Total process time):
real time 0.18 seconds
cpu time 0.18 seconds
121 proc sql;
122 create table BTOTANT as select
123 NUMIDE,
124 max(NOMBRE3) as NOMBRE3,
125 max(GESTANT) as GESTANT,
126 max(BANCA) as BANCA
127 from BTOTANT
128 group by NUMIDE
129 order by NUMIDE;
WARNING: This CREATE TABLE statement recursively references the target table. A consequence of this is a possible data integrity
problem.
MVA_DSIO.OPEN_CLOSE| _DISARM| STOP| _DISARM| 2019-01-30T11:52:56,946-05:00| _DISARM| WorkspaceServer| _DISARM| SAS|
_DISARM| | _DISARM| 10663| _DISARM| 26644480| _DISARM| 12| _DISARM| 20| _DISARM| 1288| _DISARM| 7104504| _DISARM| 0.010000|
_DISARM| 0.013629| _DISARM| 1864486376.932908| _DISARM| 1864486376.946537| _DISARM| 0.010000| _DISARM| | _ENDDISARM
NOTE: Compressing data set WORK.BTOTANT increased size by 8.33 percent.
Compressed is 13 pages; un-compressed would require 12 pages.
MVA_DSIO.OPEN_CLOSE| _DISARM| STOP| _DISARM| 2019-01-30T11:52:56,947-05:00| _DISARM| WorkspaceServer| _DISARM| SAS|
_DISARM| | _DISARM| 10663| _DISARM| 26644480| _DISARM| 12| _DISARM| 20| _DISARM| 1680| _DISARM| 7104896| _DISARM| 0.020000|
_DISARM| 0.013705| _DISARM| 1864486376.933905| _DISARM| 1864486376.947610| _DISARM| 0.010000| _DISARM| | _ENDDISARM
NOTE: Table WORK.BTOTANT created, with 10663 rows and 4 columns.
130 quit;
PROCEDURE| _DISARM| STOP| _DISARM| 2019-01-30T11:52:56,947-05:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| |
_DISARM| 61263872| _DISARM| 26644480| _DISARM| 12| _DISARM| 20| _DISARM| 1680| _DISARM| 7104896| _DISARM| 0.020000| _DISARM|
0.016014| _DISARM| 1864486376.931918| _DISARM| 1864486376.947932| _DISARM| 0.010000| _DISARM| | _ENDDISARM
NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
cpu time 0.02 seconds
4 The SAS System 09:03 Wednesday, January 30, 2019
131
132 PROC SQL;
133 CREATE TABLE B1 as select * from
134 (select * from ENDF6002)A
135 left join
136 (select * from BTOTANT)B
137 On A.NROIDENTIFICACION=B.NUMIDE;
MVA_DSIO.OPEN_CLOSE| _DISARM| STOP| _DISARM| 2019-01-30T11:52:57,214-05:00| _DISARM| WorkspaceServer| _DISARM| SAS|
_DISARM| | _DISARM| 50698| _DISARM| 27430912| _DISARM| 12| _DISARM| 20| _DISARM| 85904| _DISARM| 7190800| _DISARM| 0.280000|
_DISARM| 0.265087| _DISARM| 1864486376.949359| _DISARM| 1864486377.214446| _DISARM| 0.220000| _DISARM| | _ENDDISARM
MVA_DSIO.OPEN_CLOSE| _DISARM| STOP| _DISARM| 2019-01-30T11:52:57,214-05:00| _DISARM| WorkspaceServer| _DISARM| SAS|
_DISARM| | _DISARM| 10663| _DISARM| 27430912| _DISARM| 12| _DISARM| 20| _DISARM| 85904| _DISARM| 7190800| _DISARM| 0.280000|
_DISARM| 0.265099| _DISARM| 1864486376.949633| _DISARM| 1864486377.214732| _DISARM| 0.220000| _DISARM| | _ENDDISARM
NOTE: Compressing data set WORK.B1 decreased size by 35.62 percent.
Compressed is 282 pages; un-compressed would require 438 pages.
MVA_DSIO.OPEN_CLOSE| _DISARM| STOP| _DISARM| 2019-01-30T11:52:57,220-05:00| _DISARM| WorkspaceServer| _DISARM| SAS|
_DISARM| | _DISARM| 50698| _DISARM| 27430912| _DISARM| 12| _DISARM| 20| _DISARM| 86160| _DISARM| 7191056| _DISARM| 0.290000|
_DISARM| 0.268059| _DISARM| 1864486376.952013| _DISARM| 1864486377.220072| _DISARM| 0.220000| _DISARM| | _ENDDISARM
NOTE: Table WORK.B1 created, with 50698 rows and 62 columns.
138 quit;
PROCEDURE| _DISARM| STOP| _DISARM| 2019-01-30T11:52:57,226-05:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| |
_DISARM| 61263872| _DISARM| 27430912| _DISARM| 12| _DISARM| 20| _DISARM| 86168| _DISARM| 7191064| _DISARM| 0.290000| _DISARM|
0.277539| _DISARM| 1864486376.948654| _DISARM| 1864486377.226193| _DISARM| 0.220000| _DISARM| | _ENDDISARM
NOTE: PROCEDURE SQL used (Total process time):
real time 0.27 seconds
cpu time 0.29 seconds
139
140 PROC SQL;
141 CREATE TABLE B2 as select * from
142 (select * from B1)A
143 left join
144 (select * from ENDEUD)B
145 On A.ENDPRO=B.COD;
MVA_DSIO.OPEN_CLOSE| _DISARM| STOP| _DISARM| 2019-01-30T11:52:57,496-05:00| _DISARM| WorkspaceServer| _DISARM| SAS|
_DISARM| | _DISARM| 50698| _DISARM| 27430912| _DISARM| 12| _DISARM| 20| _DISARM| 96536| _DISARM| 7287600| _DISARM| 0.300000|
_DISARM| 0.268189| _DISARM| 1864486377.227964| _DISARM| 1864486377.496153| _DISARM| 0.210000| _DISARM| | _ENDDISARM
MVA_DSIO.OPEN_CLOSE| _DISARM| STOP| _DISARM| 2019-01-30T11:52:57,496-05:00| _DISARM| WorkspaceServer| _DISARM| SAS|
_DISARM| | _DISARM| 773| _DISARM| 27430912| _DISARM| 12| _DISARM| 20| _DISARM| 96536| _DISARM| 7287600| _DISARM| 0.300000| _DISARM|
0.268079| _DISARM| 1864486377.228372| _DISARM| 1864486377.496451| _DISARM| 0.210000| _DISARM| | _ENDDISARM
NOTE: Compressing data set WORK.B2 decreased size by 33.77 percent.
Compressed is 306 pages; un-compressed would require 462 pages.
MVA_DSIO.OPEN_CLOSE| _DISARM| STOP| _DISARM| 2019-01-30T11:52:57,502-05:00| _DISARM| WorkspaceServer| _DISARM| SAS|
_DISARM| | _DISARM| 50698| _DISARM| 27430912| _DISARM| 12| _DISARM| 20| _DISARM| 96800| _DISARM| 7287864| _DISARM| 0.310000|
_DISARM| 0.272242| _DISARM| 1864486377.229849| _DISARM| 1864486377.502091| _DISARM| 0.210000| _DISARM| | _ENDDISARM
NOTE: Table WORK.B2 created, with 50698 rows and 64 columns.
146 quit;
PROCEDURE| _DISARM| STOP| _DISARM| 2019-01-30T11:52:57,525-05:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| |
_DISARM| 61263872| _DISARM| 27430912| _DISARM| 12| _DISARM| 20| _DISARM| 96808| _DISARM| 7287872| _DISARM| 0.310000| _DISARM|
0.298157| _DISARM| 1864486377.227091| _DISARM| 1864486377.525248| _DISARM| 0.210000| _DISARM| | _ENDDISARM
NOTE: PROCEDURE SQL used (Total process time):
real time 0.29 seconds
cpu time 0.31 seconds
5 The SAS System 09:03 Wednesday, January 30, 2019
147
148 proc sql;
149 create table GESTOR as select
150 CUSSNR,
151 max(CFOFFN) as CFOFFN,
152 max(CUNA1) as CUNA1
153 from GESTOR
154 group by CUSSNR
155 order by CUSSNR;
WARNING: This CREATE TABLE statement recursively references the target table. A consequence of this is a possible data integrity
problem.
MVA_DSIO.OPEN_CLOSE| _DISARM| STOP| _DISARM| 2019-01-30T11:52:57,540-05:00| _DISARM| WorkspaceServer| _DISARM| SAS|
_DISARM| | _DISARM| 9917| _DISARM| 27430912| _DISARM| 12| _DISARM| 20| _DISARM| 1288| _DISARM| 7289160| _DISARM| 0.010000| _DISARM|
0.011547| _DISARM| 1864486377.528745| _DISARM| 1864486377.540292| _DISARM| 0.010000| _DISARM| | _ENDDISARM
NOTE: Compressing data set WORK.GESTOR increased size by 22.22 percent.
Compressed is 11 pages; un-compressed would require 9 pages.
MVA_DSIO.OPEN_CLOSE| _DISARM| STOP| _DISARM| 2019-01-30T11:52:57,541-05:00| _DISARM| WorkspaceServer| _DISARM| SAS|
_DISARM| | _DISARM| 9917| _DISARM| 27430912| _DISARM| 12| _DISARM| 20| _DISARM| 1416| _DISARM| 7289288| _DISARM| 0.010000| _DISARM|
0.011425| _DISARM| 1864486377.529617| _DISARM| 1864486377.541042| _DISARM| 0.010000| _DISARM| | _ENDDISARM
NOTE: Table WORK.GESTOR created, with 9917 rows and 3 columns.
156 quit;
PROCEDURE| _DISARM| STOP| _DISARM| 2019-01-30T11:52:57,541-05:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| |
_DISARM| 61263872| _DISARM| 27430912| _DISARM| 12| _DISARM| 20| _DISARM| 1416| _DISARM| 7289288| _DISARM| 0.020000| _DISARM|
0.015160| _DISARM| 1864486377.526153| _DISARM| 1864486377.541313| _DISARM| 0.010000| _DISARM| | _ENDDISARM
NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
cpu time 0.02 seconds
157
158 PROC SQL;
159 CREATE TABLE B3 as select * from
160 (select * from B2)A
161 left join
162 (select * from GESTOR)B
163 On A.NROIDENTIFICACION=B.CUSSNR;
MVA_DSIO.OPEN_CLOSE| _DISARM| STOP| _DISARM| 2019-01-30T11:52:57,847-05:00| _DISARM| WorkspaceServer| _DISARM| SAS|
_DISARM| | _DISARM| 50698| _DISARM| 27430912| _DISARM| 12| _DISARM| 20| _DISARM| 104208| _DISARM| 7393496| _DISARM| 0.340000|
_DISARM| 0.304556| _DISARM| 1864486377.542781| _DISARM| 1864486377.847337| _DISARM| 0.250000| _DISARM| | _ENDDISARM
MVA_DSIO.OPEN_CLOSE| _DISARM| STOP| _DISARM| 2019-01-30T11:52:57,847-05:00| _DISARM| WorkspaceServer| _DISARM| SAS|
_DISARM| | _DISARM| 9917| _DISARM| 27430912| _DISARM| 12| _DISARM| 20| _DISARM| 104208| _DISARM| 7393496| _DISARM| 0.340000|
_DISARM| 0.304485| _DISARM| 1864486377.543158| _DISARM| 1864486377.847643| _DISARM| 0.250000| _DISARM| | _ENDDISARM
NOTE: Compressing data set WORK.B3 decreased size by 33.20 percent.
Compressed is 336 pages; un-compressed would require 503 pages.
MVA_DSIO.OPEN_CLOSE| _DISARM| STOP| _DISARM| 2019-01-30T11:52:57,855-05:00| _DISARM| WorkspaceServer| _DISARM| SAS|
_DISARM| | _DISARM| 50698| _DISARM| 27430912| _DISARM| 12| _DISARM| 20| _DISARM| 104464| _DISARM| 7393752| _DISARM| 0.350000|
_DISARM| 0.311226| _DISARM| 1864486377.544497| _DISARM| 1864486377.855723| _DISARM| 0.250000| _DISARM| | _ENDDISARM
NOTE: Table WORK.B3 created, with 50698 rows and 67 columns.
164 quit;
PROCEDURE| _DISARM| STOP| _DISARM| 2019-01-30T11:52:57,863-05:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| |
_DISARM| 61263872| _DISARM| 27430912| _DISARM| 12| _DISARM| 20| _DISARM| 104480| _DISARM| 7393768| _DISARM| 0.360000| _DISARM|
0.321305| _DISARM| 1864486377.542070| _DISARM| 1864486377.863375| _DISARM| 0.250000| _DISARM| | _ENDDISARM
NOTE: PROCEDURE SQL used (Total process time):
real time 0.32 seconds
cpu time 0.36 seconds
6 The SAS System 09:03 Wednesday, January 30, 2019
165
166 PROC SQL;
167 create table B4 as select
168 NROIDENTIFICACION,
169 NROOBLIGACIONT,
170 NROOBLIGACION,
171 ENDPRO,
172 PRODUCTOANTIGUO,
173 DESCRIPCION as PRODUCTONUEVO,
174 NOMBRECORTO,
175 NOMBRE3 as NOMBRECLIENTE,
176 CUNA1 as NOMBREDELPROYECTO,
177 GESTANT as GESTORMESANTERIOR,
178 CFOFFN as GESTORQUERY,
179
180 case when CALCULATED GESTORMESANTERIOR = CALCULATED GESTORQUERY then 'VERDADERO' else 'FALSO' end as VALIDGESTOR,
181
182 case when CALCULATED VALIDGESTOR = 'VERDADERO' then CALCULATED GESTORMESANTERIOR else 'REVISAR' end as GESTOR,
183
184 GERENTE,
185 GERENTEZONA,
186 BANCA as BANCAMESANTERIOR,
187
188 BANCA,
189
190 VALIDACION,
191 BANCARECONSTRUIDA,
192 SEGMENTO,
193 QR,
194 TIPOCUENTA,
195 TIPOMONEDA,
196 SALDOCUENTA,
197 COMPCONTRACICL,
198 COMPPROCICLICO,
199 SALPRV,
200 VARICONTRACICL,
201 VARIPROCICLICO,
202 VARPRN,
203 VARPRN2,
204 RECUCONTRACICL,
205 RECUPROCICLICO,
206 RECPRV,
207 GASTCONTRACICL,
208 GASTPROCICLICO,
209 GASPRV,
210 CODIGOENTIDAD,
211 TIPOCREDITO,
212 TIPOIDENTIFICAC,
213 DIGITOCHEQUEO,
214 AÑODECORTE,
215 MESDECORTE,
216 DIADECORTE,
217 SALDOPROVISION,
218 VALORGARANTIA,
219 CLASEGARANTIA,
220
7 The SAS System 09:03 Wednesday, January 30, 2019
221 case when DIASMO >0 and DIASMO <31 then 1
222 when DIASMO >30 and DIASMO <61 then 2
223 when DIASMO >60 and DIASMO <91 then 3
224 when DIASMO >90 and DIASMO <121 then 4
225 when DIASMO >120 and DIASMO <151 then 5
226 when DIASMO >150 and DIASMO <181 then 6
227 when DIASMO >180 and DIASMO <211 then 7
228 when DIASMO >210 and DIASMO <241 then 8
229 when DIASMO >240 and DIASMO <271 then 9
230 when DIASMO >270 and DIASMO <301 then 10
231 when DIASMO >300 and DIASMO <331 then 11
232 when DIASMO >330 and DIASMO <361 then 12
233 when DIASMO >360 and DIASMO <391 then 13
234 when DIASMO >390 and DIASMO <421 then 14
235 when DIASMO >420 and DIASMO <451 then 15
236 when DIASMO=0 then 0 else 16 end as TEMPORALIDADBANCO,
237
238 DIASDEMORA,
239 RANGOMORA,
240 CALIFARRASTSARC,
241 HOMOLOGACIONCALIFICACION,
242 RANGOCALIFICACION,
243 CLASIFCARTERACIAL,
244 PROVITOTALINDIV,
245 PROVIINDIVIDUAL,
246 PROVICONTRACICLICA,
247 ENDVLR3,
248 ENDVLR9,
249 NUMIDE,
250 COD,
251 CUSSNR
252 from B3
253
254 quit;
ERROR: The following columns were not found in the contributing tables: DIASMO.
ERROR: The following columns were not found as CALCULATED references in the immediate query: GESTORMESANTERIOR, GESTORQUERY.
MVA_DSIO.OPEN_CLOSE| _DISARM| STOP| _DISARM| 2019-01-30T11:52:57,866-05:00| _DISARM| WorkspaceServer| _DISARM| SAS|
_DISARM| | _DISARM| 50698| _DISARM| 27430912| _DISARM| 12| _DISARM| 20| _DISARM| 0| _DISARM| 7393768| _DISARM| 0.000000| _DISARM|
0.000650| _DISARM| 1864486377.865924| _DISARM| 1864486377.866574| _DISARM| 0.000000| _DISARM| | _ENDDISARM
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
255
256
257
258
259 GOPTIONS NOACCESSIBLE;
260 %LET _CLIENTTASKLABEL=;
261 %LET _CLIENTPROCESSFLOWNAME=;
262 %LET _CLIENTPROJECTPATH=;
263 %LET _CLIENTPROJECTPATHHOST=;
264 %LET _CLIENTPROJECTNAME=;
265 %LET _SASPROGRAMFILE=;
266 %LET _SASPROGRAMFILEHOST=;
267
268 ;*';*";*/;quit;
NOTE: The SAS System stopped processing this step because of errors.
PROCEDURE| _DISARM| STOP| _DISARM| 2019-01-30T11:52:57,867-05:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| |
_DISARM| 61263872| _DISARM| 27430912| _DISARM| 12| _DISARM| 20| _DISARM| 0| _DISARM| 7393768| _DISARM| 0.000000| _DISARM| 0.002954|
_DISARM| 1864486377.864269| _DISARM| 1864486377.867223| _DISARM| 0.000000| _DISARM| | _ENDDISARM
8 The SAS System 09:03 Wednesday, January 30, 2019
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
268 ! run;
269 ODS _ALL_ CLOSE;
270
271
272 QUIT; RUN;
273
