<html>
<br>
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.<br><br>
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:
<br><br>
Peter<br><br>
<font size=2>* Import e-dat info for ENUM3<br><br>
GET DATA /TYPE = TXT<br>
/FILE = 'C:\AAPete\PhDData\Enum3\E3_5\e3_5_edat.txt'<br>
/DELCASE = LINE<br>
/DELIMITERS = "\t"<br>
/ARRANGEMENT = DELIMITED<br>
/FIRSTCASE = 2<br>
/IMPORTCASE = ALL<br>
/VARIABLES =<br>
Experime A10<br>
Subject F1.0<br>
Session F1.0<br>
Age F2.1<br>
V4 F6.2<br>
Gender A1<br>
Group F1.0<br>
Handed A1<br>
RandomSe F10.2<br>
SessionD A10<br>
SessionT A8<br>
Block F1.0<br>
BlockLis F1.0<br>
V14 F1.0<br>
V15 F1.0<br>
Practice F1.0<br>
V17 F1.0<br>
V18 F1.0<br>
V19 A8<br>
Procedur A9<br>
V20 A17<br>
Trial F2.0<br>
CheckAcc F1.0<br>
V24 F1.0<br>
V25 F1.0<br>
Code F2.0<br>
CollectC F6.0<br>
V28 F4.0<br>
corransw F1.0<br>
Fixation F4.2<br>
V31 F4.2<br>
V32 F2.1<br>
None F2.1<br>
NoWords F1.0<br>
numobs F1.0<br>
PracList F2.1<br>
V37 F1.0<br>
V38 F2.1<br>
V39 A9<br>
Recall.A F1.0<br>
V40 A9<br>
Stim1 A9<br>
ThreeSyl F2.1<br>
ThreeWor F1.0<br>
TrialLis F2.1<br>
V46 F1.0<br>
V47 F2.1<br>
TwoSyl F1.0<br>
TwoWords F1.0<br>
Type F1.0<br>
Word1 A3<br>
.<br>
CACHE.<br>
EXECUTE.<br><br>
Save Outfile= 'C:\AAPete\PhDData\Enum3\E3_5\E3_5_edat_MASTER.sav'
.<br><br>
Get<br>
file= 'C:\AAPete\PhDData\Enum3\E3_5\E3_5_edat_MASTER.sav' .<br><br>
Save Outfile= 'C:\AAPete\PhDData\Enum3\E3_5\E3_5_edat.sav' / Keep block
trial checkacc code collectc v28 corransw recall.a stim1.<br><br>
Get<br>
file= 'C:\AAPete\PhDData\Enum3\E3_5\E3_5_edat.sav' .<br><br>
Compute ob = $CASENUM.<br>
Execute.<br>
Formats ob (F8.0).<br><br>
Save Outfile= 'C:\AAPete\PhDData\Enum3\E3_5\E3_5_edat_2.sav' / Keep ob
code corransw checkacc v28 all.<br><br>
Get<br>
file= 'C:\AAPete\PhDData\Enum3\E3_5\E3_5_edat_2.sav' .<br><br>
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.<br><br>
<br>
</font>At 04:53 AM 25/06/2005, Leisha Wharfield wrote:<br>
<blockquote type=cite class=cite cite>I do the same. Filter, copy to
Excel. Our data analyst imports to SPSS & takes it from
there.<br><br>
Leisha<br><br>
Jordan Bigio wrote:<br><br>
<blockquote type=cite class=cite cite>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).<br><br>
Jordan<br><br>
<br><br>
At 05:44 PM 6/23/2005 -0400, Tony Zuccolotto wrote:<br><br>
<blockquote type=cite class=cite cite>If you are not familiar with the
feature, you may be able to save a<br>
little bit of work by using E-DataAid's "Tools|Arrange
Columns..."<br>
dialog.<br><br>
Specifically, you can click the Remove All button on the dialog to<br>
remove (hide) all the columns, optionally alphabetize the list of<br>
variables, and then double click just the variables that you want to
add<br>
them back in.<br><br>
If you save the data file it will bring back that same column<br>
arrangement the next time you load it, and you can then use the File
|<br>
Export... option to send the data elsewhere.<br><br>
If you do this early on in your master merged file, save it, and
keep<br>
reusing it then E-DataAid should save your preferred column
arrangement<br>
and keep it as the default for that merged file as new data files
are<br>
added in.<br><br>
...not totally automated, but may save a few repetitive steps or a
lot<br>
of adding and deleting using Excel.<br><br>
-Tony<br><br>
> -----Original Message-----<br>
> From: eprime@mail.talkbank.org
[<a href="mailto:eprime@mail.talkbank.org" eudora="autourl">mailto:eprime@mail.talkbank.org</a>]
On<br>
Behalf<br>
> Of Paul Warren<br>
> Sent: Thursday, June 23, 2005 5:29 PM<br>
> To: eprime@mail.talkbank.org<br>
> Subject: RE: processing eprime data<br>
><br>
> I use a similar strategy to Dave, i.e. E-merge then Excel and
then<br>
stats<br>
> either in Excel (with the statistiXL product) or in SPSS. But
I<br>
haven't<br>
> come to grips with macros in Excel for stripping out the dross.
Maybe<br>
Dave<br>
> could make his macros available?<br>
><br>
> Paul<br>
><br>
> Dr Paul Warren<br>
> School of Linguistics and Applied Language Studies<br>
> Victoria University of Wellington<br>
> New Zealand<br>
><br>
> tel +64 4 463 5631/5600<br>
> fax +64 4 463 5604<br>
><br>
><br>
><br>
> | -----Original Message-----<br>
> | From: David Hairston
[<a href="mailto:dhair@wfubmc.edu" eudora="autourl">mailto:dhair@wfubmc.edu</a>]<br>
> | Sent: Friday, 24 June 2005 9:20 a.m.<br>
> | To: Michael J. Crowley; eprime@mail.talkbank.org<br>
> | Subject: RE: processing eprime data<br>
> |<br>
> |<br>
> | As a general rule, I do not use E-Data Aid at all; I use
SPSS<br>
> | for 90% of<br>
> | my analyses, and Excel for transitioning the data between<br>
> | E-Data Aid and<br>
> | SPSS. Personally since I know that I'll need everything in SPSS
for<br>
> | eventual stats, groups for figures, etc etc, I find it easier to
go<br>
> | there directly.<br>
> | So, when the experiment is done, I immediately group it via
E-Merge,<br>
> | then export into Excel Test format... then I open it via Excel,
and<br>
go<br>
> | through and trim out all the stuff I don't want (Mike I know
what<br>
you<br>
> | mean about a LOT of irrelevant stuff). The nice thing about
doing<br>
this<br>
> | in Excel is that you can easily record a macro to delete all<br>
> | the things<br>
> | you don't want, so you can do it again later w/ a few
clicks.<br>
> | This also<br>
> | gives me a chance to change variable names to be SPSS-friendly,
etc.<br>
> | Then I just port it back out into tab-delineated text, and
import<br>
into<br>
> | SPSS from there.<br>
> |<br>
> | I, too, am curious to see what other folks do...<br>
> |<br>
> | Unfortunately as a result I do not know how to handle the
block/<br>
NULL<br>
> | data in E-data-Aid, sorry.<br>
> |<br>
> | Dave<br>
> |<br>
> | W. David Hairston<br>
> | Neurobiology and Anatomy<br>
> |<br>
> | Wake Forest University School of Medicine<br>
> | Winston-Salem, NC 27157<br>
> | (336) 716-4481 (lab)<br>
> |
<a href="http://www.wfubmc.edu/nba/XMODAL/" eudora="autourl">http://www.wfubmc.edu/nba/XMODAL/</a><br>
> |<br>
> | -----Original Message-----<br>
> | From: eprime@mail.talkbank.org
[<a href="mailto:eprime@mail.talkbank.org" eudora="autourl">mailto:eprime@mail.talkbank.org</a>]
On<br>
> | Behalf Of Michael J. Crowley<br>
> | Sent: Thursday, June 23, 2005 5:10 PM<br>
> | To: eprime@mail.talkbank.org<br>
> | Subject: processing eprime data<br>
> |<br>
> | Dear List,<br>
> |<br>
> | I'm wondering how much preprocessing people are doing in edata
aid<br>
> | before going<br>
> | to a stat package. I've seen that most postings reflect
programming<br>
> | issues and<br>
> | I'm wondering how people are processing their data,<br>
> | post-collection from<br>
> | edata<br>
> | aid. I'm hoping that his post will open this for discussion.<br>
> |<br>
> | Because data is stored trial variable by block, there are<br>
> | many null data<br>
> | values.<br>
> | Is there any ideal way for handling this in edata aid?<br>
> |<br>
> | Also, some of the data we've opted to store, in retrospect,
are<br>
> | irrelevant. Is<br>
> | their a way to batch process files in edata aid to drop
irrelevant<br>
> | variables?<br>
> |<br>
> | Thank you for all your responses. If there is a good
response to<br>
this<br>
> | post, I<br>
> | will compile the feedback for the list.<br>
> |<br>
> | best wishes,<br>
> |<br>
> | Mike Crowley<br>
> |<br>
> |<br>
> |<br>
> | Michael J. Crowley, Ph.D.<br>
> | Yale Child Study Center<br>
> | 230 South Frontage Rd.<br>
> | New Haven, CT 06520<br>
> |<br>
> |<br>
> |<br>
> | Please be aware that email communication can be<br>
> | intercepted in transmission or misdirected. Please<br>
> | consider communicating any sensitive information<br>
> | by telephone, fax or mail. The information<br>
> | contained in this message may be privileged and<br>
> | confidential. If you are NOT the intended<br>
> | recipient, please notify the sender immediately<br>
> | with a copy to hipaa.security@yale.edu and destroy<br>
> | this message.<br>
> |<br>
> |<br>
> |</blockquote><br><br>
Jordan D. Bigio, B.A.<br>
Project Coordinator<br>
Developmental Cognitive Neuroscience Laboratory<br>
Department of Communication Sciences and Disorders<br>
Northwestern University<br>
2240 N. Campus Dr., Frances Searle Building, Rm. 2-342<br>
Evanston, IL 60208<br>
Phone: 847-491-3647<br><br>
<br>
</blockquote>
<x-sigsep><p></x-sigsep>
Peter Quain<br>
School of Psychology <br>
University of New England<br>
Armidale, Australia, 2351<br>
Phone: 02 6773 5193<br>
Fax: 02 6773 3820<br>
</html>