Using DDE to Read and Write to Excel Workbooks - Exchanging Data Between SAS and Microsoft Excel - page 178

Figure 11.6.1: SAS Code for the DDE Hello World Test.
* this worked on 32 and 64 bit o/s with Excel 97-2010 (xls, and xlsx);
* this code looks for the Excel file in the current folder;
* The Excel file must be open when the SAS code is executed;
FILENAME ddewrite DDE 'excel|[book1.xls]Sheet1!r1c1:r1c2';
DATA OUT;
FILE ddewrite;
x='Hello World';
PUT x;
RUN;
Figure 11.6.2: SAS Code Window with Current Directory Location Highlighted in Red
Circle.
A double-click on the folder name in the SAS window causes a window similar to the following to appear.
These screens are from SAS 9.4.
Figure 11.6.3: SAS Window to Allow You to Change the Current SAS Folder.