processing eprime data

Thu Jun 30 08:29:51 UTC 2005

I use the same method as Peter (below) except that I e-merge the edat files
first before exporting the whole file to TXT (which saves repeating the GET
command for each subject) and then use the keep subcommand on the save command
to establish the order and content of columns (which saves time doing it by
hand in data aid).

Lee.

-- Begin original message --

From: Peter Quain <pquain at metz.une.edu.au>
Date: Thu, 30 Jun 2005 11:39:58 +1000
Subject: Re: processing eprime data
Sender: <eprime at mail.talkbank.org>
To: eprime at mail.talkbank.org

we export the entire unmodified edat file to tab del text then import the 
whole thing into SPSS, using the point and click read text data wizard, 
allowing the program to modify variable names however it wishes. We save 
then run the syntax, then print variable names with the 'Display Labels' 
command, identify the variables of interest, and use the 'Keep', 'Rename' 
and 'Drop' subcommands of the 'Save' command to sort the columns, and 
provide meaningful variable names and / or labels.

Once this is done for the 1st subject's data file the syntax can be run for 
each subsequent file simply by changing the source file name, and the 
outfile names. Any combination of variables can be grabbed from the master 
file by a few changes to the keep, drop, and rename subcommands. Because 
the variable names are the same in both individual subject and merged files 
the syntax can be used to import and organise single subject data (to 
combine behavioural data with EEG files, for instance), or merged files. 
Some rough example syntax (minus the display labels command) for single 
subject data (no subject identifier included) below:

Peter

* Import e-dat info for ENUM3

GET DATA  /TYPE = TXT
  /FILE = 'C:\AAPete\PhDData\Enum3\E3_5\e3_5_edat.txt'
  /DELCASE = LINE
  /DELIMITERS = "\t"
  /ARRANGEMENT = DELIMITED
  /FIRSTCASE = 2
  /IMPORTCASE = ALL
  /VARIABLES =
  Experime A10
  Subject F1.0
  Session F1.0
  Age F2.1
  V4 F6.2
  Gender A1
  Group F1.0
  Handed A1
  RandomSe F10.2
  SessionD A10
  SessionT A8
  Block F1.0
  BlockLis F1.0
  V14 F1.0
  V15 F1.0
  Practice F1.0
  V17 F1.0
  V18 F1.0
  V19 A8
  Procedur A9
  V20 A17
  Trial F2.0
  CheckAcc F1.0
  V24 F1.0
  V25 F1.0
  Code F2.0
  CollectC F6.0
  V28 F4.0
  corransw F1.0
  Fixation F4.2
  V31 F4.2
  V32 F2.1
  None F2.1
  NoWords F1.0
  numobs F1.0
  PracList F2.1
  V37 F1.0
  V38 F2.1
  V39 A9
  Recall.A F1.0
  V40 A9
  Stim1 A9
  ThreeSyl F2.1
  ThreeWor F1.0
  TrialLis F2.1
  V46 F1.0
  V47 F2.1
  TwoSyl F1.0
  TwoWords F1.0
  Type F1.0
  Word1 A3
  .
CACHE.
EXECUTE.

Save Outfile= 'C:\AAPete\PhDData\Enum3\E3_5\E3_5_edat_MASTER.sav' .

Get
file= 'C:\AAPete\PhDData\Enum3\E3_5\E3_5_edat_MASTER.sav' .

Save Outfile= 'C:\AAPete\PhDData\Enum3\E3_5\E3_5_edat.sav' / Keep block 
trial checkacc code collectc v28 corransw  recall.a stim1.

Get
file= 'C:\AAPete\PhDData\Enum3\E3_5\E3_5_edat.sav' .

Compute ob = $CASENUM.
Execute.
Formats ob (F8.0).

Save Outfile= 'C:\AAPete\PhDData\Enum3\E3_5\E3_5_edat_2.sav' / Keep ob code 
corransw checkacc v28 all.

Get
file= 'C:\AAPete\PhDData\Enum3\E3_5\E3_5_edat_2.sav' .

Save Outfile= 'C:\AAPete\PhDData\Enum3\E3_5\E3_5_edat_3.sav' / Rename (code 
corransw checkacc v28 = type resp acc rt) / Drop= block To stim1.

At 04:53 AM 25/06/2005, Leisha Wharfield wrote:
>I do the same. Filter, copy to Excel. Our data analyst imports to SPSS & 
>takes it from there.
>
>Leisha
>
>Jordan Bigio wrote:
>
>>I do this as well. Hide columns I don't want, then arrange the ones I do. 
>>Copy. Paste to excel. Save, and run in SPSS with SPSS syntax for stats we 
>>want. Then, save outfiles as excel files, and paste them back into my 
>>behavioral stats file (excel as well).
>>
>>Jordan
>>
>>
>>
>>At 05:44 PM 6/23/2005 -0400, Tony Zuccolotto wrote:
>>
>>>If you are not familiar with the feature, you may be able to save a
>>>little bit of work by using E-DataAid's "Tools|Arrange Columns..."
>>>dialog.
>>>
>>>Specifically, you can click the Remove All button on the dialog to
>>>remove (hide) all the columns, optionally alphabetize the list of
>>>variables, and then double click just the variables that you want to add
>>>them back in.
>>>
>>>If you save the data file it will bring back that same column
>>>arrangement the next time you load it, and you can then use the File |
>>>Export... option to send the data elsewhere.
>>>
>>>If you do this early on in your master merged file, save it, and keep
>>>reusing it then E-DataAid should save your preferred column arrangement
>>>and keep it as the default for that merged file as new data files are
>>>added in.
>>>
>>>...not totally automated, but may save a few repetitive steps or a lot
>>>of adding and deleting using Excel.
>>>
>>>-Tony
>>>
>>> > -----Original Message-----
>>> > From: eprime at mail.talkbank.org [mailto:eprime at mail.talkbank.org] On
>>>Behalf
>>> > Of Paul Warren
>>> > Sent: Thursday, June 23, 2005 5:29 PM
>>> > To: eprime at mail.talkbank.org
>>> > Subject: RE: processing eprime data
>>> >
>>> > I use a similar strategy to Dave, i.e. E-merge then Excel and then
>>>stats
>>> > either in Excel (with the statistiXL product) or in SPSS. But I
>>>haven't
>>> > come to grips with macros in Excel for stripping out the dross. Maybe
>>>Dave
>>> > could make his macros available?
>>> >
>>> > Paul
>>> >
>>> > Dr Paul Warren
>>> > School of Linguistics and Applied Language Studies
>>> > Victoria University of Wellington
>>> > New Zealand
>>> >
>>> > tel +64 4 463 5631/5600
>>> > fax +64 4 463 5604
>>> >
>>> >
>>> >
>>> > | -----Original Message-----
>>> > | From: David Hairston [mailto:dhair at wfubmc.edu]
>>> > | Sent: Friday, 24 June 2005 9:20 a.m.
>>> > | To: Michael J. Crowley; eprime at mail.talkbank.org
>>> > | Subject: RE: processing eprime data
>>> > |
>>> > |
>>> > | As a general rule, I do not use E-Data Aid at all; I use SPSS
>>> > | for 90% of
>>> > | my analyses, and Excel for transitioning the data between
>>> > | E-Data Aid and
>>> > | SPSS. Personally since I know that I'll need everything in SPSS for
>>> > | eventual stats, groups for figures, etc etc, I find it easier to go
>>> > | there directly.
>>> > | So, when the experiment is done, I immediately group it via E-Merge,
>>> > | then export into Excel Test format... then I open it via Excel, and
>>>go
>>> > | through and trim out all the stuff I don't want (Mike I know what
>>>you
>>> > | mean about a LOT of irrelevant stuff). The nice thing about doing
>>>this
>>> > | in Excel is that you can easily record a macro to delete all
>>> > | the things
>>> > | you don't want, so you can do it again later w/ a few clicks.
>>> > | This also
>>> > | gives me a chance to change variable names to be SPSS-friendly, etc.
>>> > | Then I just port it back out into tab-delineated text, and import
>>>into
>>> > | SPSS from there.
>>> > |
>>> > | I, too, am curious to see what other folks do...
>>> > |
>>> > | Unfortunately as a result I do not know how to handle the block/
>>>NULL
>>> > | data in E-data-Aid, sorry.
>>> > |
>>> > | Dave
>>> > |
>>> > | W. David Hairston
>>> > | Neurobiology and Anatomy
>>> > |
>>> > | Wake Forest University School of Medicine
>>> > | Winston-Salem, NC 27157
>>> > | (336) 716-4481 (lab)
>>> > | http://www.wfubmc.edu/nba/XMODAL/
>>> > |
>>> > | -----Original Message-----
>>> > | From: eprime at mail.talkbank.org [mailto:eprime at mail.talkbank.org] On
>>> > | Behalf Of Michael J. Crowley
>>> > | Sent: Thursday, June 23, 2005 5:10 PM
>>> > | To: eprime at mail.talkbank.org
>>> > | Subject: processing eprime data
>>> > |
>>> > | Dear List,
>>> > |
>>> > | I'm wondering how much preprocessing people are doing in edata aid
>>> > | before going
>>> > | to a stat package.  I've seen that most postings reflect programming
>>> > | issues and
>>> > | I'm wondering how people are processing their data,
>>> > | post-collection from
>>> > | edata
>>> > | aid. I'm hoping that his post will open this for discussion.
>>> > |
>>> > | Because data is stored trial variable by block, there are
>>> > | many null data
>>> > | values.
>>> > |  Is there any ideal way for handling this in edata aid?
>>> > |
>>> > | Also, some of the data we've opted to store, in retrospect, are
>>> > | irrelevant.  Is
>>> > | their a way to batch process files in edata aid to drop irrelevant
>>> > | variables?
>>> > |
>>> > | Thank you for all your responses.  If there is a good response to
>>>this
>>> > | post, I
>>> > | will compile the feedback for the list.
>>> > |
>>> > | best wishes,
>>> > |
>>> > | Mike Crowley
>>> > |
>>> > |
>>> > |
>>> > | Michael J. Crowley, Ph.D.
>>> > | Yale Child Study Center
>>> > | 230 South Frontage Rd.
>>> > | New Haven, CT 06520
>>> > |
>>> > |
>>> > |
>>> > | Please be aware that email communication can be
>>> > | intercepted in transmission or misdirected. Please
>>> > | consider communicating any sensitive information
>>> > | by telephone, fax or mail. The information
>>> > | contained in this message may be privileged and
>>> > | confidential. If you are NOT the intended
>>> > | recipient, please notify the sender immediately
>>> > | with a copy to hipaa.security at yale.edu and destroy
>>> > | this message.
>>> > |
>>> > |
>>> > |
>>
>>
>>Jordan D. Bigio, B.A.
>>Project Coordinator
>>Developmental Cognitive Neuroscience Laboratory
>>Department of Communication Sciences and Disorders
>>Northwestern University
>>2240 N. Campus Dr., Frances Searle Building, Rm. 2-342
>>Evanston, IL 60208
>>Phone: 847-491-3647
>>
>>
>
>Peter Quain
>School of Psychology
>University of New England
>Armidale, Australia, 2351
>Phone:  02 6773 5193
>Fax:      02 6773 3820

-- End original message --