SAS 9.1 Companion for Windows (2 Volumes)

To use DDE in SAS, issue a FILENAME statement with the following syntax:

• FILENAME fileref DDE DDE- triplet <DDE-options>;

where:

fileref

• is a valid fileref (as described in Referencing External Files on page 146).

DDE

• is the device-type keyword that tells SAS you want to use Dynamic Data Exchange.

DDE-triplet

• is the name of the DDE external file.

DDE-options

• can be any of the following:

  • COMMAND

    • allows remote commands to be issued to DDE server applications. For more information, see Controlling Another Application Using DDE on page 276.

  • HOTLINK

    • instructs SAS to use the DDE HOTLINK. For an example of using this option, see Using the DDE HOTLINK on page 280.

  • LRECL= record-length

    • specifies the record length (in bytes). Under Windows, the default is 256. The value of record-length can range from 1 to 1,048,576 (1 megabyte).

  • NOTAB

    • instructs SAS to ignore tab characters between variables . For an example of using this option, see Using the NOTAB Option with DDE on page 279.

  • RECFM= record-format

    • controls the record format. The following are valid values under Windows:

      F	indicates fixed format.
      N	indicates binary format and causes the file to be treated as a byte stream.
      P	indicates print format.
      S370V	indicates the variable S370 record format (V).
      S370VB	indicates the variable block S370 record format (VB).
      S370VBS	indicates the variable block with spanned records S370 record format (VBS).
      V D	indicates variable format. This is the default.

      The S370 values are valid with z/OS types of files only. That is, they are valid in files that are binary, have variable-length records, and are in EBCDIC format. If you want to use a fixed-format z/OS file, first copy it to a variable-length, binary z/OS file.

CAUTION:

• Use caution when using DDE with data values that are blank or missing. For sample code, see Reading Missing Data on page 281.