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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.