Submitting DDE code to a remote server is not supported under SAS Enterprise Guide, SAS Studio, or SAS/CONNECT software.
The remote SAS sessions accessed with SAS Enterprise Guide, SAS Studio, and SAS/CONNECT software run in a "displayless" environment. Microsoft does not support running their Office products in these environments (which they refer to as "server-side").
For more information, see the following:
Considerations for server-side Automation of Office
Dynamic Data Exchange (DDE) -- A Legacy Method