Advertisement
Promo

Databases Toolkit

Download now

Using DDE with Microsoft Excel and SAS to Collect Data from Hundreds of Users

PublisherSAS Institute
Format85.7KB PDFDate added28 Mar 2001
Topics Directory Services
Downloads1357 popular

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.

Download now

Did you find this white paper useful?
38 out of 50 users found this white paper useful


  • Trackback
  • Clip Link

Related white papers

Privileged Access Lifecycle Management: How PALM Refines Strategy for Enterprise IT

Strengthening security, maintaining compliance, and achieving efficiencies and economies of scale are top-of-mind issues for enterprise IT executives. In this paper, IDC analysts examine the role of identity and access...


Transformation of Identity and Access Management: How DLP Changes the Game

Merger Announced: Identity and Access Management & Data Loss Prevention. Hear experts discuss the integrated solutions that have developed through the merger of identity and access management with data loss...


Overview of New Security Features in Windows Server 2008

Microsoft Longhorn, otherwise known as Microsoft Windows Server 2008 has a lot of new features, especially deployment and security features. Today we're talking about Bitlocker. No, it isn't a place...


Identity and Access Management Solution - The Cost Justification

Significant ROI and TCO can be achieved by implementing an identity management (IdM) solution. This session will provide an overview of what IdM is, the main business problems it solves...


Microsoft Exchange Server 2007 Performance on VMware vSphere 4

Increased adoption of VMware infrastructure and continued performance advances in hardware and software have driven the virtualization of Microsoft Exchange. The current version, Microsoft Exchange Server 2007, is a resource-hungry...


Brasil Telecom Creates an Agile Enterprise for 37,000 Users With Novell ZENworks and a Novell Identity and Access Management Solution

Brasil Telecom is truly a technological mosaic. The enterprise includes nearly 12,000 workstations, four call centers in different parts of the country, hundreds of servers and mainframes, and an archiving...


With a Novell Identity and Access Management Solution, Eastern Michigan University Reduces Password Management by 80 Percent

Founded in 1849, Eastern Michigan University is a comprehensive university located in Ypsilanti, Michigan. The university wanted to provide its students and faculty with faster access to applications without having...


Broadband Deals? Powered by Top 10 Broadband

150+ broadband packages

Compare 30+ mobile broadband deals

Mobile Broadband »
White Paper

Featured White Paper

Technical Description: IBMXIV Storage System

The IBMXIV® Storage System offers a new level of high-end disk system performance and reliability. It is a core component of theIBMInformation Infrastructure which helps clients address their needs for availability, security, compliance and retention of information. The XIVsystem provides consistency under all conditions, immunity to hotspots, ...

Download Now

Other White Papers

Best Practices for Translating Customer Satisfaction into Revenue

Today's support organisations are focused on two top-level metrics: financial results and customer...

Data Quality Considerations for a Master Data Management Structure

Companies acquiring companies. Human Resources sharing information with Finance. Businesses...

See All White Papers


Skip Sub Navigation Links to CNET Brand Links

Help

Become part of the ZDNet community.

Newsletters