sas di studio 4.2 table loader completes successfully but end table has no data

saspert — Thu, 30 Jun 2016 15:26:04 GMT

Hi,

I have a SAS DI studio (v4.21) job running on MS SQL server 2012 R2 environment. The macro etl_loader seems to be running fine but I do not see any data in the end table (Oracle).

MPRINT(ETLS_LOADER): ;

NOTE: Appending data ...

MPRINT(ETLS_LOADER): proc append base = myclient.mytable data = WORK.W6QNWWZK () force

;

MPRINT(ETLS_LOADER): run;

9 The SAS System

10:49 Thursday, June 30, 2016

NOTE: Appending WORK.W6QNWWZK to myclient.mytable.

NOTE: There were 3287 observations read from the data set WORK.W6QNWWZK.

NOTE: 3287 observations added.

NOTE: The data set myclient.mytable has . observations and 6 variables.

NOTE: PROCEDURE APPEND used (Total process time):

real time 0.35 seconds

cpu time 0.11 seconds

_DISARM| 2749664| _DISARM| 7639040| _DISARM| 10| _DISARM| 10| _DISARM| 8368510| _DISARM| 10774

867| _DISARM| 0.109201|

_DISARM| 0.359000| _DISARM| 1782917350.178000| _DISARM| 1782917350.537000| _DISARM| 0.046801|

_DISARM| | _ENDDISARM

MPRINT(ETLS_LOADER): ;

thanks,

saspert

Re: sas di studio 4.2 table loader completes successfully but end table has no data

LinusH — Fri, 01 Jul 2016 08:14:35 GMT

The no of records in an external RDBMS table is not available to SAS (or Oracle users as well I think, unless table statistics are being instantly updated), so it's just normal.

topic sas di studio 4.2 table loader completes successfully but end table has no data in SAS Data Management

sas di studio 4.2 table loader completes successfully but end table has no data

Re: sas di studio 4.2 table loader completes successfully but end table has no data