Directory Services White Papers
Using DDE with Microsoft Excel and SAS to Collect Data from Hundreds of Users
Overview A process is demonstrated in this paper to automatically collect data from nearly 900 users using DDE with Microsoft Excel and SAS. SAS will populate (using DDE) an existing file "Template" (Excel spreadsheet) with historical data, name and save it to the appropriate directory (based on reporting structure). SAS determines the hierarchical reporting structure from a "work.control" dataset and builds the corresponding directory structure (using %sysexec). These files can be distributed to the needed participants for their input and updating. Upon collection, these "Updated" files will be stored in a similar "Reporting" directory structure.
| Publisher | SAS Institute | File Format | |
|---|---|---|---|
| Date Published | March 2001 | ||
| Format | White Papers | ||
| Topics | |||
-
Did you find this white paper useful?
White Paper RSS
Download
