1 The SAS System 18:05 Friday, April 8, 2016 NOTE: Copyright (c) 2002-2012 by SAS Institute Inc., Cary, NC, USA. NOTE: SAS (r) Proprietary Software 9.4 (TS1M2) Licensed to MUTUAL OF OMAHA BANK - TEST, Site 70188638. NOTE: This session is executing on the Linux 2.6.32-573.12.1.el6.x86_64 (LIN X64) platform. NOTE: Additional host information: Linux LIN X64 2.6.32-573.12.1.el6.x86_64 #1 SMP Mon Nov 23 12:55:32 EST 2015 x86_64 Red Hat Enterprise Linux Server release 6.7 (Santiago) You are running SAS 9. Some SAS 8 files will be automatically converted by the V9 engine; others are incompatible. Please see http://support.sas.com/rnd/migration/planning/platform/64bit.html PROC MIGRATE will preserve current SAS file attributes and is recommended for converting all your SAS libraries from any SAS 8 release to SAS 9. For details and examples, please see http://support.sas.com/rnd/migration/index.html This message is contained in the SAS news file, and is presented upon initialization. Edit the file "news" in the "misc/base" directory to display site-specific news and information in the program log. The command line option "-nonews" will prevent this display. NOTE: SAS Initialization used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: The autoexec file, /sft/SAS/sasconfig/Lev1/SASApp/WorkspaceServer/autoexec.sas, was executed at server initialization. 1 /**************************************************************************** 2 * Job: TESTDH A5PHO1MX.C100001O * 3 * Description: * 4 * * 5 * Metadata Server: lx246.mutualofomahabank.com * 6 * Port: 8561 * 7 * Location: /Shared Data/MOOB/Data/DMI/Jobs * 8 * * 9 * Server: SASApp A5PHO1MX.AT000002 * 10 * * 11 * Source Table: V_DMI_CIF_Daily - A5PHO1MX.BN00007W * 12 * dmiloan.V_DMI_CIF_Daily * 13 * * 14 * Generated on: Friday, April 8, 2016 4:05:11 PM MST * 15 * Generated by: req82259 * 16 * Version: SAS Data Integration Studio 4.9 * 17 ****************************************************************************/ 18 19 /* Generate the process id for job */ 20 %put Process ID: &SYSJOBID; Process ID: 23801 21 22 /* General macro variables */ 2 The SAS System 18:05 Friday, April 8, 2016 23 %let jobID = %quote(A5PHO1MX.C100001O); 24 %let etls_jobName = %nrquote(TESTDH); 25 %let etls_userID = %nrquote(req82259); 26 27 %global applName; 28 data _null_; 29 applName="SAS Data Integration Studio"; 30 call symput('applName',%nrstr(applName)); 31 run; NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 32 /* Performance Statistics require ARM_PROC sub-system */ 33 %macro etls_startPerformanceStats; 34 %log4sas(); 35 %log4sas_logger(Perf.ARM, 'level=info'); 36 options armagent=log4sas armsubsys=(ARM_PROC); 37 %global _armexec; 38 %let _armexec = 1; 39 %perfinit(applname="&applName"); 40 %global etls_recnt; 41 %let etls_recnt=-1; 42 %mend; 43 %etls_startPerformanceStats; NOTE: | _DISARM| REGISTER| _DISARM| 2016-04-08T18:05:12,037-05:00| _DISARM| WorkspaceServer| _DISARM| | _DISARM| | _DISARM| | _DISARM| | _DISARM| | _DISARM| | _DISARM| | _DISARM| | _DISARM| | _DISARM| | _DISARM| | _DISARM| | _DISARM| | _DISARM| | _ENDDISARM 44 45 %macro etls_setArmagent; 46 %let armagentLength = %length(%sysfunc(getoption(armagent))); 47 %if (&armagentLength eq 0) %then 48 %do; 49 %log4sas(); 50 %log4sas_logger(Perf.ARM, 'level=info'); 51 options armagent=log4sas armsubsys=(ARM_PROC); 52 %end; 53 %mend etls_setArmagent; 54 55 %macro etls_setPerfInit; 56 %if "&_perfinit" eq "0" %then 57 %do; 58 %etls_setArmagent; 59 %global _armexec; 60 %let _armexec = 1; 61 %perfinit(applname="&applName"); 62 %end; 63 %mend etls_setPerfInit; 64 65 /* Setup to capture return codes */ 66 %global job_rc trans_rc sqlrc syscc; 67 %let sysrc = 0; 68 %let job_rc = 0; 69 %let trans_rc = 0; 70 %let sqlrc = 0; 71 %let syscc = 0; 3 The SAS System 18:05 Friday, April 8, 2016 72 %global etls_stepStartTime; 73 /* initialize syserr to 0 */ 74 data _null_; run; NOTE: PROCEDURE| _DISARM| STOP| _DISARM| 2016-04-08T18:05:12,054-05:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | _DISARM| 8810496| _DISARM| 8282112| _DISARM| 11| _DISARM| 11| _DISARM| 0| _DISARM| 448| _DISARM| 0.000000| _DISARM| 0.002055| _DISARM| 1775775912.052057| _DISARM| 1775775912.054112| _DISARM| 0.000000| _DISARM| | _ENDDISARM NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds 75 76 %macro rcSet(error); 77 %if (&error gt &trans_rc) %then 78 %let trans_rc = &error; 79 %if (&error gt &job_rc) %then 80 %let job_rc = &error; 81 %mend rcSet; 82 83 %macro rcSetDS(error); 84 if &error gt input(symget('trans_rc'),12.) then 85 call symput('trans_rc',trim(left(put(&error,12.)))); 86 if &error gt input(symget('job_rc'),12.) then 87 call symput('job_rc',trim(left(put(&error,12.)))); 88 %mend rcSetDS; 89 90 /* Create metadata macro variables */ 91 %let IOMServer = %nrquote(SASApp); 92 %let metaPort = %nrquote(8561); 93 %let metaServer = %nrquote(lx246.mutualofomahabank.com); 94 95 /* Set metadata options */ 96 options metaport = &metaPort 97 metaserver = "&metaServer"; 98 99 /* Setup for capturing job status */ 100 %let etls_startTime = %sysfunc(datetime(),datetime.); 101 %let etls_recordsBefore = 0; 102 %let etls_recordsAfter = 0; 103 %let etls_lib = 0; 104 %let etls_table = 0; 105 106 %global etls_debug; 107 %macro etls_setDebug; 108 %if %str(&etls_debug) ne 0 %then 109 OPTIONS MPRINT%str(;); 110 %mend; 111 %etls_setDebug; 112 113 4 The SAS System 18:05 Friday, April 8, 2016 114 /*==========================================================================* 115 * Step: Join A5PHO1MX.BZ0000H3 * 116 * Transform: Join * 117 * Description: * 118 * * 119 * Source Table: V_DMI_CIF_Daily - A5PHO1MX.BN00007W * 120 * dmiloan.V_DMI_CIF_Daily * 121 * Target Table: Join - work.WSA5B5O A5PHO1MX.C900007R * 122 *==========================================================================*/ 123 124 %let transformID = %quote(A5PHO1MX.BZ0000H3); 125 %let trans_rc = 0; 126 %let etls_stepStartTime = %sysfunc(datetime(), datetime20.); 127 128 /* Access the data for DMI_LoanServicing */ 129 LIBNAME dmiloan ODBC DATASRC=DMI_LoanServicing SCHEMA=bnkDbDataGov USER=Hyperion 129 ! PASSWORD=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX ; NOTE: Libref DMILOAN was successfully assigned as follows: Engine: ODBC Physical Name: DMI_LoanServicing 130 %rcSet(&syslibrc); 131 132 %let etls_recnt = 0; 133 %macro etls_recordCheck; 134 %let etls_recCheckExist = %eval(%sysfunc(exist(dmiloan.V_DMI_CIF_Daily, DATA)) or 135 %sysfunc(exist(dmiloan.V_DMI_CIF_Daily, VIEW))); 136 137 %if (&etls_recCheckExist) %then 138 %do; 139 proc sql noprint; 140 select count(*) into :etls_recnt from dmiloan.V_DMI_CIF_Daily; 141 quit; 142 %end; 143 %mend etls_recordCheck; 144 %etls_recordCheck; MPRINT(ETLS_RECORDCHECK): proc sql noprint; MPRINT(ETLS_RECORDCHECK): select count(*) into :etls_recnt from dmiloan.V_DMI_CIF_Daily; MPRINT(ETLS_RECORDCHECK): quit; NOTE: PROCEDURE| _DISARM| STOP| _DISARM| 2016-04-08T18:06:32,935-05:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | _DISARM| 11956224| _DISARM| 9068544| _DISARM| 11| _DISARM| 11| _DISARM| 16| _DISARM| 496| _DISARM| 0.040000| _DISARM| 80.529055| _DISARM| 1775775912.406282| _DISARM| 1775775992.935337| _DISARM| 0.030000| _DISARM| | _ENDDISARM NOTE: PROCEDURE SQL used (Total process time): real time 1:20.52 cpu time 0.05 seconds 145 146 %let SYSLAST = %nrquote(dmiloan.V_DMI_CIF_Daily); 147 148 /* Runtime statistics macros */ 149 %etls_setPerfInit; 150 %perfstrt(txnname=%BQUOTE(_DISARM|&transformID|&syshostname|SQLJoin), metrNam6=_DISROWCNT, metrDef6=Count32) ; MPRINT(PERFSTRT): options notes nosource nosource2 nosymbolgen nomprint nomlogic MPRINT(PERFSTRT): NOSYMBOLGEN ; MPRINT(PERFSTRT): ; MPRINT(PERFSTRT): ; 151 152 %global etls_sql_pushDown; 5 The SAS System 18:05 Friday, April 8, 2016 153 %let etls_sql_pushDown = -1; 154 option DBIDIRECTEXEC; 155 156 proc datasets lib = work nolist nowarn memtype = (data view); 157 delete WSA5B5O; 158 quit; NOTE: PROCEDURE| _DISARM| STOP| _DISARM| 2016-04-08T18:06:32,969-05:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | _DISARM| 11956224| _DISARM| 10641408| _DISARM| 11| _DISARM| 11| _DISARM| 8| _DISARM| 568| _DISARM| 0.020000| _DISARM| 0.021500| _DISARM| 1775775992.948345| _DISARM| 1775775992.969845| _DISARM| 0.020000| _DISARM| | _ENDDISARM NOTE: PROCEDURE DATASETS used (Total process time): real time 0.02 seconds cpu time 0.02 seconds 159 160 proc sql; 161 connect to ODBC 162 ( 163 DATASRC=DMI_LoanServicing USER="Hyperion" PASSWORD=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 164 ); 165 create table work.WSA5B5O as 166 select 167 ABBRNAME length = 8 168 format = $8. 169 informat = $8. 170 label = 'ABBRNAME', 171 ACCLATECHG length = 8 172 format = 24.5 173 informat = 24.5 174 label = 'ACCLATECHG', 175 ACCQDATE length = 10 176 format = $10. 177 informat = $10. 178 label = 'ACCQDATE', 179 ACQPRINBAL length = 8 180 format = 24.5 181 informat = 24.5 182 label = 'ACQPRINBAL', 183 ACRLSTATUS length = 1 184 format = $1. 185 informat = $1. 186 label = 'ACRLSTATUS', 187 AGE length = 5 188 format = $5. 189 informat = $5. 190 label = 'AGE', 191 AGGR length = 3 192 format = $3. 193 informat = $3. 194 label = 'AGGR', 195 AGGR2 length = 3 196 format = $3. 197 informat = $3. 198 label = 'AGGR2', 199 AHCODE length = 1 200 format = $1. 201 informat = $1. 6 The SAS System 18:05 Friday, April 8, 2016 202 label = 'AHCODE', 203 AHFLAG length = 1 204 format = $1. 205 informat = $1. 206 label = 'AHFLAG', 207 AHPREMIUM length = 8 208 format = 24.5 209 informat = 24.5 210 label = 'AHPREMIUM', 211 AMORGLTRM length = 3 212 format = $3. 213 informat = $3. 214 label = 'AMORGLTRM', 215 ANNUALINT length = 8 216 format = 12.5 217 informat = 12.5 218 label = 'ANNUALINT', 219 ANNUALINT2 length = 8 220 format = 12.5 221 informat = 12.5 222 label = 'ANNUALINT2', 223 ARM_IDCODE_1 length = 4 224 format = $4. 225 informat = $4. 226 label = 'ARM_IDCODE_1', 227 ARM_IDXLEAD_DAYS length = 3 228 format = $3. 229 informat = $3. 230 label = 'ARM_IDXLEAD_DAYS', 231 ARM_IND length = 1 232 format = $1. 233 informat = $1. 234 label = 'ARM_IND', 235 ARM_INT length = 8 236 format = 12.5 237 informat = 12.5 238 label = 'ARM_INT', 239 ARM_IRRND_FCTR length = 8 240 format = 12.5 241 informat = 12.5 242 label = 'ARM_IRRND_FCTR', 243 ARM_IRRND_TYPE length = 1 244 format = $1. 245 informat = $1. 246 label = 'ARM_IRRND_TYPE', 247 ARM_MAXCEILING_RT length = 8 248 format = 12.5 249 informat = 12.5 250 label = 'ARM_MAXCEILING_RT', 251 ARM_MAXDEC_RT length = 8 252 format = 12.5 253 informat = 12.5 254 label = 'ARM_MAXDEC_RT', 255 ARM_MAXFLOOR_RT length = 8 256 format = 12.5 257 informat = 12.5 258 label = 'ARM_MAXFLOOR_RT', 259 ARM_MAXINCR_RT length = 8 7 The SAS System 18:05 Friday, April 8, 2016 260 format = 12.5 261 informat = 12.5 262 label = 'ARM_MAXINCR_RT', 263 ARM_OGIRCHNG_DT length = 10 264 format = $10. 265 informat = $10. 266 label = 'ARM_OGIRCHNG_DT', 267 ARM_OGPICHNG_DT length = 10 268 format = $10. 269 informat = $10. 270 label = 'ARM_OGPICHNG_DT', 271 ARMIRCHGDT length = 10 272 format = $10. 273 informat = $10. 274 label = 'ARMIRCHGDT', 275 ARMIRCHGPD length = 3 276 format = $3. 277 informat = $3. 278 label = 'ARMIRCHGPD', 279 ARMMARGIN length = 8 280 format = 12.5 281 informat = 12.5 282 label = 'ARMMARGIN', 283 ARMNEWPI length = 8 284 format = 12.5 285 informat = 12.5 286 label = 'ARMNEWPI', 287 ARMORGIR length = 8 288 format = 12.5 289 informat = 12.5 290 label = 'ARMORGIR', 291 ARMORGPI length = 8 292 format = 12.5 293 informat = 12.5 294 label = 'ARMORGPI', 295 ARMPICHGDT length = 10 296 format = $10. 297 informat = $10. 298 label = 'ARMPICHGDT', 299 ARMPICHGPD length = 3 300 format = $3. 301 informat = $3. 302 label = 'ARMPICHGPD', 303 ARMPLANID length = 4 304 format = $4. 305 informat = $4. 306 label = 'ARMPLANID', 307 ASSDATE length = 10 308 format = $10. 309 informat = $10. 310 label = 'ASSDATE', 311 AVGDAILYESC length = 8 312 format = 24.5 313 informat = 24.5 314 label = 'AVGDAILYESC', 315 BALOONUSER length = 1 316 format = $1. 317 informat = $1. 8 The SAS System 18:05 Friday, April 8, 2016 318 label = 'BALOONUSER', 319 BANK length = 3 320 format = $3. 321 informat = $3. 322 label = 'BANK', 323 BANK2 length = 3 324 format = $3. 325 informat = $3. 326 label = 'BANK2', 327 BANKACCT length = 17 328 format = $17. 329 informat = $17. 330 label = 'BANKACCT', 331 BANKRUPTCD length = 2 332 format = $2. 333 informat = $2. 334 label = 'BANKRUPTCD', 335 BANKTRANS length = 9 336 format = $9. 337 informat = $9. 338 label = 'BANKTRANS', 339 BILLADDR1 length = 30 340 format = $30. 341 informat = $30. 342 label = 'BILLADDR1', 343 BILLADDR2 length = 30 344 format = $30. 345 informat = $30. 346 label = 'BILLADDR2', 347 BILLADDR3 length = 30 348 format = $30. 349 informat = $30. 350 label = 'BILLADDR3', 351 BILLADDR4 length = 30 352 format = $30. 353 informat = $30. 354 label = 'BILLADDR4', 355 BILLCITY length = 21 356 format = $21. 357 informat = $21. 358 label = 'BILLCITY', 359 BILLMODE length = 1 360 format = $1. 361 informat = $1. 362 label = 'BILLMODE', 363 BILLNAME length = 30 364 format = $30. 365 informat = $30. 366 label = 'BILLNAME', 367 BILLSTATE length = 2 368 format = $2. 369 informat = $2. 370 label = 'BILLSTATE', 371 BL_ACT_DT length = 10 372 format = $10. 373 informat = $10. 374 label = 'BL_ACT_DT', 375 BL_TMPID length = 7 9 The SAS System 18:05 Friday, April 8, 2016 376 format = $7. 377 informat = $7. 378 label = 'BL_TMPID', 379 BNKRPTDATE length = 10 380 format = $10. 381 informat = $10. 382 label = 'BNKRPTDATE', 383 BRHOFFCODE length = 4 384 format = $4. 385 informat = $4. 386 label = 'BRHOFFCODE', 387 CHARGE_OFF_DATE length = 8 388 format = $8. 389 informat = $8. 390 label = 'CHARGE_OFF_DATE', 391 CHGOFFAMT length = 35 392 format = $35. 393 informat = $35. 394 label = 'CHGOFFAMT', 395 CHGOFFBAL length = 8 396 format = 13.2 397 informat = 13.2 398 label = 'CHGOFFBAL', 399 CHGOFFDTE length = 8 400 format = $8. 401 informat = $8. 402 label = 'CHGOFFDTE', 403 CITYCODE length = 4 404 format = $4. 405 informat = $4. 406 label = 'CITYCODE', 407 CITYTAX length = 8 408 format = 24.5 409 informat = 24.5 410 label = 'CITYTAX', 411 CO_AGE length = 5 412 format = $5. 413 informat = $5. 414 label = 'CO_AGE', 415 CO_RACE length = 1 416 format = $1. 417 informat = $1. 418 label = 'CO_RACE', 419 CO_SEX length = 1 420 format = $1. 421 informat = $1. 422 label = 'CO_SEX', 423 COMTGRLFM length = 30 424 format = $30. 425 informat = $30. 426 label = 'COMTGRLFM', 427 COMTGRSSN length = 9 428 format = $9. 429 informat = $9. 430 label = 'COMTGRSSN', 431 CORPADBAL3 length = 8 432 format = 24.5 433 informat = 24.5 10 The SAS System 18:05 Friday, April 8, 2016 434 label = 'CORPADBAL3', 435 COUNTYCODE length = 3 436 format = $3. 437 informat = $3. 438 label = 'COUNTYCODE', 439 COUNTYTAX length = 8 440 format = 24.5 441 informat = 24.5 442 label = 'COUNTYTAX', 443 COUPONMO length = 2 444 format = $2. 445 informat = $2. 446 label = 'COUPONMO', 447 CPNREQDATE length = 10 448 format = $10. 449 informat = $10. 450 label = 'CPNREQDATE', 451 CS_BORCBSTATCDE length = 2 452 format = $2. 453 informat = $2. 454 label = 'CS_BORCBSTATCDE', 455 DAILYRATEFACTOR length = 1 456 format = $1. 457 informat = $1. 458 label = 'DAILYRATEFACTOR', 459 DELINQPMTBAL length = 8 460 format = 13.2 461 informat = 13.2 462 label = 'DELINQPMTBAL', 463 DELQTABLE length = 2 464 format = $2. 465 informat = $2. 466 label = 'DELQTABLE', 467 DISBSTOP length = 1 468 format = $1. 469 informat = $1. 470 label = 'DISBSTOP', 471 DISTTYPE length = 1 472 format = $1. 473 informat = $1. 474 label = 'DISTTYPE', 475 DLQCLASSCD length = 2 476 format = $2. 477 informat = $2. 478 label = 'DLQCLASSCD', 479 DNTANZDATE length = 10 480 format = $10. 481 informat = $10. 482 label = 'DNTANZDATE', 483 DOCMINBAL length = 5 484 format = $5. 485 informat = $5. 486 label = 'DOCMINBAL', 487 DONTANAL length = 1 488 format = $1. 489 informat = $1. 490 label = 'DONTANAL', 491 DRAFT_INDICATOR length = 2 11 The SAS System 18:05 Friday, April 8, 2016 492 format = $2. 493 informat = $2. 494 label = 'DRAFT_INDICATOR', 495 DTNONACCSTART length = 8 496 format = $8. 497 informat = $8. 498 label = 'DTNONACCSTART', 499 DUEDATE length = 10 500 format = $10. 501 informat = $10. 502 label = 'DUEDATE', 503 DWDATE length = 8 504 format = $8. 505 informat = $8. 506 label = 'DWDATE', 507 DWDATE_Int length = 8 508 format = 11. 509 informat = 11. 510 label = 'DWDATE_Int', 511 EMPLCODE length = 1 512 format = $1. 513 informat = $1. 514 label = 'EMPLCODE', 515 ESCADVBAL length = 8 516 format = 24.5 517 informat = 24.5 518 label = 'ESCADVBAL', 519 ESCDOCTYPE length = 2 520 format = $2. 521 informat = $2. 522 label = 'ESCDOCTYPE', 523 ESCROWBAL length = 8 524 format = 24.5 525 informat = 24.5 526 label = 'ESCROWBAL', 527 ESCROWMTH length = 8 528 format = 24.5 529 informat = 24.5 530 label = 'ESCROWMTH', 531 FHANUMBER length = 13 532 format = $13. 533 informat = $13. 534 label = 'FHANUMBER', 535 FHLBBPURPR length = 8 536 format = 24.5 537 informat = 24.5 538 label = 'FHLBBPURPR', 539 FIRSTPI length = 8 540 format = 24.5 541 informat = 24.5 542 label = 'FIRSTPI', 543 FIRSTPRINB length = 8 544 format = 24.5 545 informat = 24.5 546 label = 'FIRSTPRINB', 547 FIRSTTELE length = 10 548 format = $10. 549 informat = $10. 12 The SAS System 18:05 Friday, April 8, 2016 550 label = 'FIRSTTELE', 551 FLDCERTNO length = 14 552 format = $14. 553 informat = $14. 554 label = 'FLDCERTNO', 555 FLOODZONE length = 3 556 format = $3. 557 informat = $3. 558 label = 'FLOODZONE', 559 FORCLSDATE length = 10 560 format = $10. 561 informat = $10. 562 label = 'FORCLSDATE', 563 FORECLSTOP length = 1 564 format = $1. 565 informat = $1. 566 label = 'FORECLSTOP', 567 FRSTPAYDATE length = 10 568 format = $10. 569 informat = $10. 570 label = 'FRSTPAYDATE', 571 FSTORGCOST length = 8 572 format = 24.5 573 informat = 24.5 574 label = 'FSTORGCOST', 575 FSTORIGFEE length = 8 576 format = 24.5 577 informat = 24.5 578 label = 'FSTORIGFEE', 579 FSTUNFAMRTF length = 8 580 format = 24.5 581 informat = 24.5 582 label = 'FSTUNFAMRTF', 583 FSTYIELD length = 8 584 format = 24.5 585 informat = 24.5 586 label = 'FSTYIELD', 587 GFABUYUPDN length = 8 588 format = 24.5 589 informat = 24.5 590 label = 'GFABUYUPDN', 591 GRACEDAYS length = 5 592 format = $5. 593 informat = $5. 594 label = 'GRACEDAYS', 595 HAZPREM length = 8 596 format = 24.5 597 informat = 24.5 598 label = 'HAZPREM', 599 HIGHPRICELOAN length = 1 600 format = $1. 601 informat = $1. 602 label = 'HIGHPRICELOAN', 603 HUDPARTBAL length = 8 604 format = 24.5 605 informat = 24.5 606 label = 'HUDPARTBAL', 607 HUDPARTPMT length = 8 13 The SAS System 18:05 Friday, April 8, 2016 608 format = 24.5 609 informat = 24.5 610 label = 'HUDPARTPMT', 611 INEXSTMTDT length = 10 612 format = $10. 613 informat = $10. 614 label = 'INEXSTMTDT', 615 INITSTMTCD length = 1 616 format = $1. 617 informat = $1. 618 label = 'INITSTMTCD', 619 INSPSVCCOD length = 6 620 format = $6. 621 informat = $6. 622 label = 'INSPSVCCOD', 623 INT_ONLY_EXPDT length = 10 624 format = $10. 625 informat = $10. 626 label = 'INT_ONLY_EXPDT', 627 INT_ONLY_IND length = 1 628 format = $1. 629 informat = $1. 630 label = 'INT_ONLY_IND', 631 INTCALCOPTCDE length = 1 632 format = $1. 633 informat = $1. 634 label = 'INTCALCOPTCDE', 635 INTCOLLECTED length = 8 636 format = 13.2 637 informat = 13.2 638 label = 'INTCOLLECTED', 639 INTDUE length = 8 640 format = 24.5 641 informat = 24.5 642 label = 'INTDUE', 643 INTERESTYTD length = 8 644 format = 24.5 645 informat = 24.5 646 label = 'INTERESTYTD', 647 INTONESCIN length = 1 648 format = $1. 649 informat = $1. 650 label = 'INTONESCIN', 651 INTREFIIND length = 2 652 format = $2. 653 informat = $2. 654 label = 'INTREFIIND', 655 INVESTLOAN length = 10 656 format = $10. 657 informat = $10. 658 label = 'INVESTLOAN', 659 INVREQMARG length = 8 660 format = 24.5 661 informat = 24.5 662 label = 'INVREQMARG', 663 IOECREDIT length = 8 664 format = 24.5 665 informat = 24.5 14 The SAS System 18:05 Friday, April 8, 2016 666 label = 'IOECREDIT', 667 IOERESCRED length = 8 668 format = 24.5 669 informat = 24.5 670 label = 'IOERESCRED', 671 LASTANAL length = 10 672 format = $10. 673 informat = $10. 674 label = 'LASTANAL', 675 LASTLATEMO length = 10 676 format = $10. 677 informat = $10. 678 label = 'LASTLATEMO', 679 LASTLATEYR length = 10 680 format = $10. 681 informat = $10. 682 label = 'LASTLATEYR', 683 LASTPMNT length = 10 684 format = $10. 685 informat = $10. 686 label = 'LASTPMNT', 687 LATECHRGSMTD length = 8 688 format = 11.2 689 informat = 11.2 690 label = 'LATECHRGSMTD', 691 LC_YTD length = 8 692 format = 24.5 693 informat = 24.5 694 label = 'LC_YTD', 695 LCSTPEXPDT length = 10 696 format = $10. 697 informat = $10. 698 label = 'LCSTPEXPDT', 699 LIEN length = 8 700 format = 24.5 701 informat = 24.5 702 label = 'LIEN', 703 LIFEFLAG length = 1 704 format = $1. 705 informat = $1. 706 label = 'LIFEFLAG', 707 LIFEPREM length = 5 708 format = $5. 709 informat = $5. 710 label = 'LIFEPREM', 711 LNSERVSOLD length = 10 712 format = $10. 713 informat = $10. 714 label = 'LNSERVSOLD', 715 LOAN_MOD_DT length = 10 716 format = $10. 717 informat = $10. 718 label = 'LOAN_MOD_DT', 719 LOANDATE length = 10 720 format = $10. 721 informat = $10. 722 label = 'LOANDATE', 723 LOANNO length = 10 15 The SAS System 18:05 Friday, April 8, 2016 724 format = $10. 725 informat = $10. 726 label = 'LOANNO', 727 LOANPURPOS length = 1 728 format = $1. 729 informat = $1. 730 label = 'LOANPURPOS', 731 LOANTERM length = 5 732 format = $5. 733 informat = $5. 734 label = 'LOANTERM', 735 LOANTYPE length = 2 736 format = $2. 737 informat = $2. 738 label = 'LOANTYPE', 739 LOT length = 6 740 format = $6. 741 informat = $6. 742 label = 'LOT', 743 LTECHGCODE length = 1 744 format = $1. 745 informat = $1. 746 label = 'LTECHGCODE', 747 LTECHGFCTR length = 8 748 format = 12.5 749 informat = 12.5 750 label = 'LTECHGFCTR', 751 LTECHGSTOP length = 1 752 format = $1. 753 informat = $1. 754 label = 'LTECHGSTOP', 755 MANCODE length = 1 756 format = $1. 757 informat = $1. 758 label = 'MANCODE', 759 MATDATE length = 10 760 format = $10. 761 informat = $10. 762 label = 'MATDATE', 763 Max_Date length = 8 764 format = 11. 765 informat = 11., 766 MERSID length = 18 767 format = $18. 768 informat = $18. 769 label = 'MERSID', 770 MIP length = 8 771 format = 24.5 772 informat = 24.5 773 label = 'MIP', 774 MIPUFPREM length = 8 775 format = 24.5 776 informat = 24.5 777 label = 'MIPUFPREM', 778 MISCAMT length = 8 779 format = 24.5 780 informat = 24.5 781 label = 'MISCAMT', 16 The SAS System 18:05 Friday, April 8, 2016 782 MTG_INS_PAYEE length = 10 783 format = $10. 784 informat = $10. 785 label = 'MTG_INS_PAYEE', 786 MTGRFMTLFM length = 30 787 format = $30. 788 informat = $30. 789 label = 'MTGRFMTLFM', 790 MTGRSSNO length = 9 791 format = $9. 792 informat = $9. 793 label = 'MTGRSSNO', 794 NEXTPAYNUM length = 3 795 format = $3. 796 informat = $3. 797 label = 'NEXTPAYNUM', 798 NONCONFORM length = 1 799 format = $1. 800 informat = $1. 801 label = 'NONCONFORM', 802 NONOTEXPDT length = 10 803 format = $10. 804 informat = $10. 805 label = 'NONOTEXPDT', 806 NONOTICES length = 1 807 format = $1. 808 informat = $1. 809 label = 'NONOTICES', 810 NONRECCORP length = 8 811 format = 24.5 812 informat = 24.5 813 label = 'NONRECCORP', 814 NOTEDATE length = 10 815 format = $10. 816 informat = $10. 817 label = 'NOTEDATE', 818 NSF_YTD length = 8 819 format = 24.5 820 informat = 24.5 821 label = 'NSF_YTD', 822 NUMOFUNITS length = 1 823 format = $1. 824 informat = $1. 825 label = 'NUMOFUNITS', 826 O_S_SPREAD length = 8 827 format = 24.5 828 informat = 24.5 829 label = 'O_S_SPREAD', 830 OCCUPYCOD length = 1 831 format = $1. 832 informat = $1. 833 label = 'OCCUPYCOD', 834 OFFICER_CODE_1 length = 5 835 format = $5. 836 informat = $5. 837 label = 'OFFICER_CODE_1', 838 OFFICER_CODE_2 length = 6 839 format = $6. 17 The SAS System 18:05 Friday, April 8, 2016 840 informat = $6. 841 label = 'OFFICER_CODE_2', 842 OG_LOANNO length = 15 843 format = $15. 844 informat = $15. 845 label = 'OG_LOANNO', 846 OLDLOANNO length = 16 847 format = $16. 848 informat = $16. 849 label = 'OLDLOANNO', 850 ORGCODE length = 4 851 format = $4. 852 informat = $4. 853 label = 'ORGCODE', 854 ORGPROPVAL length = 8 855 format = 24.5 856 informat = 24.5 857 label = 'ORGPROPVAL', 858 ORIGLNNUM length = 10 859 format = $10. 860 informat = $10. 861 label = 'ORIGLNNUM', 862 ORIGLNOFFCR length = 6 863 format = $6. 864 informat = $6. 865 label = 'ORIGLNOFFCR', 866 ORIGLTERM length = 3 867 format = $3. 868 informat = $3. 869 label = 'ORIGLTERM', 870 ORIGMTGAMT length = 8 871 format = 24.5 872 informat = 24.5 873 label = 'ORIGMTGAMT', 874 OSCHGDATE length = 10 875 format = $10. 876 informat = $10. 877 label = 'OSCHGDATE', 878 OTHRFEESMTD length = 8 879 format = 11.2 880 informat = 11.2 881 label = 'OTHRFEESMTD', 882 OTHRFEEYTD length = 8 883 format = 24.5 884 informat = 24.5 885 label = 'OTHRFEEYTD', 886 PAYMNTPERD length = 5 887 format = $5. 888 informat = $5. 889 label = 'PAYMNTPERD', 890 PIFDATE length = 10 891 format = $10. 892 informat = $10. 893 label = 'PIFDATE', 894 PIFSTOP length = 1 895 format = $1. 896 informat = $1. 897 label = 'PIFSTOP', 18 The SAS System 18:05 Friday, April 8, 2016 898 PLEDGECODE length = 1 899 format = $1. 900 informat = $1. 901 label = 'PLEDGECODE', 902 PMIRATE length = 8 903 format = 12.5 904 informat = 12.5 905 label = 'PMIRATE', 906 PNTSRPTYR length = 5 907 format = $5. 908 informat = $5. 909 label = 'PNTSRPTYR', 910 POINTSPAID length = 11 911 format = $11. 912 informat = $11. 913 label = 'POINTSPAID', 914 POOLCONTRA length = 15 915 format = $15. 916 informat = $15. 917 label = 'POOLCONTRA', 918 POOLPAYEE length = 10 919 format = $10. 920 informat = $10. 921 label = 'POOLPAYEE', 922 POOLPOLICYNO length = 10 923 format = $10. 924 informat = $10. 925 label = 'POOLPOLICYNO', 926 PREPAYPNLT length = 1 927 format = $1. 928 informat = $1. 929 label = 'PREPAYPNLT', 930 PRINBAL2 length = 8 931 format = 24.10 932 informat = 24.10 933 label = 'PRINBAL2', 934 PROCSTEXDT length = 10 935 format = $10. 936 informat = $10. 937 label = 'PROCSTEXDT', 938 PROCSTOP length = 1 939 format = $1. 940 informat = $1. 941 label = 'PROCSTOP', 942 PRODLINECD length = 3 943 format = $3. 944 informat = $3. 945 label = 'PRODLINECD', 946 PRODUCT_CODE length = 3 947 format = $3. 948 informat = $3. 949 label = 'PRODUCT_CODE', 950 PROPERTYCITY length = 21 951 format = $21. 952 informat = $21. 953 label = 'PROPERTYCITY', 954 PROPERTYSTREET length = 28 955 format = $28. 19 The SAS System 18:05 Friday, April 8, 2016 956 informat = $28. 957 label = 'PROPERTYSTREET', 958 PROPERTYVA length = 8 959 format = 24.5 960 informat = 24.5 961 label = 'PROPERTYVA', 962 PROPRTYYP length = 1 963 format = $1. 964 informat = $1. 965 label = 'PROPRTYYP', 966 PROPSTATE length = 2 967 format = $2. 968 informat = $2. 969 label = 'PROPSTATE', 970 PROPZIP length = 5 971 format = $5. 972 informat = $5. 973 label = 'PROPZIP', 974 RACE length = 1 975 format = $1. 976 informat = $1. 977 label = 'RACE', 978 RECCORPADV length = 8 979 format = 24.5 980 informat = 24.5 981 label = 'RECCORPADV', 982 RESERVEESC length = 8 983 format = 24.5 984 informat = 24.5 985 label = 'RESERVEESC', 986 RQ_REPURCH_DT length = 10 987 format = $10. 988 informat = $10. 989 label = 'RQ_REPURCH_DT', 990 SALEID length = 10 991 format = $10. 992 informat = $10. 993 label = 'SALEID', 994 SECTELEPHO length = 10 995 format = $10. 996 informat = $10. 997 label = 'SECTELEPHO', 998 SECTION length = 12 999 format = $12. 1000 informat = $12. 1001 label = 'SECTION', 1002 SERVICEFEE length = 8 1003 format = 24.5 1004 informat = 24.5 1005 label = 'SERVICEFEE', 1006 SETUPDATE length = 10 1007 format = $10. 1008 informat = $10. 1009 label = 'SETUPDATE', 1010 SEX length = 1 1011 format = $1. 1012 informat = $1. 1013 label = 'SEX', 20 The SAS System 18:05 Friday, April 8, 2016 1014 SSNCTFDATE length = 10 1015 format = $10. 1016 informat = $10. 1017 label = 'SSNCTFDATE', 1018 SSNCTFYCDE length = 1 1019 format = $1. 1020 informat = $1. 1021 label = 'SSNCTFYCDE', 1022 SSNVERIFY length = 1 1023 format = $1. 1024 informat = $1. 1025 label = 'SSNVERIFY', 1026 STATE length = 2 1027 format = $2. 1028 informat = $2. 1029 label = 'STATE', 1030 SUBPRODUCTCODE length = 5 1031 format = $5. 1032 informat = $5. 1033 label = 'SUBPRODUCTCODE', 1034 SUSPBAL length = 8 1035 format = 24.5 1036 informat = 24.5 1037 label = 'SUSPBAL', 1038 TAXNAME length = 21 1039 format = $21. 1040 informat = $21. 1041 label = 'TAXNAME', 1042 TAXSERCODE length = 1 1043 format = $1. 1044 informat = $1. 1045 label = 'TAXSERCODE', 1046 TAXSERDATE length = 10 1047 format = $10. 1048 informat = $10. 1049 label = 'TAXSERDATE', 1050 TAXSERFEE length = 8 1051 format = 24.5 1052 informat = 24.5 1053 label = 'TAXSERFEE', 1054 TAXSERTYPE length = 1 1055 format = $1. 1056 informat = $1. 1057 label = 'TAXSERTYPE', 1058 TAXSERVNUM length = 15 1059 format = $15. 1060 informat = $15. 1061 label = 'TAXSERVNUM', 1062 TOTPAYMENT length = 8 1063 format = 24.5 1064 informat = 24.5 1065 label = 'TOTPAYMENT', 1066 TRBLDBTRESTRUCTIND length = 1 1067 format = $1. 1068 informat = $1. 1069 label = 'TRBLDBTRESTRUCTIND', 1070 ZIPCODE length = 9 1071 format = $9. 21 The SAS System 18:05 Friday, April 8, 2016 1072 informat = $9. 1073 label = 'ZIPCODE', 1074 ZONE length = 2 1075 format = $2. 1076 informat = $2. 1077 label = 'ZONE' 1078 from connection to ODBC 1079 ( 1080 select 1081 V_DMI_CIF_Daily.ABBRNAME, 1082 V_DMI_CIF_Daily.ACCLATECHG, 1083 V_DMI_CIF_Daily.ACCQDATE, 1084 V_DMI_CIF_Daily.ACQPRINBAL, 1085 V_DMI_CIF_Daily.ACRLSTATUS, 1086 V_DMI_CIF_Daily.AGE, 1087 V_DMI_CIF_Daily.AGGR, 1088 V_DMI_CIF_Daily.AGGR2, 1089 V_DMI_CIF_Daily.AHCODE, 1090 V_DMI_CIF_Daily.AHFLAG, 1091 V_DMI_CIF_Daily.AHPREMIUM, 1092 V_DMI_CIF_Daily.AMORGLTRM, 1093 V_DMI_CIF_Daily.ANNUALINT, 1094 V_DMI_CIF_Daily.ANNUALINT2, 1095 V_DMI_CIF_Daily.ARM_IDCODE_1, 1096 V_DMI_CIF_Daily.ARM_IDXLEAD_DAYS, 1097 V_DMI_CIF_Daily.ARM_IND, 1098 V_DMI_CIF_Daily.ARM_INT, 1099 V_DMI_CIF_Daily.ARM_IRRND_FCTR, 1100 V_DMI_CIF_Daily.ARM_IRRND_TYPE, 1101 V_DMI_CIF_Daily.ARM_MAXCEILING_RT, 1102 V_DMI_CIF_Daily.ARM_MAXDEC_RT, 1103 V_DMI_CIF_Daily.ARM_MAXFLOOR_RT, 1104 V_DMI_CIF_Daily.ARM_MAXINCR_RT, 1105 V_DMI_CIF_Daily.ARM_OGIRCHNG_DT, 1106 V_DMI_CIF_Daily.ARM_OGPICHNG_DT, 1107 V_DMI_CIF_Daily.ARMIRCHGDT, 1108 V_DMI_CIF_Daily.ARMIRCHGPD, 1109 V_DMI_CIF_Daily.ARMMARGIN, 1110 V_DMI_CIF_Daily.ARMNEWPI, 1111 V_DMI_CIF_Daily.ARMORGIR, 1112 V_DMI_CIF_Daily.ARMORGPI, 1113 V_DMI_CIF_Daily.ARMPICHGDT, 1114 V_DMI_CIF_Daily.ARMPICHGPD, 1115 V_DMI_CIF_Daily.ARMPLANID, 1116 V_DMI_CIF_Daily.ASSDATE, 1117 V_DMI_CIF_Daily.AVGDAILYESC, 1118 V_DMI_CIF_Daily.BALOONUSER, 1119 V_DMI_CIF_Daily.BANK, 1120 V_DMI_CIF_Daily.BANK2, 1121 V_DMI_CIF_Daily.BANKACCT, 1122 V_DMI_CIF_Daily.BANKRUPTCD, 1123 V_DMI_CIF_Daily.BANKTRANS, 1124 V_DMI_CIF_Daily.BILLADDR1, 1125 V_DMI_CIF_Daily.BILLADDR2, 1126 V_DMI_CIF_Daily.BILLADDR3, 1127 V_DMI_CIF_Daily.BILLADDR4, 1128 V_DMI_CIF_Daily.BILLCITY, 1129 V_DMI_CIF_Daily.BILLMODE, 22 The SAS System 18:05 Friday, April 8, 2016 1130 V_DMI_CIF_Daily.BILLNAME, 1131 V_DMI_CIF_Daily.BILLSTATE, 1132 V_DMI_CIF_Daily.BL_ACT_DT, 1133 V_DMI_CIF_Daily.BL_TMPID, 1134 V_DMI_CIF_Daily.BNKRPTDATE, 1135 V_DMI_CIF_Daily.BRHOFFCODE, 1136 V_DMI_CIF_Daily.CHARGE_OFF_DATE, 1137 V_DMI_CIF_Daily.CHGOFFAMT, 1138 V_DMI_CIF_Daily.CHGOFFBAL, 1139 V_DMI_CIF_Daily.CHGOFFDTE, 1140 V_DMI_CIF_Daily.CITYCODE, 1141 V_DMI_CIF_Daily.CITYTAX, 1142 V_DMI_CIF_Daily.CO_AGE, 1143 V_DMI_CIF_Daily.CO_RACE, 1144 V_DMI_CIF_Daily.CO_SEX, 1145 V_DMI_CIF_Daily.COMTGRLFM, 1146 V_DMI_CIF_Daily.COMTGRSSN, 1147 V_DMI_CIF_Daily.CORPADBAL3, 1148 V_DMI_CIF_Daily.COUNTYCODE, 1149 V_DMI_CIF_Daily.COUNTYTAX, 1150 V_DMI_CIF_Daily.COUPONMO, 1151 V_DMI_CIF_Daily.CPNREQDATE, 1152 V_DMI_CIF_Daily.CS_BORCBSTATCDE, 1153 V_DMI_CIF_Daily.DAILYRATEFACTOR, 1154 V_DMI_CIF_Daily.DELINQPMTBAL, 1155 V_DMI_CIF_Daily.DELQTABLE, 1156 V_DMI_CIF_Daily.DISBSTOP, 1157 V_DMI_CIF_Daily.DISTTYPE, 1158 V_DMI_CIF_Daily.DLQCLASSCD, 1159 V_DMI_CIF_Daily.DNTANZDATE, 1160 V_DMI_CIF_Daily.DOCMINBAL, 1161 V_DMI_CIF_Daily.DONTANAL, 1162 V_DMI_CIF_Daily.DRAFT_INDICATOR, 1163 V_DMI_CIF_Daily.DTNONACCSTART, 1164 V_DMI_CIF_Daily.DUEDATE, 1165 V_DMI_CIF_Daily.DWDATE, 1166 V_DMI_CIF_Daily.DWDATE_Int, 1167 V_DMI_CIF_Daily.EMPLCODE, 1168 V_DMI_CIF_Daily.ESCADVBAL, 1169 V_DMI_CIF_Daily.ESCDOCTYPE, 1170 V_DMI_CIF_Daily.ESCROWBAL, 1171 V_DMI_CIF_Daily.ESCROWMTH, 1172 V_DMI_CIF_Daily.FHANUMBER, 1173 V_DMI_CIF_Daily.FHLBBPURPR, 1174 V_DMI_CIF_Daily.FIRSTPI, 1175 V_DMI_CIF_Daily.FIRSTPRINB, 1176 V_DMI_CIF_Daily.FIRSTTELE, 1177 V_DMI_CIF_Daily.FLDCERTNO, 1178 V_DMI_CIF_Daily.FLOODZONE, 1179 V_DMI_CIF_Daily.FORCLSDATE, 1180 V_DMI_CIF_Daily.FORECLSTOP, 1181 V_DMI_CIF_Daily.FRSTPAYDATE, 1182 V_DMI_CIF_Daily.FSTORGCOST, 1183 V_DMI_CIF_Daily.FSTORIGFEE, 1184 V_DMI_CIF_Daily.FSTUNFAMRTF, 1185 V_DMI_CIF_Daily.FSTYIELD, 1186 V_DMI_CIF_Daily.GFABUYUPDN, 1187 V_DMI_CIF_Daily.GRACEDAYS, 23 The SAS System 18:05 Friday, April 8, 2016 1188 V_DMI_CIF_Daily.HAZPREM, 1189 V_DMI_CIF_Daily.HIGHPRICELOAN, 1190 V_DMI_CIF_Daily.HUDPARTBAL, 1191 V_DMI_CIF_Daily.HUDPARTPMT, 1192 V_DMI_CIF_Daily.INEXSTMTDT, 1193 V_DMI_CIF_Daily.INITSTMTCD, 1194 V_DMI_CIF_Daily.INSPSVCCOD, 1195 V_DMI_CIF_Daily.INT_ONLY_EXPDT, 1196 V_DMI_CIF_Daily.INT_ONLY_IND, 1197 V_DMI_CIF_Daily.INTCALCOPTCDE, 1198 V_DMI_CIF_Daily.INTCOLLECTED, 1199 V_DMI_CIF_Daily.INTDUE, 1200 V_DMI_CIF_Daily.INTERESTYTD, 1201 V_DMI_CIF_Daily.INTONESCIN, 1202 V_DMI_CIF_Daily.INTREFIIND, 1203 V_DMI_CIF_Daily.INVESTLOAN, 1204 V_DMI_CIF_Daily.INVREQMARG, 1205 V_DMI_CIF_Daily.IOECREDIT, 1206 V_DMI_CIF_Daily.IOERESCRED, 1207 V_DMI_CIF_Daily.LASTANAL, 1208 V_DMI_CIF_Daily.LASTLATEMO, 1209 V_DMI_CIF_Daily.LASTLATEYR, 1210 V_DMI_CIF_Daily.LASTPMNT, 1211 V_DMI_CIF_Daily.LATECHRGSMTD, 1212 V_DMI_CIF_Daily.LC_YTD, 1213 V_DMI_CIF_Daily.LCSTPEXPDT, 1214 V_DMI_CIF_Daily.LIEN, 1215 V_DMI_CIF_Daily.LIFEFLAG, 1216 V_DMI_CIF_Daily.LIFEPREM, 1217 V_DMI_CIF_Daily.LNSERVSOLD, 1218 V_DMI_CIF_Daily.LOAN_MOD_DT, 1219 V_DMI_CIF_Daily.LOANDATE, 1220 V_DMI_CIF_Daily.LOANNO, 1221 V_DMI_CIF_Daily.LOANPURPOS, 1222 V_DMI_CIF_Daily.LOANTERM, 1223 V_DMI_CIF_Daily.LOANTYPE, 1224 V_DMI_CIF_Daily.LOT, 1225 V_DMI_CIF_Daily.LTECHGCODE, 1226 V_DMI_CIF_Daily.LTECHGFCTR, 1227 V_DMI_CIF_Daily.LTECHGSTOP, 1228 V_DMI_CIF_Daily.MANCODE, 1229 V_DMI_CIF_Daily.MATDATE, 1230 Max_Date, 1231 V_DMI_CIF_Daily.MERSID, 1232 V_DMI_CIF_Daily.MIP, 1233 V_DMI_CIF_Daily.MIPUFPREM, 1234 V_DMI_CIF_Daily.MISCAMT, 1235 V_DMI_CIF_Daily.MTG_INS_PAYEE, 1236 V_DMI_CIF_Daily.MTGRFMTLFM, 1237 V_DMI_CIF_Daily.MTGRSSNO, 1238 V_DMI_CIF_Daily.NEXTPAYNUM, 1239 V_DMI_CIF_Daily.NONCONFORM, 1240 V_DMI_CIF_Daily.NONOTEXPDT, 1241 V_DMI_CIF_Daily.NONOTICES, 1242 V_DMI_CIF_Daily.NONRECCORP, 1243 V_DMI_CIF_Daily.NOTEDATE, 1244 V_DMI_CIF_Daily.NSF_YTD, 1245 V_DMI_CIF_Daily.NUMOFUNITS, 24 The SAS System 18:05 Friday, April 8, 2016 1246 V_DMI_CIF_Daily.O_S_SPREAD, 1247 V_DMI_CIF_Daily.OCCUPYCOD, 1248 V_DMI_CIF_Daily.OFFICER_CODE_1, 1249 V_DMI_CIF_Daily.OFFICER_CODE_2, 1250 V_DMI_CIF_Daily.OG_LOANNO, 1251 V_DMI_CIF_Daily.OLDLOANNO, 1252 V_DMI_CIF_Daily.ORGCODE, 1253 V_DMI_CIF_Daily.ORGPROPVAL, 1254 V_DMI_CIF_Daily.ORIGLNNUM, 1255 V_DMI_CIF_Daily.ORIGLNOFFCR, 1256 V_DMI_CIF_Daily.ORIGLTERM, 1257 V_DMI_CIF_Daily.ORIGMTGAMT, 1258 V_DMI_CIF_Daily.OSCHGDATE, 1259 V_DMI_CIF_Daily.OTHRFEESMTD, 1260 V_DMI_CIF_Daily.OTHRFEEYTD, 1261 V_DMI_CIF_Daily.PAYMNTPERD, 1262 V_DMI_CIF_Daily.PIFDATE, 1263 V_DMI_CIF_Daily.PIFSTOP, 1264 V_DMI_CIF_Daily.PLEDGECODE, 1265 V_DMI_CIF_Daily.PMIRATE, 1266 V_DMI_CIF_Daily.PNTSRPTYR, 1267 V_DMI_CIF_Daily.POINTSPAID, 1268 V_DMI_CIF_Daily.POOLCONTRA, 1269 V_DMI_CIF_Daily.POOLPAYEE, 1270 V_DMI_CIF_Daily.POOLPOLICYNO, 1271 V_DMI_CIF_Daily.PREPAYPNLT, 1272 V_DMI_CIF_Daily.PRINBAL2, 1273 V_DMI_CIF_Daily.PROCSTEXDT, 1274 V_DMI_CIF_Daily.PROCSTOP, 1275 V_DMI_CIF_Daily.PRODLINECD, 1276 V_DMI_CIF_Daily.PRODUCT_CODE, 1277 V_DMI_CIF_Daily.PROPERTYCITY, 1278 V_DMI_CIF_Daily.PROPERTYSTREET, 1279 V_DMI_CIF_Daily.PROPERTYVA, 1280 V_DMI_CIF_Daily.PROPRTYYP, 1281 V_DMI_CIF_Daily.PROPSTATE, 1282 V_DMI_CIF_Daily.PROPZIP, 1283 V_DMI_CIF_Daily.RACE, 1284 V_DMI_CIF_Daily.RECCORPADV, 1285 V_DMI_CIF_Daily.RESERVEESC, 1286 V_DMI_CIF_Daily.RQ_REPURCH_DT, 1287 V_DMI_CIF_Daily.SALEID, 1288 V_DMI_CIF_Daily.SECTELEPHO, 1289 V_DMI_CIF_Daily.SECTION, 1290 V_DMI_CIF_Daily.SERVICEFEE, 1291 V_DMI_CIF_Daily.SETUPDATE, 1292 V_DMI_CIF_Daily.SEX, 1293 V_DMI_CIF_Daily.SSNCTFDATE, 1294 V_DMI_CIF_Daily.SSNCTFYCDE, 1295 V_DMI_CIF_Daily.SSNVERIFY, 1296 V_DMI_CIF_Daily.STATE, 1297 V_DMI_CIF_Daily.SUBPRODUCTCODE, 1298 V_DMI_CIF_Daily.SUSPBAL, 1299 V_DMI_CIF_Daily.TAXNAME, 1300 V_DMI_CIF_Daily.TAXSERCODE, 1301 V_DMI_CIF_Daily.TAXSERDATE, 1302 V_DMI_CIF_Daily.TAXSERFEE, 1303 V_DMI_CIF_Daily.TAXSERTYPE, 25 The SAS System 18:05 Friday, April 8, 2016 1304 V_DMI_CIF_Daily.TAXSERVNUM, 1305 V_DMI_CIF_Daily.TOTPAYMENT, 1306 V_DMI_CIF_Daily.TRBLDBTRESTRUCTIND, 1307 V_DMI_CIF_Daily.ZIPCODE, 1308 V_DMI_CIF_Daily.ZONE 1309 from 1310 bnkDbDataGov.V_DMI_CIF_Daily as V_DMI_CIF_Daily, 1311 ( 1312 select 1313 MAX(V_DMI_CIF_Daily_sub.DWDATE_Int ) as Max_Date 1314 from 1315 bnkDbDataGov.V_DMI_CIF_Daily as V_DMI_CIF_Daily_sub 1316 ) 1317 where 1318 V_DMI_CIF_Daily.DWDATE_Int = Max_Date 1319 1320 ); ERROR: CLI describe error: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Incorrect syntax near the keyword 'where'. : [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Statement(s) could not be prepared. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 1321 1322 %rcSet(&sqlrc); 1323 1324 disconnect from ODBC; NOTE: Statement not executed due to NOEXEC option. 1325 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE| _DISARM| STOP| _DISARM| 2016-04-08T18:06:33,331-05:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | _DISARM| 12185600| _DISARM| 11165696| _DISARM| 11| _DISARM| 11| _DISARM| 360| _DISARM| 936| _DISARM| 0.440000| _DISARM| 0.358862| _DISARM| 1775775992.972818| _DISARM| 1775775993.331680| _DISARM| 0.260000| _DISARM| | _ENDDISARM NOTE: PROCEDURE SQL used (Total process time): real time 0.35 seconds cpu time 0.44 seconds 1326 1327 %global etls_sql_pushDown; 1328 %let etls_sql_pushDown = &sys_sql_ip_all; 1329 1330 %rcSet(&sqlrc); 1331 1332 %perfstop(metrVal6=%sysfunc(max(&etls_recnt,-1))); MPRINT(PERFSTOP): options notes nosource nosource2 nosymbolgen nomprint nomlogic NOTE: _DISARM|A5PHO1MX.BZ0000H3|lx246|SQLJoin| _DISARM| STOP| _DISARM| 2016-04-08T18:06:33,338-05:00| _DISARM| SAS_Data_Integration_Studio| _DISARM| SAS| _DISARM| 38711324| _DISARM| 12185600| _DISARM| 11427840| _DISARM| 11| _DISARM| 11| _DISARM| 376| _DISARM| 936| _DISARM| 0.470000| _DISARM| 0.394636| _DISARM| 1775775992.944203| _DISARM| 1775775993.338839| _DISARM| 0.290000| _DISARM| | _ENDDISARM MPRINT(PERFSTOP): NOSYMBOLGEN ; MPRINT(PERFSTOP): ; MPRINT(PERFSTOP): ; 1333 %let etls_recnt=-1; 1334 1335 1336 1337 /** Step end Join **/ 1338 1339