processing eprime data

[Jordan Bigio]

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