SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

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

Reply
Super Contributor
Posts: 268

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

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

     

NOTE: PROCEDURE| _DISARM|         STOP| _DISARM| 2016-06-30T10:49:10,537-04:00| _DISARM| WorkspaceSe

rver| _DISARM| SAS| _DISARM| |

      _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

Super User
Posts: 5,260

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

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.
Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 180 views
  • 1 like
  • 2 in conversation