It seems that the 'xwait' option is causing the SAS application to hang while executing its task. ... View more

I've just tried to execute the code according to the options you provided, but still nothing 😕 ... View more

Thank you! but I already have those options added 😕 ... View more

Thank you for your response! 🙂 I have checked the XCMD SAS system option in batch mode, and it shows that it is enabled. There are no errors in the log, and everything appears to be working fine. However, the VBScript code still does not seem to execute.   XCMD              Enables the X command in SAS. NOTE: PROCEDURE OPTIONS used (Total process time):       real time           0.00 seconds       cpu time            0.00 seconds       65         66         option  noxwait nosyntaxcheck; 67         option  noxsync ; 68         69         data _NULL_; 70         rc1=system('G:\path\script.vbs'); 71         put rc1; 72         run;   0 NOTE: DATA statement used (Total process time):       real time           0.01 seconds       cpu time            0.01 seconds   73         74         proc options option=xcmd; 75         run;       SAS (r) Program  9.4  TS1M3   XCMD              Enables the X command in SAS. NOTE: PROCEDURE OPTIONS used (Total process time):       real time           0.00 seconds       cpu time            0.00 seconds ... View more

I didn't think about data display limits in Excel, but for example, when I import data from SAS through the SAS Add-in in Excel into a pivot table, how large can the SAS data be for Excel to handle it? ... View more

I initially believed the issue was due to RAM, as I noticed a significant increase in memory consumption while importing data. I attempted to load a dataset with nearly a 1mln records (200MB). However, I'm relatively new to using this tool, and I've observed that server response times are gradually increasing. It also takes several minutes to select filter options, even without setting any filters. ... View more