Without it the input statement would wrap around to

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

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.

Ask a homework question - tutors are online