This preview shows page 1. Sign up to view the full content.
Unformatted text preview: nt from going to the next input lin e if it does not find a value in
the current line for each specified variable. Without it, the input statement would wrap around to find a value
for each variable. With it, at the end of the line any variable without a value is set to missing. Missover is
optional but its good insurance to use it. BASICS OF DDE—DOUBLETS AND TRIPLETS
Dynamic Data Exchange (DDE) allows W indows applications to exchange information. DDE establishes a clientserver relationship that enables a client application (SAS) to communicate with a server application (Word). SAS is
always the client and either requests data from server applications, sends data to server applications, or sends
commands to server applications. You can use DDE with the DATA step, the SAS macro facility, SAS/AF
applications, or any other part of SAS that requests or generates data. Many good Conference papers have been
written about using DDE, mostly for communicating with Excel. Once you understand having SAS use DDE for one
Windows application, the others work the same way.
A specially formed FILENAME statement is what SAS uses to control DDE and there are two forms for it—
FILENAME fileref DDE 'DDE-doublet';
FILENAME fileref DDE 'DDE-triplet' <options>;
In both forms, DDE is the keyword that tells SAS to use dynamic data exchange. DDE is a device-type name that
enables SAS to read and write data from a device rather than a file and in concept performs the same function as an
Engine name. PIPE, EMAIL, and FTP are other common device types.
A DDE-doublet is a two-part specification by which the client sends system -level commands to the server application.
filename word DDE 'Winword|System';
In this DDE-doublet, all commands issued through the fileref WORD are routed to the winword executable that
controls Microsoft Word. Text inside the quote marks of a doublet or triplet is not case sensitive,and the pipe ( | ) here is a delimiter, not an ‘or’ symbol.
With a fileref containing a DDE-doub...
View Full Document
This test prep was uploaded on 03/30/2014 for the course CGS 1000 at Hillsborough.