Hi Claudia, Sorry for the delay. Here's the double-data entry macro I recalled learning about on another list. Thanks should go to Dr. Tim Tumlin <[EMAIL PROTECTED]>.
SPSS 10 imports Excel. You could create duplicate datasets on Sheet 1 and Sheet 2 of an Excel file, then have Sheet3 be a validity check. All you do on Sheet 3 is a small entry in each cell (you can copy and paste en masse for all cells). The entry for cell A1 on Sheet 3 would be: =IF((Sheet1!A1)=(Sheet2!A1),TRUE) This will render the word "TRUE" in A1 of Sheet 3 if the contents of A1 on Sheet1 and A1 of Sheet 2 are identical, otherwise it says FALSE. Then you look for FALSE entries on Sheet 3. If it's all True, then you can import Sheet 1 into the database program. If you don't want to look for Falses on the field of cells on Sheet 3, you can also tell it to count up the number of FALSE cells in Sheet 3 with this in a cell somewhere else, such as on sheet 4; =COUNTIF(Sheet3!A1:Z100, "FALSE") That would work if you are putting 100 cases with 26 variables in the sheet. Otherwise, just change the rows and columns. It'll yield the number of FALSE entries in sheet 3, which is the number of cells in which sheets 1 and 2 don't match. In addition, Susan O'Leary <[EMAIL PROTECTED]>, from SUNY, have developed some syntax that uses looping and comparison procedures in spss. You may want to contact her. Hope this is helpful. Danny >On Tue, 05 Mar 2002 13:05:31 -0600 Claudia Stanny ><[EMAIL PROTECTED]> wrote: > > > This question is a little off-topic with respect to most undergraduate > > teaching, but I know there are several savvy statisticians on this list who > > might have an answer to this question: > > > > Does SPSS have a mechanism by which I can verify the accuracy of a large > > SPSS data file by creating two independent versions of the file and > > comparing them? We plan to compute and compare descriptive statistics > > computed for each variable for the two independent versions of the data, > > but this will only those identify variables with data discrepancies. Is > > there a procedure for doing a cell-by-cell parity comparison and identify > > cells in the two files that have different entries? I am looking for a > > procedure that will do what keypunch operators used to do -- verifying the > > accuracy of punched cards by repunching them. > > > > Thanks in advance. > > > > Claudia Stanny > > > > > > > > > > ________________________________________________________ > > > > Claudia J. Stanny, Ph.D. e-mail: [EMAIL PROTECTED] > > Department of Psychology Phone: (850) 474 - 3163 > > University of West Florida FAX: (850) 857 - 6060 > > Pensacola, FL 32514 - 5751 > > > > Web: http://www.uwf.edu/psych/stanny.html > > --- You are currently subscribed to tips as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
