How do I use the DDEX engine with a FILENAME statement?

Nico Chart_21517

Here is an example of using the DDEX engine for the FILENAME statement to update an existing sheet in an Excel workbook. The EXPORT procedure creates an initial file so that the DDEX interface can open to update with data. If you already have a file then the EXPORT procedure step is not required.

/* Create a zipcode.xlsx file in the current directory with just a header line */   PROC EXPORT DATA=SASHELP.ZIPCODE(OBS=0 keep=ZIP CITY) OUTFILE="zipcode.xlsx" DBMS=XLSX REPLACE;    SHEET="ZIPCODE"; RUN;   /* Place the ZIP and CITY values for the first 10 zip codes in rows 2 to 12 columns 3 to 4 
   of a Excel sheet called ZIPCODE */   FILENAME Table DDEX "zipcode.xlsx|ZIPCODE!r2c3:r12c4" DLM='09'x;  DATA _NULL_;   SET sashelp.zipcode (obs=10);   FILE Table lrecl=10000;   PUT zip '09'x city; RUN;