Hi, We have SAS 9.4 Maintenance release 6 on AIX . We upgrade to maintenance release 6 on our Development Server recently. We have users that use SAS enterprise Guide 7.13 and 7.15 on their PC to connect to Dev Server. Before the upgrade users could run this piece of code and see the tables under libraries: Code 1: %macro D_DB(DBREF,DB,SCHEMA); %include "/sasdata/shared/D_Libref.sas"; %mend D_DB; %D_DB(AMIHA,CDD,AMIHA); Now, after Dev is upgraded this code still executes fine but when the users try to access the table it keeps loading . Please see the screenshot below: Output for Code 1: However, what’s strange is this code works perfectly fine when we have another piece of code after that. Code 2: %macro D_DB(DBREF,DB,SCHEMA); %include "/sasdata/shared/D_Libref.sas"; %mend D_DB; %D_DB(AMIHA,CDD,AMIHA); PROC SQL; CREATE TABLE work.BX_HA_CANCELLED_GRPS_1 AS SELECT DISTINCT GROUP_NBR, INPUT(PUT(YMDEND,8.),ANYDTDTE19.) AS GRP_CAN_DT FORMAT=DATE9., REASON FROM AMIHA.GROUP_SPAN T1 WHERE T1.TRANSCODE = 'TM' AND T1.VOID = '' /*AND REASON= 'TG' */ AND T1.YMDEND NOT = 99991231 ; QUIT; Output for Code 2: I have also attached both the logs with this email. Note: Both Codes work on our Prod and Test servers that are not upgraded yet. Are we missing something for setup for macros?
... View more
