LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (May 2001, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Thu, 17 May 2001 18:01:55 -0400
Reply-To:   Charles Patridge <Charles_S_Patridge@PRODIGY.NET>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Charles Patridge <Charles_S_Patridge@PRODIGY.NET>
Subject:   Re: Double Data Entry References
Comments:   To: schapal@MAIL.JONESCTR.ORG

Scott,

I had the same stuff - here is what is in the 1995 ZIP file I still have hanging around on my PC:

DUALDATA -- Double Data Entry Program

DUALDATA is a SAS application for validating data entry using double-entry techniques. The application is designed with the non-SAS programmer in mind and does not require manipulating SAS code to tailor the application to a particular data set. The user defines the variables, enters observations into an initial data set, and then reenters to validate. During validation, each value entered is compared against the corresponding value from the initial data set. If discrepancies occur, the field is flagged and the user is prompted to enter the correct value. The application keeps track of validated observations so that the validation process can span multiple data entry sessions. The application also allows for the possibility that observations may be omitted or duplicated.

The application is described in full in the following paper:

Shaffer, T. and N. Groninger. 1995. "Double Data Entry for Novice Users," Proceedings of the twentieth annual SAS users group international conference. pp. 1111-1116. SAS Institute Inc., Cary NC.

A Wordperfect version of this paper is included in dualdata.exe.

INSTALLING AND RUNNING DUALDATA

To run DUALDATA, you must have Base SAS and SAS/FSP software version 6.08 or later. DUALDATA was developed using SAS Version 6.08 for Microsoft Windows, but should work with any operating system. It has been used successfully with SAS versions 6.08 and 6.10 for OS/2.

DUALDATA is distributed in a self-extracting archive (dualdata.exe). The archive contains the following files:

README - this file.

TRAN - a sequential file containing the DUALDATA application in SAS transport format. This file was created using the CPORT procedure.

CIMPORT.SAS - a SAS program for converting the TRAN file into SAS catalog files. CIMPORT.SAS will need to be edited.

DUALDATA.WP6 - a Wordperfect 6.0 file describing the application. This paper can also be found in the SUGI 20 proceedings.

AUTOSAS.OS2 - an example autoexec.sas file for OS/2.

AUTOSAS.WIN - an example autoexec.sas file for Windows.

CFGSAS.OS2 - suggested configuration options that you will want to include in your config.sas file if running under OS/2.

CFGSAS.WIN - suggested configuration options that you will want to include in your config.sas file if running under Windows.

To install DUALDATA:

1. Create a directory and copy the TRAN and CIMPORT.SAS files to it.

2. Invoke SAS and run CIMPORT.SAS to create the necessary program files.

3. Create AUTOEXEC.SAS and CONFIG.SAS files to configure the SAS session and automatically load the DUALDATA application (see the sample autoexec and config files)

4. Create an icon for invoking SAS using the custom configuration and autoexec files. Consult your operating environment documentation for instructions on how to create an icon.

NOTE: The sample autoexec files provided for Windows and OS/2 include a statement for automatically invoking the application. The application can also be invoked by issuing the following command from within the SAS Display Manager System:

af cat=dual.ddesys.startup.program

At invocation, DUALDATA expects the following librefs to be already defined:

DUAL A DDE

See either of the autoexec files for a description of these librefs.

Terry L. Shaffer Terry_Shaffer@nbs.gov

Paige Groninger a347pgroning@attmail.com

HTH, Charles Patridge Email: Charles_S_Patridge@prodigy.net

PS, I still have dualdata.zip if you do not have it or Terry/Paige can not supply it for you.


Back to: Top of message | Previous page | Main SAS-L page