Hi SAS Community!
Need your advise on this stored process changes I'm making. So, I am now trying to extract and merge the source of a list on my stored process and I used "union" for doing so. Now we noticed that when running the stored process, the list from LIB2.MASTER do not reflect but when we run the code manually (in a new program in SAS EG), it reflects successfully.
proc sql; create table WORKSD7.EG_RCL_INST_X_FI_LIST_temp as select distinct case when XXXXXX in (0, 5) then 'Commercial Bank' when XXXXXX in (1, 2, 3, 7) then 'Thrift Bank' when XXXXXX in (4, 😎 then 'Rural Bank' when XXXXXX = 57 then 'Corporation' else 'Non-Bank Bank' end as INDNAME length=35, INST as FINST, (XXXXXX * 10000) + ENTITY as BKCODE from LIB1.INST union select distinct case when XXXXXX = 31 then 'Pawnshop' when XXXXXX = 60 then 'Money Service Businesses' else 'Non-Bank Bank' end as INDNAME length=35, FCONAME as FINST, (XXXXXX * 100000) + ENTITY as BKCODE from LIB2.MASTER; quit;
I noticed the difference between LIB1 and LIB2's DB connection. LIB1 is from AS400 and LIB2 is DB2. Now my question is, is the connection correct or is there a specific connection for DB2?
LIBNAME LIB1 DB2 Datasrc=XXXSYS2 SCHEMA=LIB1 USER=dwadmn PASSWORD="XXXXXXXXXXX" ; LIBNAME LIB2 DB2 UTILCONN_TRANSIENT=YES Datasrc=XXXSYS2 SCHEMA=LIB2 AUTHDOMAIN="DB2Auth" ;
Really appreciate your answer. Thank you!
... View more