Hello, I'm running as DDE sas code to get the refreshed data from sharepoint file. It was working file till last week but today it is giving me a error because of which it is not able to read the file. ERROR: Physical file does not exist, excel|system. Here is code and Log: OPTIONS NOXWAIT NOXSYNC; DATA _null_; rc=system('start excel'); rc = sleep(10); RUN; filename cmds dde 'excel|system'; data _null_; file cmds; put '[open("'"C:\Users\Documents\owssvr.xlsx"'")]'; run; data _null_; file cmds; put '[error("false")]'; put '[save.as("'"C:\Users\Documents\test.xlsx"'",51,"")]'; put '[quit]'; run; Log: OPTIONS NOXWAIT NOXSYNC; DATA _null_; rc=system('start excel'); rc = sleep(60); RUN; NOTE: DATA statement used (Total process time): real time 1:00.18 cpu time 0.32 seconds filename cmds dde 'excel|system'; data _null_; file cmds; put '[open("'"C:\Users\Documents\owssvr.xlsx"'")]'; run; ERROR: Physical file does not exist, excel|system. NOTE: The SAS System stopped processing this step because of errors. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.00 seconds data _null_; file cmds; put '[error("false")]'; put '[save.as("'"C:\Users\Documents\test.xlsx"'",51,"")]'; put '[quit]'; run; ERROR: Physical file does not exist, excel|system. NOTE: The SAS System stopped processing this step because of errors. NOTE: DATA statement used (Total process time): real time 0.07 seconds cpu time 0.01 seconds I'm not sure what has changed because it was running perfectly till last week. Thanks, Virender
... View more