<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; ">Dear Lotte,<DIV> Questions on CLAN functions are really supposed to be posted to info-chibolts, but for convenience, let me answer yours here. Basically, you should be using the +d2 option in </DIV><DIV>FREQ. This creates output for the STATFREQ program. STATFREQ is very happy to create lots of zeroes for missing material in just the right EXCEL format. Here is the command that I used on the ne20 sample directory in the CLAN/lib/samples folder</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>statfreq stat.out.cex +t*CHI +f +d</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>After you run that, you are told that you are next supposed to run </DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>statfreq stat.out.cex +f +d</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>And then your output is in stat.out.sat.cex</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Good luck with this,</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Brian MacWhinney</DIV><DIV><BR><DIV><DIV>On Jul 3, 2006, at 7:05 PM, Henrichs, L.F. wrote:</DIV><BR class="Apple-interchange-newline"><BLOCKQUOTE type="cite"> <P><FONT size="2" face="Arial">Dear all,</FONT> <BR><FONT size="2" face="Arial">I hope someone has a solution to the following question I have;</FONT> <BR><FONT size="2" face="Arial">I use the FREQ command to count codes that I used in my coding / transcripts. In some transcripts one of the codes doesn't exist. Is it possible to direct the FREQ output in such a way, that it gives a "0" on the given code in stead of just skipping it in the output? This is important for me because I import the data from the output in excel by creating a textfile first.</FONT><FONT face="Times New Roman"> </FONT></P><P><FONT size="2" face="Arial">Thank you very much in advance!</FONT><FONT face="Times New Roman"> </FONT> <BR><FONT size="2" face="Arial">kind regards, Lotte Henrichs</FONT><FONT face="Times New Roman"> </FONT> <BR><I><FONT size="2" face="Arial">Lotte Henrichs, PhD candidate<BR> University of Amsterdam / ACLC</FONT></I> <BR><I><FONT size="2" face="Arial">Spuistraat 210<BR> 1012 VT Amsterdam<BR> +31 (0)20 5253805<BR> <A href="mailto:l.henrichs@uva.nl">l.henrichs@uva.nl</A><BR> <U></U></FONT><U></U><U><FONT face="Times New Roman"><A href="http:\\home.medewerker.uva.nl/l.henrichs">http:\\home.medewerker.uva.nl/l.henrichs</A></FONT></U> </I> </P> <BR> <BR> <BR> </BLOCKQUOTE></DIV><BR></DIV></BODY></HTML>