DYNAMIC DATA EXCHANGE(DDE) in SAS

A QUICK STARTER

Objective: This post discusses a generally unknown and underutilized utility in SAS which gives programmers a lot of flexibility and power if utilized properly.

Theory: Dynamic data exchange alias DDE is a way for data transfer and exchange between Microsoft windows applications. SAS can utilize this functionality to transfer data to applications like MSexcel or MSword in a flexible and dynamic way.

DDE ADVANTAGES:

I know I know that right now you are saying that why in the world should I learn this new concept when I have PROC IMPORT and PROC EXPORT available, I even can use ODBC or just can import data using SAS EG.

Here is the answer…