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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.