1 The SAS System 13:59 Wednesday, May 17, 2023 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='Program'; 4 %LET _CLIENTPROCESSFLOWNAME='Process Flow'; 5 %LET _CLIENTPROJECTPATH='C:\Users\Administrator\Desktop\KPMG\AP\User_Bulk_Load3.egp'; 6 %LET _CLIENTPROJECTPATHHOST='AMLAPPUAT'; 7 %LET _CLIENTPROJECTNAME='User_Bulk_Load3.egp'; 8 %LET _SASPROGRAMFILE=''; 9 %LET _SASPROGRAMFILEHOST=''; 10 11 ODS _ALL_ CLOSE; 12 OPTIONS DEV=PNG; 13 FILENAME EGSR TEMP; 14 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR 15 STYLE=HTMLBlue 16 STYLESHEET=(URL="file:///E:/SASInst/SASEnterpriseGuide/7.1/Styles/HTMLBlue.css") 17 NOGTITLE 18 NOGFOOTNOTE 19 GPATH=&sasworklocation SYMBOLGEN: Macro variable SASWORKLOCATION resolves to "E:\SAS_TEMP\_TD20704_AMLAPPUAT_\Prc2/" 20 ENCODING=UTF8 21 options(rolap="on") 22 ; NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR 23 24 25 options mlogic mprint symbolgen; 26 %mduchglb(change=update); MLOGIC(MDUCHGLB): Beginning execution. MLOGIC(MDUCHGLB): Parameter CHANGE has value update MLOGIC(MDUCHGLB): Parameter TEMP has value work MLOGIC(MDUCHGLB): Parameter FAILEDOBJS has value &temp..mduchglb_failedobjs MLOGIC(MDUCHGLB): Parameter EXTIDTAG has value IdentityImport MLOGIC(MDUCHGLB): Parameter BLKSIZE has value 100 SYMBOLGEN: Macro variable CHANGE resolves to update SYMBOLGEN: Macro variable CHANGE resolves to update MLOGIC(MDUCHGLB): %IF condition NOT ( %EVAL(%sysfunc(exist(&change..person_add)) OR %sysfunc(exist(&change..person_add,VIEW))) ) is FALSE SYMBOLGEN: Macro variable CHANGE resolves to update SYMBOLGEN: Macro variable CHANGE resolves to update MLOGIC(MDUCHGLB): %IF condition NOT ( %EVAL(%sysfunc(exist(&change..person_delete)) OR %sysfunc(exist(&change..person_delete,VIEW))) ) is FALSE SYMBOLGEN: Macro variable CHANGE resolves to update SYMBOLGEN: Macro variable CHANGE resolves to update MLOGIC(MDUCHGLB): %IF condition NOT ( %EVAL(%sysfunc(exist(&change..person_update)) OR %sysfunc(exist(&change..person_update,VIEW))) ) is FALSE SYMBOLGEN: Macro variable CHANGE resolves to update SYMBOLGEN: Macro variable CHANGE resolves to update MLOGIC(MDUCHGLB): %IF condition NOT ( %EVAL(%sysfunc(exist(&change..person_summary)) OR %sysfunc(exist(&change..person_summary,VIEW))) ) is FALSE SYMBOLGEN: Macro variable CHANGE resolves to update SYMBOLGEN: Macro variable CHANGE resolves to update MLOGIC(MDUCHGLB): %IF condition NOT ( %EVAL(%sysfunc(exist(&change..location_add)) OR %sysfunc(exist(&change..location_add,VIEW))) ) is FALSE SYMBOLGEN: Macro variable CHANGE resolves to update SYMBOLGEN: Macro variable CHANGE resolves to update MLOGIC(MDUCHGLB): %IF condition NOT ( %EVAL(%sysfunc(exist(&change..location_delete)) OR %sysfunc(exist(&change..location_delete,VIEW))) ) is FALSE 2 The SAS System 13:59 Wednesday, May 17, 2023 SYMBOLGEN: Macro variable CHANGE resolves to update SYMBOLGEN: Macro variable CHANGE resolves to update MLOGIC(MDUCHGLB): %IF condition NOT ( %EVAL(%sysfunc(exist(&change..location_update)) OR %sysfunc(exist(&change..location_update,VIEW))) ) is FALSE SYMBOLGEN: Macro variable CHANGE resolves to update SYMBOLGEN: Macro variable CHANGE resolves to update MLOGIC(MDUCHGLB): %IF condition NOT ( %EVAL(%sysfunc(exist(&change..email_add)) OR %sysfunc(exist(&change..email_add,VIEW))) ) is FALSE SYMBOLGEN: Macro variable CHANGE resolves to update SYMBOLGEN: Macro variable CHANGE resolves to update MLOGIC(MDUCHGLB): %IF condition NOT ( %EVAL(%sysfunc(exist(&change..email_delete)) OR %sysfunc(exist(&change..email_delete,VIEW))) ) is FALSE SYMBOLGEN: Macro variable CHANGE resolves to update SYMBOLGEN: Macro variable CHANGE resolves to update MLOGIC(MDUCHGLB): %IF condition NOT ( %EVAL(%sysfunc(exist(&change..email_update)) OR %sysfunc(exist(&change..email_update,VIEW))) ) is FALSE SYMBOLGEN: Macro variable CHANGE resolves to update SYMBOLGEN: Macro variable CHANGE resolves to update MLOGIC(MDUCHGLB): %IF condition NOT ( %EVAL(%sysfunc(exist(&change..phone_add)) OR %sysfunc(exist(&change..phone_add,VIEW))) ) is FALSE SYMBOLGEN: Macro variable CHANGE resolves to update SYMBOLGEN: Macro variable CHANGE resolves to update MLOGIC(MDUCHGLB): %IF condition NOT ( %EVAL(%sysfunc(exist(&change..phone_delete)) OR %sysfunc(exist(&change..phone_delete,VIEW))) ) is FALSE SYMBOLGEN: Macro variable CHANGE resolves to update SYMBOLGEN: Macro variable CHANGE resolves to update MLOGIC(MDUCHGLB): %IF condition NOT ( %EVAL(%sysfunc(exist(&change..phone_update)) OR %sysfunc(exist(&change..phone_update,VIEW))) ) is FALSE SYMBOLGEN: Macro variable CHANGE resolves to update SYMBOLGEN: Macro variable CHANGE resolves to update MLOGIC(MDUCHGLB): %IF condition NOT ( %EVAL(%sysfunc(exist(&change..logins_add)) OR %sysfunc(exist(&change..logins_add,VIEW))) ) is FALSE SYMBOLGEN: Macro variable CHANGE resolves to update SYMBOLGEN: Macro variable CHANGE resolves to update MLOGIC(MDUCHGLB): %IF condition NOT ( %EVAL(%sysfunc(exist(&change..logins_delete)) OR %sysfunc(exist(&change..logins_delete,VIEW))) ) is FALSE SYMBOLGEN: Macro variable CHANGE resolves to update SYMBOLGEN: Macro variable CHANGE resolves to update MLOGIC(MDUCHGLB): %IF condition NOT ( %EVAL(%sysfunc(exist(&change..authdomain_add)) OR %sysfunc(exist(&change..authdomain_add,VIEW))) ) is FALSE SYMBOLGEN: Macro variable CHANGE resolves to update SYMBOLGEN: Macro variable CHANGE resolves to update MLOGIC(MDUCHGLB): %IF condition NOT ( %EVAL(%sysfunc(exist(&change..authdomain_delete)) OR %sysfunc(exist(&change..authdomain_delete,VIEW))) ) is FALSE SYMBOLGEN: Macro variable CHANGE resolves to update SYMBOLGEN: Macro variable CHANGE resolves to update MLOGIC(MDUCHGLB): %IF condition NOT ( %EVAL(%sysfunc(exist(&change..authdomain_update)) OR %sysfunc(exist(&change..authdomain_update,VIEW))) ) is FALSE SYMBOLGEN: Macro variable CHANGE resolves to update SYMBOLGEN: Macro variable CHANGE resolves to update MLOGIC(MDUCHGLB): %IF condition NOT ( %EVAL(%sysfunc(exist(&change..authdomain_summary)) OR %sysfunc(exist(&change..authdomain_summary,VIEW))) ) is FALSE SYMBOLGEN: Macro variable CHANGE resolves to update SYMBOLGEN: Macro variable CHANGE resolves to update MLOGIC(MDUCHGLB): %IF condition NOT ( %EVAL(%sysfunc(exist(&change..idgrps_add)) OR %sysfunc(exist(&change..idgrps_add,VIEW))) ) is FALSE SYMBOLGEN: Macro variable CHANGE resolves to update SYMBOLGEN: Macro variable CHANGE resolves to update 3 The SAS System 13:59 Wednesday, May 17, 2023 MLOGIC(MDUCHGLB): %IF condition NOT ( %EVAL(%sysfunc(exist(&change..idgrps_delete)) OR %sysfunc(exist(&change..idgrps_delete,VIEW))) ) is FALSE SYMBOLGEN: Macro variable CHANGE resolves to update SYMBOLGEN: Macro variable CHANGE resolves to update MLOGIC(MDUCHGLB): %IF condition NOT ( %EVAL(%sysfunc(exist(&change..idgrps_update)) OR %sysfunc(exist(&change..idgrps_update,VIEW))) ) is FALSE SYMBOLGEN: Macro variable CHANGE resolves to update SYMBOLGEN: Macro variable CHANGE resolves to update MLOGIC(MDUCHGLB): %IF condition NOT ( %EVAL(%sysfunc(exist(&change..idgrps_summary)) OR %sysfunc(exist(&change..idgrps_summary,VIEW))) ) is FALSE SYMBOLGEN: Macro variable CHANGE resolves to update SYMBOLGEN: Macro variable CHANGE resolves to update MLOGIC(MDUCHGLB): %IF condition NOT ( %EVAL(%sysfunc(exist(&change..grpmems_add)) OR %sysfunc(exist(&change..grpmems_add,VIEW))) ) is FALSE SYMBOLGEN: Macro variable CHANGE resolves to update SYMBOLGEN: Macro variable CHANGE resolves to update MLOGIC(MDUCHGLB): %IF condition NOT ( %EVAL(%sysfunc(exist(&change..grpmems_delete)) OR %sysfunc(exist(&change..grpmems_delete,VIEW))) ) is FALSE MLOGIC(MDUCHGLB): %IF condition (%symexist(_mduchglb_timer_)) is FALSE MLOGIC(MDUCHGLB): %IF condition (%symexist(_mduchglb_outrequest_)) is FALSE MLOGIC(MDUCHGLB): %LET (variable name is OUTREQUEST) MLOGIC(MDUCHGLB): %IF condition (%symexist(_mduchglb_outresponse_)) is FALSE MLOGIC(MDUCHGLB): %LET (variable name is OUTRESPONSE) MLOGIC(MDUCHGLB): %IF condition %superq(SYSSCPL) eq zOS or %superq(SYSSCPL) eq OS390 is FALSE MLOGIC(MDUCHGLB): %LET (variable name is RECFM) MLOGIC(MDUCHGLB): %LET (variable name is SYMBNUM) MLOGIC(MDUFOBJS): Beginning execution. MLOGIC(MDUFOBJS): This macro was compiled from the autocall file E:\SASInst\SASFoundation\9.4\core\sasmacro\mdufobjs.sas SYMBOLGEN: Macro variable FAILEDOBJS resolves to &temp..mduchglb_failedobjs SYMBOLGEN: Macro variable TEMP resolves to work MLOGIC(MDUFOBJS): Parameter FAILEDOBJS has value work.mduchglb_failedobjs MPRINT(MDUFOBJS): proc sql noprint; SYMBOLGEN: Macro variable FAILEDOBJS resolves to work.mduchglb_failedobjs MPRINT(MDUFOBJS): create table work.mduchglb_failedobjs ( tablename char(64), chgtype char(1), objtype char(32), name char(60), objid char(17), keyid char(200), userid char(128), authdomkeyid char(200), memobjtype char(32), memname char(60), memobjid char(17), memkeyid char(200) ); NOTE: Table WORK.MDUCHGLB_FAILEDOBJS created, with 0 rows and 12 columns. MPRINT(MDUFOBJS): quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.01 seconds MLOGIC(MDUFOBJS): Ending execution. MPRINT(MDUCHGLB): ; MPRINT(MDUCHGLB): data _null_; MPRINT(MDUCHGLB): length id $20; MPRINT(MDUCHGLB): length type $256; MPRINT(MDUCHGLB): length attr $256; MPRINT(MDUCHGLB): length value $256; MPRINT(MDUCHGLB): length search $200; MPRINT(MDUCHGLB): rc=0; MPRINT(MDUCHGLB): id=""; MPRINT(MDUCHGLB): type=""; MPRINT(MDUCHGLB): attr=""; MPRINT(MDUCHGLB): value=""; MPRINT(MDUCHGLB): search = "omsobj:RepositoryBase?@Name='" || dequote(getoption('METAREPOSITORY')) || "'"; MPRINT(MDUCHGLB): rc=metadata_resolve(search,type,id); 4 The SAS System 13:59 Wednesday, May 17, 2023 MPRINT(MDUCHGLB): id = substr(id,10,8); MPRINT(MDUCHGLB): call symput('REPOSID',trim(id)); MPRINT(MDUCHGLB): run; NOTE: DATA statement used (Total process time): real time 0.06 seconds cpu time 0.00 seconds MPRINT(MDUCHGLB): proc sql; SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable CHANGE resolves to update SYMBOLGEN: Macro variable CHANGE resolves to update MPRINT(MDUCHGLB): create table work.authdomain_comb as select *,"A" as chgtype from update.authdomain_add union corresponding select *,"U" as chgtype from update.authdomain_update; NOTE: Table WORK.AUTHDOMAIN_COMB created, with 0 rows and 5 columns. MPRINT(MDUCHGLB): quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.01 seconds MLOGIC(MDUCHGLB): %LET (variable name is DSID) SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable DSID resolves to 1 MLOGIC(MDUCHGLB): %IF condition &dsid is TRUE MLOGIC(MDUCHGLB): %LET (variable name is N_AUTHDOMS) SYMBOLGEN: Macro variable DSID resolves to 1 MLOGIC(MDUCHGLB): %LET (variable name is RC) SYMBOLGEN: Macro variable DSID resolves to 1 SYMBOLGEN: Macro variable N_AUTHDOMS resolves to 0 MLOGIC(MDUCHGLB): %IF condition &n_authdoms GT 0 is FALSE MPRINT(MDUCHGLB): proc sql; SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable CHANGE resolves to update SYMBOLGEN: Macro variable CHANGE resolves to update MPRINT(MDUCHGLB): create view work.idgrps_comb as select *,"A " as chgtype from update.idgrps_add union select *,"U " as chgtype from update.idgrps_update; NOTE: SQL view WORK.IDGRPS_COMB has been defined. SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable CHANGE resolves to update SYMBOLGEN: Macro variable CHANGE resolves to update MPRINT(MDUCHGLB): create table work.grpmems_comb as select *,"A" as memchgtype from update.grpmems_add union corresponding select *,"D" as memchgtype from update.grpmems_delete; NOTE: Compressing data set WORK.GRPMEMS_COMB increased size by 100.00 percent. Compressed is 2 pages; un-compressed would require 1 pages. NOTE: Table WORK.GRPMEMS_COMB created, with 1 rows and 6 columns. MPRINT(MDUCHGLB): quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds SYMBOLGEN: Macro variable TEMP resolves to work MPRINT(MDUCHGLB): proc sort data=work.grpmems_comb; MPRINT(MDUCHGLB): by grpkeyid memchgtype; 5 The SAS System 13:59 Wednesday, May 17, 2023 MPRINT(MDUCHGLB): run; NOTE: There were 1 observations read from the data set WORK.GRPMEMS_COMB. NOTE: The data set WORK.GRPMEMS_COMB has 1 observations and 6 variables. NOTE: Compressing data set WORK.GRPMEMS_COMB increased size by 100.00 percent. Compressed is 2 pages; un-compressed would require 1 pages. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(MDUCHGLB): proc sql; SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable CHANGE resolves to update SYMBOLGEN: Macro variable CHANGE resolves to update MPRINT(MDUCHGLB): create view work.person_comb as select *,"A" as chgtype from update.person_add union corresponding select *,"U" as chgtype from update.person_update; NOTE: SQL view WORK.PERSON_COMB has been defined. MPRINT(MDUCHGLB): quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(MDUCHGLB): proc sql; SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable CHANGE resolves to update SYMBOLGEN: Macro variable CHANGE resolves to update MPRINT(MDUCHGLB): create table work.identity_summary as select targobjid, keyid, name, externalkey, "P" as identitytype from update.person_summary union select targobjid, keyid, name, externalkey, "G" as identitytype from update.idgrps_summary; NOTE: Table WORK.IDENTITY_SUMMARY created, with 0 rows and 5 columns. SYMBOLGEN: Macro variable TEMP resolves to work NOTE: Simple index keyid has been defined. MPRINT(MDUCHGLB): create index keyid on work.identity_summary (keyid) quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.02 seconds cpu time 0.01 seconds MPRINT(MDUCHGLB): proc sql; SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable CHANGE resolves to update SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable CHANGE resolves to update MPRINT(MDUCHGLB): create table work.logins_temp as select logins.objid, logins.keyid, logins.userid, logins.password, 'A' as chgtype, logins.authdomkeyid, logins.externalkey, idsum.targobjid, idsum.identitytype, idsum.name as identityname, authdom_sum.targobjid as authdomobjid from update.logins_add as logins left join work.identity_summary as idsum on logins.keyid = idsum.keyid left join update.AuthDomain_summary as authdom_sum on logins.authdomkeyid = authdom_sum.keyid; NOTE: Compressing data set WORK.LOGINS_TEMP increased size by 100.00 percent. Compressed is 2 pages; un-compressed would require 1 pages. NOTE: Table WORK.LOGINS_TEMP created, with 1 rows and 11 columns. SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable TEMP resolves to work MPRINT(MDUCHGLB): update work.logins_temp set authdomobjid = (select ObjID from work.authdomain_comb where logins_temp.authdomkeyid = authdomain_comb.keyid) where logins_temp.authdomobjid IS MISSING; NOTE: No rows were updated in WORK.LOGINS_TEMP. 6 The SAS System 13:59 Wednesday, May 17, 2023 MPRINT(MDUCHGLB): quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.03 seconds cpu time 0.03 seconds SYMBOLGEN: Macro variable TEMP resolves to work MPRINT(MDUCHGLB): proc sort data=work.logins_temp; MPRINT(MDUCHGLB): by keyid ; MPRINT(MDUCHGLB): run; NOTE: There were 1 observations read from the data set WORK.LOGINS_TEMP. NOTE: The data set WORK.LOGINS_TEMP has 1 observations and 11 variables. NOTE: Compressing data set WORK.LOGINS_TEMP increased size by 100.00 percent. Compressed is 2 pages; un-compressed would require 1 pages. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.01 seconds MPRINT(MDUCHGLB): proc sql; SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable CHANGE resolves to update SYMBOLGEN: Macro variable CHANGE resolves to update MPRINT(MDUCHGLB): create view work.location_comb as select *,"A" as chgtype from update.location_add union corresponding select *,"U" as chgtype from update.location_update; NOTE: SQL view WORK.LOCATION_COMB has been defined. SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable CHANGE resolves to update MPRINT(MDUCHGLB): create table work.location_temp as select locs.objid, locs.keyid, locs.externalkey, locs.chgtype, locs.address, locs.area, locs.city, locs.country, locs.locationtype, locs.locationname, locs.postalcode, person_sum.targobjid from work.location_comb as locs, update.person_summary as person_sum where locs.keyid = person_sum.keyid order by keyid; NOTE: Table WORK.LOCATION_TEMP created, with 0 rows and 12 columns. MPRINT(MDUCHGLB): quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MPRINT(MDUCHGLB): proc sql; SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable CHANGE resolves to update SYMBOLGEN: Macro variable CHANGE resolves to update MPRINT(MDUCHGLB): create view work.phone_comb as select phonetype, phonenumber, keyid, objid, externalkey,"A" as chgtype from update.phone_add union select phonetype, phonenumber, keyid, objid, externalkey,"U" as chgtype from update.phone_update; NOTE: SQL view WORK.PHONE_COMB has been defined. SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable CHANGE resolves to update MPRINT(MDUCHGLB): create table work.phone_temp as select phone.*, person_sum.targobjid, person_sum.name as personname from work.phone_comb as phone, update.person_summary as person_sum where phone.keyid = person_sum.keyid order by keyid; NOTE: Table WORK.PHONE_TEMP created, with 0 rows and 8 columns. MPRINT(MDUCHGLB): quit; NOTE: PROCEDURE SQL used (Total process time): 7 The SAS System 13:59 Wednesday, May 17, 2023 real time 0.01 seconds cpu time 0.00 seconds MPRINT(MDUCHGLB): proc sql; SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable CHANGE resolves to update SYMBOLGEN: Macro variable CHANGE resolves to update MPRINT(MDUCHGLB): create view work.email_comb as select emailtype, emailaddr, keyid, objid, externalkey,"A" as chgtype from update.email_add union select emailtype, emailaddr, keyid, objid, externalkey,"U" as chgtype from update.email_update; NOTE: SQL view WORK.EMAIL_COMB has been defined. SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable CHANGE resolves to update MPRINT(MDUCHGLB): create table work.email_temp as select email.*, person_sum.targobjid, person_sum.name as personname from work.email_comb as email, update.person_summary as person_sum where email.keyid = person_sum.keyid order by keyid; NOTE: Table WORK.EMAIL_TEMP created, with 0 rows and 8 columns. MPRINT(MDUCHGLB): quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds SYMBOLGEN: Macro variable TEMP resolves to work MPRINT(MDUCHGLB): data work.interleave; MPRINT(MDUCHGLB): length keyid $ 200; MPRINT(MDUCHGLB): length objtype $ 20; SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable TEMP resolves to work MPRINT(MDUCHGLB): set work.idgrps_comb (in=idg) work.person_comb (in=prs) work.logins_temp (in=lgn) work.phone_temp (in=phn) work.location_temp (in=loc) work.email_temp (in=eml); MPRINT(MDUCHGLB): by keyid; MPRINT(MDUCHGLB): if (idg=1) then objtype = 'IdentityGroup'; MPRINT(MDUCHGLB): if (prs=1) then objtype = 'Person'; MPRINT(MDUCHGLB): if (lgn=1) then objtype = 'Login'; MPRINT(MDUCHGLB): if (phn=1) then objtype = 'Phone'; MPRINT(MDUCHGLB): if (loc=1) then objtype = 'Location'; MPRINT(MDUCHGLB): if (eml=1) then objtype = 'Email'; MPRINT(MDUCHGLB): run; NOTE: There were 0 observations read from the data set UPDATE.IDGRPS_ADD. NOTE: There were 0 observations read from the data set UPDATE.IDGRPS_UPDATE. NOTE: There were 0 observations read from the data set WORK.IDGRPS_COMB. NOTE: There were 0 observations read from the data set UPDATE.PERSON_ADD. NOTE: There were 0 observations read from the data set UPDATE.PERSON_UPDATE. NOTE: There were 0 observations read from the data set WORK.PERSON_COMB. NOTE: There were 1 observations read from the data set WORK.LOGINS_TEMP. NOTE: There were 0 observations read from the data set WORK.PHONE_TEMP. NOTE: There were 0 observations read from the data set WORK.LOCATION_TEMP. NOTE: There were 0 observations read from the data set WORK.EMAIL_TEMP. NOTE: The data set WORK.INTERLEAVE has 1 observations and 29 variables. NOTE: Compressing data set WORK.INTERLEAVE increased size by 100.00 percent. Compressed is 2 pages; un-compressed would require 1 pages. 8 The SAS System 13:59 Wednesday, May 17, 2023 NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.03 seconds MLOGIC(MDUCHGLB): %LET (variable name is DSID) SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable DSID resolves to 1 MLOGIC(MDUCHGLB): %IF condition &dsid is TRUE MLOGIC(MDUCHGLB): %LET (variable name is N_INTERLEAVE) SYMBOLGEN: Macro variable DSID resolves to 1 MLOGIC(MDUCHGLB): %LET (variable name is RC) SYMBOLGEN: Macro variable DSID resolves to 1 SYMBOLGEN: Macro variable N_INTERLEAVE resolves to 1 MLOGIC(MDUCHGLB): %IF condition &n_interleave GT 0 is TRUE MLOGIC(MDUCHGLB): %LET (variable name is BYSTMT) SYMBOLGEN: Macro variable TEMP resolves to work MPRINT(MDUCHGLB): proc sort data=work.interleave; SYMBOLGEN: Macro variable BYSTMT resolves to keyid userid phoneNumber address emailAddr MPRINT(MDUCHGLB): by keyid userid phoneNumber address emailAddr; MPRINT(MDUCHGLB): run; NOTE: There were 1 observations read from the data set WORK.INTERLEAVE. NOTE: The data set WORK.INTERLEAVE has 1 observations and 29 variables. NOTE: Compressing data set WORK.INTERLEAVE increased size by 100.00 percent. Compressed is 2 pages; un-compressed would require 1 pages. NOTE: PROCEDURE SORT used (Total process time): real time 0.01 seconds cpu time 0.01 seconds SYMBOLGEN: Macro variable OUTREQUEST resolves to MLOGIC(MDUCHGLB): %IF condition "&outrequest" EQ "" is TRUE MPRINT(MDUCHGLB): filename _idntmap temp lrecl=1024 encoding="UTF-8"; MPRINT(MDUCHGLB): data _null_; MPRINT(MDUCHGLB): file _idntmap encoding="UTF-8"; MPRINT(MDUCHGLB): put ''; MPRINT(MDUCHGLB): put ''; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): put ' /UpdateMetadata/Metadata/IdentityGroup'; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): put ' /UpdateMetadata/Metadata/IdentityGroup/@Id'; MPRINT(MDUCHGLB): put ' character'; MPRINT(MDUCHGLB): put ' string'; MPRINT(MDUCHGLB): put ' 17'; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): put ' /UpdateMetadata/Metadata/IdentityGroup/@Name'; MPRINT(MDUCHGLB): put ' character'; MPRINT(MDUCHGLB): put ' string'; MPRINT(MDUCHGLB): put ' 60'; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): put ' /UpdateMetadata/Metadata/IdentityGroup/@Desc'; 9 The SAS System 13:59 Wednesday, May 17, 2023 MPRINT(MDUCHGLB): put ' character'; MPRINT(MDUCHGLB): put ' string'; MPRINT(MDUCHGLB): put ' 200'; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): put ' /UpdateMetadata/Metadata/IdentityGroup/@DisplayName'; MPRINT(MDUCHGLB): put ' character'; MPRINT(MDUCHGLB): put ' string'; MPRINT(MDUCHGLB): put ' 256'; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): put ' /UpdateMetadata/Metadata/IdentityGroup/ExternalIdentities/ExternalIdentity/@Identifier'; MPRINT(MDUCHGLB): put ' character'; MPRINT(MDUCHGLB): put ' string'; MPRINT(MDUCHGLB): put ' 200'; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): put '
'; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): put ' /UpdateMetadata/Metadata/Person'; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): put ' /UpdateMetadata/Metadata/Person/@Id'; MPRINT(MDUCHGLB): put ' character'; MPRINT(MDUCHGLB): put ' string'; MPRINT(MDUCHGLB): put ' 17'; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): put ' /UpdateMetadata/Metadata/Person/@Name'; MPRINT(MDUCHGLB): put ' character'; MPRINT(MDUCHGLB): put ' string'; MPRINT(MDUCHGLB): put ' 60'; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): put ' /UpdateMetadata/Metadata/Person/@Desc'; MPRINT(MDUCHGLB): put ' character'; MPRINT(MDUCHGLB): put ' string'; MPRINT(MDUCHGLB): put ' 200'; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): put ' /UpdateMetadata/Metadata/Person/@DisplayName'; MPRINT(MDUCHGLB): put ' character'; MPRINT(MDUCHGLB): put ' string'; MPRINT(MDUCHGLB): put ' 256'; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): put ' /UpdateMetadata/Metadata/Person/ExternalIdentities/ExternalIdentity/@Identifier'; MPRINT(MDUCHGLB): put ' character'; MPRINT(MDUCHGLB): put ' string'; MPRINT(MDUCHGLB): put ' 200'; 10 The SAS System 13:59 Wednesday, May 17, 2023 MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): put '
'; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): put ''; MPRINT(MDUCHGLB): run; NOTE: The file _IDNTMAP is: Filename=E:\SAS_TEMP\_TD20704_AMLAPPUAT_\#LN00161, RECFM=V,LRECL=4096,File Size (bytes)=0, Last Modified=17May2023:17:36:27, Create Time=17May2023:17:36:27 NOTE: 83 records were written to the file _IDNTMAP. The minimum record length was 1. The maximum record length was 121. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MLOGIC(MDUCHGLB): %LET (variable name is BLKNUM) MPRINT(MDUCHGLB): proc sql; SYMBOLGEN: Macro variable TEMP resolves to work MPRINT(MDUCHGLB): create table work.identity_ids (keyid char(200), ObjID char(17)); NOTE: Table WORK.IDENTITY_IDS created, with 0 rows and 2 columns. MPRINT(MDUCHGLB): quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MLOGIC(MDUCHGLB): %LET (variable name is CURSTRTOBS) MLOGIC(MDUCHGLB): %LET (variable name is BLKNUM) SYMBOLGEN: Macro variable CURSTRTOBS resolves to 1 SYMBOLGEN: Macro variable N_INTERLEAVE resolves to 1 MLOGIC(MDUCHGLB): %DO %WHILE(&curstrtobs <= &n_interleave) loop beginning; condition is TRUE. MLOGIC(MDUCHGLB): %LET (variable name is BLKNUM) SYMBOLGEN: Macro variable BLKNUM resolves to 0 MLOGIC(MDUCHGLB): %LET (variable name is COMPUTETRANSTIME) MPRINT(MDUCHGLB): data _null_; MPRINT(MDUCHGLB): if ( mod( input( symget('blknum'), best16.) ,100) = 0 ) then call symput('computetranstime', put(1, 1.0) ); MPRINT(MDUCHGLB): run; NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds SYMBOLGEN: Macro variable BLKNUM resolves to 1 MLOGIC(MDUCHGLB): %IF condition ( &blknum = 1 ) is TRUE MLOGIC(MDUCHGLB): %LET (variable name is COMPUTETRANSTIME) SYMBOLGEN: Macro variable OUTREQUEST resolves to MLOGIC(MDUCHGLB): %IF condition "&outrequest" EQ "" is TRUE SYMBOLGEN: Macro variable RECFM resolves to MPRINT(MDUCHGLB): filename _outxml temp lrecl=1024 ; MPRINT(MDUCHGLB): data _null_; MPRINT(MDUCHGLB): file _outxml; 11 The SAS System 13:59 Wednesday, May 17, 2023 MPRINT(MDUCHGLB): put ""; MPRINT(MDUCHGLB): put ""; MPRINT(MDUCHGLB): run; NOTE: The file _OUTXML is: Filename=E:\SAS_TEMP\_TD20704_AMLAPPUAT_\#LN00162, RECFM=V,LRECL=1024,File Size (bytes)=0, Last Modified=17May2023:17:36:27, Create Time=17May2023:17:36:27 NOTE: 2 records were written to the file _OUTXML. The minimum record length was 10. The maximum record length was 16. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MLOGIC(MDUCHGLB): %LET (variable name is CURBLKOBS) MPRINT(MDUCHGLB): data _null_; SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable CURSTRTOBS resolves to 1 MPRINT(MDUCHGLB): set work.interleave(firstobs=1); SYMBOLGEN: Macro variable BYSTMT resolves to keyid userid phoneNumber address emailAddr MPRINT(MDUCHGLB): by keyid userid phoneNumber address emailAddr; MPRINT(MDUCHGLB): file _outxml mod; MPRINT(MDUCHGLB): format objectidentifier $225.; MPRINT(MDUCHGLB): retain objectidentifier; MPRINT(MDUCHGLB): retain byGroupCnt 0; MPRINT(MDUCHGLB): format line $1024.; MPRINT(MDUCHGLB): if first.keyid then do; MPRINT(MDUCHGLB): byGroupCnt + 1; SYMBOLGEN: Macro variable BLKSIZE resolves to 100 MPRINT(MDUCHGLB): if (byGroupCnt > 100) then stop; MPRINT(MDUCHGLB): end; MPRINT(MDUCHGLB): call symput('curblkobs', put(_n_, best16.)); MPRINT(MDUCHGLB): if (targobjid NE "") then objectidentifier = strip(targobjid); SYMBOLGEN: Macro variable REPOSID resolves to A5WRMJ6B MPRINT(MDUCHGLB): else objectidentifier = "A5WRMJ6B.$" || strip(keyid); MPRINT(MDUCHGLB): select ( objtype ); MPRINT(MDUCHGLB): when ('IdentityGroup') do; SYMBOLGEN: Macro variable REPOSID resolves to A5WRMJ6B MPRINT(MDUCHGLB): if chgtype = "A" then line = "'; MPRINT(MDUCHGLB): end; MPRINT(MDUCHGLB): else line = trim(line) || ' >'; MPRINT(MDUCHGLB): end; MPRINT(MDUCHGLB): put line; MPRINT(MDUCHGLB): if externalkey = 1 AND chgtype = "A" then do; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): line = ''; MPRINT(MDUCHGLB): put ' ' line; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): end; MPRINT(MDUCHGLB): put ""; MPRINT(MDUCHGLB): end; MPRINT(MDUCHGLB): when ('Person') do; SYMBOLGEN: Macro variable REPOSID resolves to A5WRMJ6B MPRINT(MDUCHGLB): if chgtype = "A" then line = "'; MPRINT(MDUCHGLB): put line; MPRINT(MDUCHGLB): if externalkey = 1 AND chgtype = "A" then do; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): line = ''; MPRINT(MDUCHGLB): put ' ' line; MPRINT(MDUCHGLB): put ' '; 14 The SAS System 13:59 Wednesday, May 17, 2023 MPRINT(MDUCHGLB): end; MPRINT(MDUCHGLB): put ""; MPRINT(MDUCHGLB): end; MPRINT(MDUCHGLB): when ('Login') do; SYMBOLGEN: Macro variable REPOSID resolves to A5WRMJ6B MPRINT(MDUCHGLB): line = "'; MPRINT(MDUCHGLB): put line; MLOGIC(INCSYMB): Beginning execution. MPRINT(INCSYMB): call symput('symbnum',resolve('%eval(&symbnum+1)')) MLOGIC(INCSYMB): Ending execution. MPRINT(MDUCHGLB): ; MPRINT(MDUCHGLB): if authdomobjid NE "" then do; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): line = ''; MPRINT(MDUCHGLB): put ' ' line; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): end; MPRINT(MDUCHGLB): if targobjid NE "" OR keyid NE "" then do; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): if identitytype = "P" then line = ''; MPRINT(MDUCHGLB): else line = ''; MPRINT(MDUCHGLB): put ' ' line; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): end; MPRINT(MDUCHGLB): put ''; MPRINT(MDUCHGLB): end; MPRINT(MDUCHGLB): when ('Location') do; MPRINT(MDUCHGLB): if chgtype = "A" then do; SYMBOLGEN: Macro variable REPOSID resolves to A5WRMJ6B MPRINT(MDUCHGLB): line = "'; MPRINT(MDUCHGLB): put line; MPRINT(MDUCHGLB): if keyid NE "" then do; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): line = ''; MPRINT(MDUCHGLB): put ' ' line; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): end; MPRINT(MDUCHGLB): put ""; MPRINT(MDUCHGLB): end; MPRINT(MDUCHGLB): when ('Phone') do; MPRINT(MDUCHGLB): if chgtype = "A" then do; SYMBOLGEN: Macro variable REPOSID resolves to A5WRMJ6B MPRINT(MDUCHGLB): line = ""; MPRINT(MDUCHGLB): put line; MPRINT(MDUCHGLB): if keyid NE "" then do; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): line = ''; MPRINT(MDUCHGLB): put ' ' line; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): end; MPRINT(MDUCHGLB): put ""; MPRINT(MDUCHGLB): end; MPRINT(MDUCHGLB): when ('Email') do; MPRINT(MDUCHGLB): if chgtype = "A" then do; SYMBOLGEN: Macro variable REPOSID resolves to A5WRMJ6B MPRINT(MDUCHGLB): line = ""; MPRINT(MDUCHGLB): put line; MPRINT(MDUCHGLB): if keyid NE "" then do; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): line = ''; MPRINT(MDUCHGLB): put ' ' line; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): end; MPRINT(MDUCHGLB): put ""; MPRINT(MDUCHGLB): end; MPRINT(MDUCHGLB): end; MPRINT(MDUCHGLB): run; NOTE: The file _OUTXML is: Filename=E:\SAS_TEMP\_TD20704_AMLAPPUAT_\#LN00162, RECFM=V,LRECL=1024,File Size (bytes)=30, Last Modified=17May2023:17:36:27, Create Time=17May2023:17:36:27 SYMBOLGEN: Macro variable SYMBNUM resolves to 1 NOTE: 8 records were written to the file _OUTXML. The minimum record length was 8. The maximum record length was 76. NOTE: There were 1 observations read from the data set WORK.INTERLEAVE. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MPRINT(MDUCHGLB): data _null_; MPRINT(MDUCHGLB): file _outxml mod; MPRINT(MDUCHGLB): put ""; MPRINT(MDUCHGLB): put "$METAREPOSITORY"; MPRINT(MDUCHGLB): put "SAS"; MPRINT(MDUCHGLB): put "268435456"; MPRINT(MDUCHGLB): put ""; MPRINT(MDUCHGLB): put ""; MPRINT(MDUCHGLB): run; NOTE: The file _OUTXML is: Filename=E:\SAS_TEMP\_TD20704_AMLAPPUAT_\#LN00162, RECFM=V,LRECL=1024,File Size (bytes)=313, Last Modified=17May2023:17:36:27, 19 The SAS System 13:59 Wednesday, May 17, 2023 Create Time=17May2023:17:36:27 NOTE: 6 records were written to the file _OUTXML. The minimum record length was 10. The maximum record length was 34. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds SYMBOLGEN: Macro variable OUTRESPONSE resolves to MLOGIC(MDUCHGLB): %IF condition "&outresponse" EQ "" is TRUE SYMBOLGEN: Macro variable RECFM resolves to MPRINT(MDUCHGLB): filename _respons temp ; MPRINT(MDUCHGLB): libname _respons xml xmlmap=_idntmap access=READONLY; NOTE: Libref _RESPONS was successfully assigned as follows: Engine: XML Physical Name: _RESPONS MLOGIC(MDUCHGLB): %IF condition (%symexist(_mduchglb_timer_)) is FALSE MPRINT(MDUCHGLB): proc metadata in=_outxml out=_respons header=FULL; MPRINT(MDUCHGLB): run; ERROR: The symbolic reference for A5WRMJ6B.$A5WRMJ6B.AP0001MN did not resolve. NOTE: PROCEDURE METADATA used (Total process time): real time 0.13 seconds cpu time 0.01 seconds NOTE: The SAS System stopped processing this step because of errors. MLOGIC(MDUCHGLB): %LET (variable name is PROC_MD_RC) SYMBOLGEN: Macro variable SYSERR resolves to 3000 MLOGIC(MDUCHGLB): %IF condition (%symexist(_mduchglb_timer_)) is FALSE SYMBOLGEN: Macro variable PROC_MD_RC resolves to 3000 SYMBOLGEN: Macro variable PROC_MD_RC resolves to 3000 MLOGIC(MDUCHGLB): %IF condition (&proc_md_rc = 0 OR &proc_md_rc = 4) is FALSE MLOGIC(MDUCHGLB): %LET (variable name is NOBJS) SYMBOLGEN: Macro variable CURSTRTOBS resolves to 1 SYMBOLGEN: Macro variable CURBLKOBS resolves to 1 MPRINT(MDUCHGLB): proc sql; SYMBOLGEN: Macro variable FAILEDOBJS resolves to &temp..mduchglb_failedobjs SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable CURSTRTOBS resolves to 1 SYMBOLGEN: Macro variable NOBJS resolves to 1 MPRINT(MDUCHGLB): insert into work.mduchglb_failedobjs select "work.interleave" as tablename, chgtype, objtype, name, objid, keyid, userid, authdomkeyid, ' ' as memobjtype, ' ' as memname, ' ' as memobjid, ' ' as memkeyid from work.interleave(firstobs=1 obs=1); WARNING: Character expression will be truncated when assigned to character column chgtype. NOTE: 1 row was inserted into WORK.MDUCHGLB_FAILEDOBJS. MPRINT(MDUCHGLB): quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 20 The SAS System 13:59 Wednesday, May 17, 2023 MLOGIC(MDUCHGLB): %LET (variable name is CURSTRTOBS) SYMBOLGEN: Macro variable CURSTRTOBS resolves to 1 SYMBOLGEN: Macro variable CURBLKOBS resolves to 1 MPRINT(MDUCHGLB): libname _respons; NOTE: Libref _RESPONS has been deassigned. MPRINT(MDUCHGLB): filename _respons; NOTE: Fileref _RESPONS has been deassigned. MPRINT(MDUCHGLB): filename _outxml; NOTE: Fileref _OUTXML has been deassigned. SYMBOLGEN: Macro variable CURSTRTOBS resolves to 2 SYMBOLGEN: Macro variable N_INTERLEAVE resolves to 1 MLOGIC(MDUCHGLB): %DO %WHILE() condition is FALSE; loop will not iterate again. MPRINT(MDUCHGLB): filename _idntmap; NOTE: Fileref _IDNTMAP has been deassigned. MPRINT(MDUCHGLB): proc sql; SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable TEMP resolves to work MPRINT(MDUCHGLB): update work.grpmems_comb set grpObjID = (select ObjID from work.identity_ids where grpmems_comb.grpkeyid = identity_ids.keyid) where grpmems_comb.grpObjID IS MISSING; NOTE: No rows were updated in WORK.GRPMEMS_COMB. SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable TEMP resolves to work MPRINT(MDUCHGLB): update work.grpmems_comb set memObjID = (select ObjID from work.identity_ids where grpmems_comb.memkeyid = identity_ids.keyid) where grpmems_comb.memObjID IS MISSING; NOTE: No rows were updated in WORK.GRPMEMS_COMB. SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable TEMP resolves to work MPRINT(MDUCHGLB): update work.grpmems_comb as grpmems set memobjtype = 'IdentityGroup' where grpmems.memkeyid in (select keyid from work.idgrps_comb); NOTE: No rows were updated in WORK.GRPMEMS_COMB. SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable TEMP resolves to work MPRINT(MDUCHGLB): update work.grpmems_comb as grpmems set memobjtype = 'Person' where grpmems.memkeyid in (select keyid from work.person_comb); NOTE: No rows were updated in WORK.GRPMEMS_COMB. SYMBOLGEN: Macro variable FAILEDOBJS resolves to &temp..mduchglb_failedobjs SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable FAILEDOBJS resolves to &temp..mduchglb_failedobjs SYMBOLGEN: Macro variable TEMP resolves to work MPRINT(MDUCHGLB): create table work.mduchglb_failedobjs_in as select * from work.mduchglb_failedobjs; NOTE: Compressing data set WORK.MDUCHGLB_FAILEDOBJS_IN increased size by 100.00 percent. Compressed is 2 pages; un-compressed would require 1 pages. NOTE: Table WORK.MDUCHGLB_FAILEDOBJS_IN created, with 1 rows and 12 columns. SYMBOLGEN: Macro variable FAILEDOBJS resolves to &temp..mduchglb_failedobjs SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable FAILEDOBJS resolves to &temp..mduchglb_failedobjs SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable FAILEDOBJS resolves to &temp..mduchglb_failedobjs SYMBOLGEN: Macro variable TEMP resolves to work MPRINT(MDUCHGLB): insert into work.mduchglb_failedobjs select "work.grpmems_comb" as tablename, 'A' as chgtype, 'Association:MemberIdentities' as objtype, ' ' as name, grpobjid as objid, grpkeyid as keyid, ' ' as userid, ' ' as authdomkeyid, 21 The SAS System 13:59 Wednesday, May 17, 2023 memobjtype, ' ' as memname, memobjid, memkeyid from work.grpmems_comb where grpkeyid in (select keyid from work.mduchglb_failedobjs_in where objtype = 'IdentityGroup') or memkeyid in (select keyid from work.mduchglb_failedobjs_in where objtype in ('IdentityGroup', 'Person')); NOTE: No rows were inserted into WORK.MDUCHGLB_FAILEDOBJS. SYMBOLGEN: Macro variable FAILEDOBJS resolves to &temp..mduchglb_failedobjs SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable TEMP resolves to work MPRINT(MDUCHGLB): update work.mduchglb_failedobjs as failedobjs set name = (select name from work.idgrps_comb as idgrps where failedobjs.keyid = idgrps.keyid) where failedobjs.objtype = 'Association:MemberIdentities'; NOTE: No rows were updated in WORK.MDUCHGLB_FAILEDOBJS. SYMBOLGEN: Macro variable FAILEDOBJS resolves to &temp..mduchglb_failedobjs SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable TEMP resolves to work MPRINT(MDUCHGLB): update work.mduchglb_failedobjs as failedobjs set memname = (select name from work.idgrps_comb as idgrps where failedobjs.memkeyid = idgrps.keyid) where failedobjs.objtype = 'Association:MemberIdentities' AND failedobjs.memobjtype = 'IdentityGroup'; NOTE: No rows were updated in WORK.MDUCHGLB_FAILEDOBJS. SYMBOLGEN: Macro variable FAILEDOBJS resolves to &temp..mduchglb_failedobjs SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable TEMP resolves to work MPRINT(MDUCHGLB): update work.mduchglb_failedobjs as failedobjs set memname = (select name from work.person_comb as person where failedobjs.memkeyid = person.keyid) where failedobjs.objtype = 'Association:MemberIdentities' AND failedobjs.memobjtype = 'Person'; NOTE: No rows were updated in WORK.MDUCHGLB_FAILEDOBJS. SYMBOLGEN: Macro variable FAILEDOBJS resolves to &temp..mduchglb_failedobjs SYMBOLGEN: Macro variable TEMP resolves to work MPRINT(MDUCHGLB): drop table work.mduchglb_failedobjs_in; NOTE: Table WORK.MDUCHGLB_FAILEDOBJS_IN has been dropped. SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable FAILEDOBJS resolves to &temp..mduchglb_failedobjs SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable FAILEDOBJS resolves to &temp..mduchglb_failedobjs SYMBOLGEN: Macro variable TEMP resolves to work MPRINT(MDUCHGLB): delete from work.grpmems_comb where grpkeyid in (select keyid from work.mduchglb_failedobjs where objtype = 'IdentityGroup') or memkeyid in (select keyid from work.mduchglb_failedobjs where objtype in ('IdentityGroup', 'Person')); NOTE: No rows were deleted from WORK.GRPMEMS_COMB. MPRINT(MDUCHGLB): quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.08 seconds cpu time 0.07 seconds MLOGIC(MDUCHGLB): %LET (variable name is DSID) SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable DSID resolves to 1 MLOGIC(MDUCHGLB): %IF condition &dsid is TRUE MLOGIC(MDUCHGLB): %LET (variable name is N_GRPMEMS) SYMBOLGEN: Macro variable DSID resolves to 1 MLOGIC(MDUCHGLB): %LET (variable name is RC) SYMBOLGEN: Macro variable DSID resolves to 1 SYMBOLGEN: Macro variable N_GRPMEMS resolves to 1 MLOGIC(MDUCHGLB): %IF condition &n_grpmems GT 0 is TRUE MLOGIC(MDUCHGLB): %LET (variable name is CURSTRTOBS) MLOGIC(MDUCHGLB): %LET (variable name is BLKNUM) 22 The SAS System 13:59 Wednesday, May 17, 2023 SYMBOLGEN: Macro variable CURSTRTOBS resolves to 1 SYMBOLGEN: Macro variable N_GRPMEMS resolves to 1 MLOGIC(MDUCHGLB): %DO %WHILE(&curstrtobs <= &n_grpmems) loop beginning; condition is TRUE. MLOGIC(MDUCHGLB): %LET (variable name is BLKNUM) SYMBOLGEN: Macro variable BLKNUM resolves to 0 MLOGIC(MDUCHGLB): %LET (variable name is COMPUTETRANSTIME) MPRINT(MDUCHGLB): data _null_; MPRINT(MDUCHGLB): if ( mod( input( symget('blknum'), best16.) ,100) = 0 ) then call symput('computetranstime', put(1, 1.0) ); MPRINT(MDUCHGLB): run; NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds SYMBOLGEN: Macro variable BLKNUM resolves to 1 MLOGIC(MDUCHGLB): %IF condition ( &blknum = 1 ) is TRUE MLOGIC(MDUCHGLB): %LET (variable name is COMPUTETRANSTIME) SYMBOLGEN: Macro variable OUTREQUEST resolves to MLOGIC(MDUCHGLB): %IF condition "&outrequest" EQ "" is TRUE SYMBOLGEN: Macro variable RECFM resolves to MPRINT(MDUCHGLB): filename _outxml temp lrecl=1024 ; MPRINT(MDUCHGLB): data _null_; MPRINT(MDUCHGLB): file _outxml; MPRINT(MDUCHGLB): put ""; MPRINT(MDUCHGLB): put ""; MPRINT(MDUCHGLB): run; NOTE: The file _OUTXML is: Filename=E:\SAS_TEMP\_TD20704_AMLAPPUAT_\#LN00164, RECFM=V,LRECL=1024,File Size (bytes)=0, Last Modified=17May2023:17:36:27, Create Time=17May2023:17:36:27 NOTE: 2 records were written to the file _OUTXML. The minimum record length was 10. The maximum record length was 16. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MLOGIC(MDUCHGLB): %LET (variable name is CURBLKOBS) MPRINT(MDUCHGLB): data _null_; SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable CURSTRTOBS resolves to 1 MPRINT(MDUCHGLB): set work.grpmems_comb(firstobs=1); MPRINT(MDUCHGLB): by grpkeyid memchgtype; MPRINT(MDUCHGLB): file _outxml mod; MPRINT(MDUCHGLB): retain byGroupCnt 0; MPRINT(MDUCHGLB): format line $1024.; MPRINT(MDUCHGLB): if first.grpkeyid then do; MPRINT(MDUCHGLB): byGroupCnt + 1; SYMBOLGEN: Macro variable BLKSIZE resolves to 100 MPRINT(MDUCHGLB): if (byGroupCnt > 100) then stop; MPRINT(MDUCHGLB): end; MPRINT(MDUCHGLB): call symput('curblkobs', put(_n_, best16.)); MPRINT(MDUCHGLB): if first.memchgtype then do; 23 The SAS System 13:59 Wednesday, May 17, 2023 MPRINT(MDUCHGLB): line = ''; MPRINT(MDUCHGLB): put line; MPRINT(MDUCHGLB): if (memchgtype = "A") then put ' '; MPRINT(MDUCHGLB): else put ' '; MPRINT(MDUCHGLB): end; MPRINT(MDUCHGLB): line = '<' || MLOGIC(XMLTRANS): Beginning execution. MLOGIC(XMLTRANS): Parameter STR has value memobjtype SYMBOLGEN: Macro variable STR resolves to memobjtype MPRINT(XMLTRANS): htmlencode(strip(memobjtype)) MLOGIC(XMLTRANS): Ending execution. MPRINT(MDUCHGLB): || ' ObjRef="' || MLOGIC(XMLTRANS): Beginning execution. MLOGIC(XMLTRANS): Parameter STR has value memObjID SYMBOLGEN: Macro variable STR resolves to memObjID MPRINT(XMLTRANS): htmlencode(strip(memObjID)) MLOGIC(XMLTRANS): Ending execution. MPRINT(MDUCHGLB): || '"/>'; MPRINT(MDUCHGLB): put ' ' line; MPRINT(MDUCHGLB): if (last.memchgtype) then do; MPRINT(MDUCHGLB): put ' '; MPRINT(MDUCHGLB): put ""; MPRINT(MDUCHGLB): end; MPRINT(MDUCHGLB): run; NOTE: The file _OUTXML is: Filename=E:\SAS_TEMP\_TD20704_AMLAPPUAT_\#LN00164, RECFM=V,LRECL=1024,File Size (bytes)=30, Last Modified=17May2023:17:36:27, Create Time=17May2023:17:36:27 NOTE: 5 records were written to the file _OUTXML. The minimum record length was 16. The maximum record length was 42. NOTE: There were 1 observations read from the data set WORK.GRPMEMS_COMB. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(MDUCHGLB): data _null_; MPRINT(MDUCHGLB): file _outxml mod; MPRINT(MDUCHGLB): put ""; MPRINT(MDUCHGLB): put "$METAREPOSITORY"; MPRINT(MDUCHGLB): put "SAS"; MPRINT(MDUCHGLB): put "268435456"; MPRINT(MDUCHGLB): put ""; MPRINT(MDUCHGLB): put ""; MPRINT(MDUCHGLB): run; NOTE: The file _OUTXML is: Filename=E:\SAS_TEMP\_TD20704_AMLAPPUAT_\#LN00164, 24 The SAS System 13:59 Wednesday, May 17, 2023 RECFM=V,LRECL=1024,File Size (bytes)=197, Last Modified=17May2023:17:36:27, Create Time=17May2023:17:36:27 NOTE: 6 records were written to the file _OUTXML. The minimum record length was 10. The maximum record length was 34. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds SYMBOLGEN: Macro variable OUTRESPONSE resolves to MLOGIC(MDUCHGLB): %IF condition "&outresponse" EQ "" is TRUE SYMBOLGEN: Macro variable RECFM resolves to MPRINT(MDUCHGLB): filename _respons temp ; MLOGIC(MDUCHGLB): %IF condition (%symexist(_mduchglb_timer_)) is FALSE MPRINT(MDUCHGLB): proc metadata in=_outxml out=_respons header=FULL; MPRINT(MDUCHGLB): run; NOTE: PROCEDURE METADATA used (Total process time): real time 0.07 seconds cpu time 0.00 seconds MLOGIC(MDUCHGLB): %LET (variable name is PROC_MD_RC) SYMBOLGEN: Macro variable SYSERR resolves to 0 MLOGIC(MDUCHGLB): %IF condition (%symexist(_mduchglb_timer_)) is FALSE SYMBOLGEN: Macro variable PROC_MD_RC resolves to 0 MLOGIC(MDUCHGLB): %IF condition (&proc_md_rc > 4) is FALSE MPRINT(MDUCHGLB): filename _respons; NOTE: Fileref _RESPONS has been deassigned. MPRINT(MDUCHGLB): filename _outxml; NOTE: Fileref _OUTXML has been deassigned. MLOGIC(MDUCHGLB): %LET (variable name is CURSTRTOBS) SYMBOLGEN: Macro variable CURSTRTOBS resolves to 1 SYMBOLGEN: Macro variable CURBLKOBS resolves to 1 SYMBOLGEN: Macro variable CURSTRTOBS resolves to 2 SYMBOLGEN: Macro variable N_GRPMEMS resolves to 1 MLOGIC(MDUCHGLB): %DO %WHILE() condition is FALSE; loop will not iterate again. MPRINT(MDUCHGLB): proc sql; SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable CHANGE resolves to update SYMBOLGEN: Macro variable CHANGE resolves to update SYMBOLGEN: Macro variable CHANGE resolves to update SYMBOLGEN: Macro variable CHANGE resolves to update SYMBOLGEN: Macro variable CHANGE resolves to update SYMBOLGEN: Macro variable CHANGE resolves to update SYMBOLGEN: Macro variable CHANGE resolves to update MPRINT(MDUCHGLB): create table work.delobjs as select objid, "Email " as ObjType, 1 as sortcol from update.email_delete union select objid, "Phone " as ObjType, 2 as sortcol from update.phone_delete union select objid, "Location " as ObjType, 3 as sortcol from update.location_delete union select objid, "Login " as ObjType, 4 as sortcol from update.Logins_delete union select objid, "AuthenticationDomain" as ObjType, 5 as sortcol from update.AuthDomain_delete union select objid, "Person " as ObjType, 6 as sortcol from update.person_delete union select objid, "IdentityGroup " as ObjType, 7 as sortcol from update.idgrps_delete; NOTE: Table WORK.DELOBJS created, with 0 rows and 3 columns. MPRINT(MDUCHGLB): quit; 25 The SAS System 13:59 Wednesday, May 17, 2023 NOTE: PROCEDURE SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MLOGIC(MDUCHGLB): %LET (variable name is DSID) SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable DSID resolves to 1 MLOGIC(MDUCHGLB): %IF condition &dsid is TRUE MLOGIC(MDUCHGLB): %LET (variable name is N_DELOBJS) SYMBOLGEN: Macro variable DSID resolves to 1 MLOGIC(MDUCHGLB): %LET (variable name is RC) SYMBOLGEN: Macro variable DSID resolves to 1 SYMBOLGEN: Macro variable N_DELOBJS resolves to 0 MLOGIC(MDUCHGLB): %IF condition &n_delobjs GT 0 is FALSE MLOGIC(MDUCHGLB): %IF condition (%symexist(_mduchglb_timer_)) is FALSE MLOGIC(MDUCHGLB): %IF condition (not %symexist(_mduchglb_nodelete_)) is TRUE SYMBOLGEN: Macro variable TEMP resolves to work MPRINT(MDUCHGLB): proc datasets library=work MEMTYPE=data NOLIST NOWARN; MPRINT(MDUCHGLB): Delete authdomain_comb; MPRINT(MDUCHGLB): Delete authdom_ids; MPRINT(MDUCHGLB): Delete grpmems_comb; MPRINT(MDUCHGLB): Delete identity_summary; MPRINT(MDUCHGLB): Delete logins_temp; MPRINT(MDUCHGLB): Delete location_temp; MPRINT(MDUCHGLB): Delete phone_temp; MPRINT(MDUCHGLB): Delete email_temp; MPRINT(MDUCHGLB): Delete interleave; MPRINT(MDUCHGLB): Delete identity_ids; MPRINT(MDUCHGLB): Delete delobjs; MPRINT(MDUCHGLB): quit; NOTE: Deleting WORK.AUTHDOMAIN_COMB (memtype=DATA). NOTE: Deleting WORK.GRPMEMS_COMB (memtype=DATA). NOTE: Deleting WORK.IDENTITY_SUMMARY (memtype=DATA). NOTE: Deleting WORK.LOGINS_TEMP (memtype=DATA). NOTE: Deleting WORK.LOCATION_TEMP (memtype=DATA). NOTE: Deleting WORK.PHONE_TEMP (memtype=DATA). NOTE: Deleting WORK.EMAIL_TEMP (memtype=DATA). NOTE: Deleting WORK.INTERLEAVE (memtype=DATA). NOTE: Deleting WORK.IDENTITY_IDS (memtype=DATA). NOTE: Deleting WORK.DELOBJS (memtype=DATA). NOTE: PROCEDURE DATASETS used (Total process time): real time 0.02 seconds cpu time 0.01 seconds SYMBOLGEN: Macro variable TEMP resolves to work MPRINT(MDUCHGLB): proc datasets library=work MEMTYPE=view NOLIST NOWARN; MPRINT(MDUCHGLB): Delete idgrps_comb; MPRINT(MDUCHGLB): Delete person_comb; MPRINT(MDUCHGLB): Delete location_comb; MPRINT(MDUCHGLB): Delete phone_comb; MPRINT(MDUCHGLB): Delete email_comb; MPRINT(MDUCHGLB): quit; NOTE: Deleting WORK.IDGRPS_COMB (memtype=VIEW). NOTE: Deleting WORK.PERSON_COMB (memtype=VIEW). 26 The SAS System 13:59 Wednesday, May 17, 2023 NOTE: Deleting WORK.LOCATION_COMB (memtype=VIEW). NOTE: Deleting WORK.PHONE_COMB (memtype=VIEW). NOTE: Deleting WORK.EMAIL_COMB (memtype=VIEW). NOTE: PROCEDURE DATASETS used (Total process time): real time 0.01 seconds cpu time 0.00 seconds MLOGIC(MDUCHGLB): %PUT MLOGIC(MDUCHGLB): %PUT MLOGIC(MDUCHGLB): %LET (variable name is DSID) SYMBOLGEN: Macro variable FAILEDOBJS resolves to &temp..mduchglb_failedobjs SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable DSID resolves to 1 MLOGIC(MDUCHGLB): %IF condition &dsid is TRUE MLOGIC(MDUCHGLB): %LET (variable name is N_FAILEDOBJS) SYMBOLGEN: Macro variable DSID resolves to 1 MLOGIC(MDUCHGLB): %LET (variable name is RC) SYMBOLGEN: Macro variable DSID resolves to 1 SYMBOLGEN: Macro variable N_FAILEDOBJS resolves to 1 MLOGIC(MDUCHGLB): %IF condition ( &n_failedobjs > 0 ) is TRUE MLOGIC(MDUCHGLB): %PUT ERROR: Errors returned from Proc Metadata prevented objects from being Added, Updated, or Deleted. Table: &failedobjs identifies &n_failedobjs such objects. Consult the SAS Log for the specific Metadata Server errors returned. SYMBOLGEN: Macro variable FAILEDOBJS resolves to &temp..mduchglb_failedobjs SYMBOLGEN: Macro variable TEMP resolves to work SYMBOLGEN: Macro variable N_FAILEDOBJS resolves to 1 ERROR: Errors returned from Proc Metadata prevented objects from being Added, Updated, or Deleted. Table: work.mduchglb_failedobjs identifies 1 such objects. Consult the SAS Log for the specific Metadata Server errors returned. MLOGIC(MDUCHGLB): Ending execution. 27 28 29 %LET _CLIENTTASKLABEL=; 30 %LET _CLIENTPROCESSFLOWNAME=; 31 %LET _CLIENTPROJECTPATH=; 32 %LET _CLIENTPROJECTPATHHOST=; 33 %LET _CLIENTPROJECTNAME=; 34 %LET _SASPROGRAMFILE=; 35 %LET _SASPROGRAMFILEHOST=; 36 37 ;*';*";*/;quit;run; 38 ODS _ALL_ CLOSE; 39 40 41 QUIT; RUN; 42