You're right. E-DataAid features are often overlooked.<br><br>Perhaps I was not clear about Excel: I meant that Excel has serious problems with many rows or columns. Although I think newer versions of Excel do a much better job now, so this might not be a problem for many users. <br>
<br>paul<br><br><div class="gmail_quote">On 13 February 2013 14:27, Cognitology <span dir="ltr"><<a href="mailto:mspape@cognitology.eu" target="_blank">mspape@cognitology.eu</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div link="blue" vlink="purple" lang="EN-US"><div><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Hi,<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">If you’re not YET doing it, I urge you to have another look at what is possible with e-DataAid. The reason is that I know many students 1) know SPSS fairly well, and a bit of Excel, and try to avoid E-***. Not saying that counts for you as well. Indeed, this is a bit of a shot in the dark, but with such sentences as “</span>I have a large number of subject edat files (500+) and I like the column/row format that the Excel export option that E-DataAid uses so that I can easily convert the data into a format I like using spss syntax<span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">”, it’s difficult to avoid guessing</span>!<span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> You might want to say something about what you’re planning to do, but in its absence, let’s have an example from my own life, and maybe it helps?<u></u><u></u></span></p>
<p><u></u><span style="font-size:11.0pt;font-family:Symbol;color:#1f497d"><span>·<span style="font:7.0pt "Times New Roman""> </span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">What I like is having a good amount of Repeated Measures ANOVA style formatted columns, say, RTs of 2x4 conditions, one row per subject. For SPSS. What I have is 500 .edats. Arggh, right?<u></u><u></u></span></p>
<p><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><span>1.<span style="font:7.0pt "Times New Roman""> </span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">We merge all files to one big .emrg, which we then open in .edat<u></u><u></u></span></p>
<p><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><span>2.<span style="font:7.0pt "Times New Roman""> </span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">We filter out those RTs we are not interested in, say, the ones in which an error occurs. Also, I don’t like trials 1:20.<u></u><u></u></span></p>
<p><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><span>3.<span style="font:7.0pt "Times New Roman""> </span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Now, we go to analyze, drag Subject to the Row, and any type of between-subject variable (sex, age, etc). <u></u><u></u></span></p>
<p><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><span>4.<span style="font:7.0pt "Times New Roman""> </span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Then drag ConditionP1vs2 to columns, drag ConditionQ1vs2vs3vs4 to columns. Drag the critical RT thing to the Data bit. Press Run.<u></u><u></u></span></p>
<p><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><span>5.<span style="font:7.0pt "Times New Roman""> </span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">So, we should see a nice table of at least 500x8. Oops, it’s got two decimals.. why? Make that 4. Select all of it, copy the bunch to excel.<u></u><u></u></span></p>
<p><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><span>6.<span style="font:7.0pt "Times New Roman""> </span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Inside excel, underneath the two rows with variables (rows A and B), insert a new row (say C). Enter the wonderful formula =A&”_”&B and drag it all across row C.<u></u><u></u></span></p>
<p><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><span>7.<span style="font:7.0pt "Times New Roman""> </span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Select row C, copy, go stand in an empty bit, paste special: values only, and transpose. Copy that, go to SPSS, paste in variables: now, that’s descriptive indeed. <u></u><u></u></span></p>
<p><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><span>8.<span style="font:7.0pt "Times New Roman""> </span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Copy all the values over to SPSS (but you’ll have to reassign string values from numeric for some columns).<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">These 8 steps, lengthy as they may seem, take me about 2 minutes, and I think it’s a great workflow. <u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">TLDR? Try E-DataAid, it’s ridiculously simple, really rocks, and SPSS is best avoided as they make it slower and buggier with every next release. <u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">PS: Paul, I find Excel not at all slow with large data-files? Much faster than SPSS, at least, or at least it has been between excel 2007 and 2010 (2013 beta was running very slow here); it does not cope very well with large and lengthy formulas that need repeated recalculation and take up more than hundreds of MBs, though. <u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Best,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Michiel<u></u><u></u></span></p><p><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p><div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> <a href="mailto:e-prime@googlegroups.com" target="_blank">e-prime@googlegroups.com</a> [mailto:<a href="mailto:e-prime@googlegroups.com" target="_blank">e-prime@googlegroups.com</a>] <b>On Behalf Of </b>Daniel<br>
<b>Sent:</b> 11. February 2013 23:02<br><b>To:</b> <a href="mailto:e-prime@googlegroups.com" target="_blank">e-prime@googlegroups.com</a><br><b>Subject:</b> Re: Converting an Edat file into either a .xls or .txt file<u></u><u></u></span></p>
</div><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">Yeah, I will probably just end up splitting it using a SPSS syntax script (I am not very familiar with Matlab yet), it will be a little bit tedious but faster than doing it manually.<u></u><u></u></p>
<div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">Thanks for the input.<br><br>On Friday, February 8, 2013 6:49:09 PM UTC-5, Daniel wrote:<u></u><u></u></p><p class="MsoNormal">I have a large number of subject edat files (500+) and I like the column/row format that the Excel export option that E-DataAid uses so that I can easily convert the data into a format I like using spss syntax. Is there a faster way to convert all of these subject files into the excel format, some sort of way to iterate over all files in a folder, instead of having to open each one and export them separately?<u></u><u></u></p>
<div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">Thanks.<span class="HOEnZb"><font color="#888888"><u></u><u></u></font></span></p><span class="HOEnZb"><font color="#888888"><div><p class="MsoNormal">
<u></u> <u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div></font></span></div></div><span class="HOEnZb"><font color="#888888"><p class="MsoNormal">-- <br>You received this message because you are subscribed to the Google Groups "E-Prime" group.<br>
To unsubscribe from this group and stop receiving emails from it, send an email to <a href="mailto:e-prime+unsubscribe@googlegroups.com" target="_blank">e-prime+unsubscribe@googlegroups.com</a>.<br>To post to this group, send email to <a href="mailto:e-prime@googlegroups.com" target="_blank">e-prime@googlegroups.com</a>.<br>
To view this discussion on the web visit <a href="https://groups.google.com/d/msg/e-prime/-/r4EG1vCaqgIJ" target="_blank">https://groups.google.com/d/msg/e-prime/-/r4EG1vCaqgIJ</a>.<br>For more options, visit <a href="https://groups.google.com/groups/opt_out" target="_blank">https://groups.google.com/groups/opt_out</a>.<br>
<br> <u></u><u></u></p></font></span></div></div><span class="HOEnZb"><font color="#888888">
<p></p>
-- <br>
You received this message because you are subscribed to the Google Groups "E-Prime" group.<br>
To unsubscribe from this group and stop receiving emails from it, send an email to <a href="mailto:e-prime%2Bunsubscribe@googlegroups.com" target="_blank">e-prime+unsubscribe@googlegroups.com</a>.<br>
To post to this group, send email to <a href="mailto:e-prime@googlegroups.com" target="_blank">e-prime@googlegroups.com</a>.<br>
For more options, visit <a href="https://groups.google.com/groups/opt_out" target="_blank">https://groups.google.com/groups/opt_out</a>.<br>
<br>
<br>
</font></span></blockquote></div><br>
<p></p>
-- <br />
You received this message because you are subscribed to the Google Groups "E-Prime" group.<br />
To unsubscribe from this group and stop receiving emails from it, send an email to e-prime+unsubscribe@googlegroups.com.<br />
To post to this group, send email to e-prime@googlegroups.com.<br />
For more options, visit <a href="https://groups.google.com/groups/opt_out">https://groups.google.com/groups/opt_out</a>.<br />
<br />
<br />