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
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.
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.