BookmarkSubscribeRSS Feed
saspert
Pyrite | Level 9

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

1 REPLY 1
LinusH
Tourmaline | Level 20
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

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 799 views
  • 1 like
  • 2 in conversation