[Tex/LaTex] Aligning the decimal point using siunitx and longtable

longtablesiunitxtables

I have just discovered that I couldn't do alignment of the decimal points using the siunitx and longtable packages. It throws errors, just to mention some for e.g.:

Invalid numerical input 'e' Col1 & Col2 & n & Mean &    
Duplicate exponent marker token '\token_to_str:N d' in input Col1 & Col2 & n & Mean & Median &
Invalid numerical input 'edi' Col1 & Col2 & n & Mean & Median &
Overfull \hbox (9.16669pt too wide) detected

This is a MWE of the problem stated above:

\documentclass{scrbook}
\usepackage[table-format=2.2]{siunitx}
\usepackage{longtable,booktabs}
\begin{document}
\begin{longtable}[l]{llcS[table-format=4.2]SSS} 
\caption{Some caption here for the long table.}\label{tab:somelabel}\\
\toprule
 Col1 & Col2 & n & Mean & Median & SD & P \\
\midrule
\endfirsthead
\midrule
Col1 & Col2 & n & Mean & Median & SD & P \\
\midrule
\endhead
\midrule
\endfoot
\midrule
\endlastfoot
 A & Negative &  18 & 38.90 & 2.53 & 3.53 & 0.12 \\
 A & Positive &  16 & 960.00 & 8.58 & 5.56 &  \\
 C & Negative &  18 & 98.50 & 1.14 & 1.48 & 0.75 \\
 C & Positive &  16 & 59.40 & 3.51 & 5.19 &  \\
 A & Negative &  18 & 13.70 & 3.98 & 5.12 & 0.20 \\
 A & Positive &  16 & 765.00 & 4.88 & 5.75 &  \\
 C & Negative &  18 & 33.80 & 2.64 & 3.85 & 0.10 \\
 C & Positive &  16 & 645.00 & 19.30 & 27.20 &  \\
 A & Negative &  18 & 25.90 & 5.30 & 6.77 & 0.98 \\
 A & Positive &  16 & 173.00 & 2.38 & 2.96 &  \\
 C & Negative &  18 & 182.00 & 9.10 & 13.30 & 0.03 \\
 C & Positive &  16 & 6676.00 & 69.20 & 101.00 &  \\
 A & Negative &  18 & 3.57 & 1.87 & 1.70 & 0.38 \\
 A & Positive &  16 & 108.00 & 1.93 & 1.51 &  \\
 C & Negative &  18 & 6.96 & 1.27 & 0.59 & 0.01 \\
 C & Positive &  16 & 143.00 & 3.71 & 4.30 &  \\
 A & Negative &  18 & 14.90 & 2.07 & 2.64 & 0.04 \\
 A & Positive &  16 & 693.00 & 7.03 & 8.37 &  \\
 C & Negative &  18 & 85.20 & 1.07 & 1.49 & 0.09 \\
 C & Positive &  16 & 295.00 & 16.50 & 23.70 &  \\
 A & Negative &  18 & 82.70 & 6.19 & 7.42 & 0.31 \\
 A & Positive &  16 & 1363.00 & 16.90 & 23.60 &  \\
 C & Negative &  18 & 63.70 & 2.15 & 2.78 & 0.03 \\
 C & Positive &  16 & 1101.00 & 24.40 & 34.70 &  \\
 A & Negative &  18 & 91.40 & 18.30 & 26.00 & 0.39 \\
 A & Positive &  16 & 3428.00 & 30.40 & 43.60 &  \\
 C & Negative &  18 & 37.00 & 11.90 & 17.60 & 0.84 \\
 C & Positive &  16 & 1822.00 & 7.26 & 10.60 &  \\
 A & Negative &  18 & 14.10 & 4.44 & 3.65 & 0.20 \\
 A & Positive &  16 & 404.00 & 4.27 & 5.22 &  \\
 C & Negative &  18 & 40.70 & 2.94 & 4.10 & 0.08 \\
 C & Positive &  16 & 769.00 & 21.30 & 30.20 &  \\
 A & Negative &  18 & 6.28 & 2.19 & 2.11 & 0.31 \\
 A & Positive &  16 & 397.00 & 5.25 & 7.63 &  \\
 C & Negative &  18 & 209.00 & 1.69 & 2.44 & 0.51 \\
 C & Positive &  16 & 809.00 & 11.80 & 16.40 &  \\
 A & Negative &  18 & 712.00 & 15.40 & 22.10 & 0.63 \\
 A & Positive &  16 & 3277.00 & 56.30 & 82.00 &  \\
 C & Negative &  18 & 2360.00 & 106.00 & 158.00 & 0.47 \\
 C & Positive &  16 & 4877.00 & 148.00 & 218.00 &  \\
 A & Negative &  18 & 20.10 & 4.08 & 5.19 & 0.08 \\
 A & Positive &  16 & 346.00 & 11.80 & 17.20 &  \\
 C & Negative &  18 & 4.63 & 1.03 & 1.05 & 0.03 \\
 C & Positive &  16 & 276.00 & 7.14 & 10.20 &  \\
\end{longtable}

\end{document}

Notes:

Texlive 2013
siunitx: Released 2013/07/11

Best Answer

For non-numerical content in S columns, you should generally enclose the content of the cells in braces ({}). In particular, siunitx uses the letter e for numbers with scientific notation, e.g. 2e3 for 2\times 10^3. This is the cause of the error you see. Hence, replace both cases of

Col1 & Col2 & n & Mean & Median & SD & P \\

with

{Col1} & {Col2} & {n} & {Mean} & {Median} & {SD} & {P} \\

And your example compiles fine.

Related Solutions

[Tex/LaTex] Longtable & siunitx

This cleans up the errors mentioned in the comments and makes some further adjustments. It doesn't do everything you should do but you need to make some further choices to fit the table to the page properly. (I don't know if you are using standard margins which you might reduce to make a little more room or perhaps you wish to use \small for the table. Etc.)

What I've done:

eliminated vertical rules (see booktabs documentation - don't use booktabs for the table if you need vertical rules)
switched \bfseries to \sffamily
used S for the columns with figures (see siunitx documentation)
used p for the remaining columns with \raggedright for the first
eliminated unnecessary repetition in the code
introduced \endfoot to handle \bottomrule pagewise
taken \% out of the table into the caption
maybe a couple more things I've forgotten

Remaining:

you need to eliminate the multiply defined labels caused by the use of \label in the caption
you need to pay attention to the remaining warnings, especially the 5 remaining overfull hboxes.

The code:

\documentclass{article}
\usepackage{array, longtable, booktabs, siunitx}
\newcommand*{\mysection}{\sffamily}
\begin{document}

\noindent\begin{longtable}{>{\raggedright\arraybackslash}p{.17\textwidth}*{5}{S}}% don't use vertical rules with booktabs (see the documentation)
    \caption{Descriptive Statistics (\%): Whole Sample ($N = \num{13 298}$)\label{table:DSWS}}\\
    \toprule
    % define \endfirsthead if first head differs from later heads
    {\mysection\hskip0pt Variable} & \multicolumn{1}{p{.16\textwidth}}{\sffamily\hskip0pt Proportion of Individuals in Sample} & \multicolumn{1}{p{.15\textwidth}}{\sffamily\hskip0pt Graduated} & \multicolumn{1}{p{.16\textwidth}}{\sffamily\hskip0pt Academically Excluded} & \multicolumn{1}{p{.15\textwidth}}{\sffamily\hskip0pt Transferred} & \multicolumn{1}{p{.12\textwidth}}{\sffamily\hskip0pt Censored}\\
    \midrule
    \endhead
    \bottomrule
    \endfoot
    \mysection Total & 100.00 & 40.98 & 13.39 & 6.02 & 39.61\\
    \addlinespace
    \mysection Gender\\
    Male                 & 57.78 & 39.98 & 15.68 & 5.38 & 38.96\\
    Female               & 42.22 & 42.33 & 10.24 & 6.91 & 40.52\\
    \addlinespace
    \mysection Race\\
    White & 39.34 & 52.48 & 4.15 & 5.91 & 37.46\\
    Black & 35.46 & 28.97 & 23.77 & 6.57 & 40.69\\
    Coloured & 13.21 & 39.56 & 14.34 & 6.72 & 39.39\\
    Indian/Asian & 11.98 & 40.30 & 11.93 & 4.02 & 43.75\\
    \addlinespace
    \mysection Financial Aid\\
    Ineligible for Financial Aid & 77.86 & 43.83 & 9.59 & 5.18 & 41.4\\
    Eligible for Financial Aid & 22.14 & 30.94 & 26.73 & 9 & 33.32\\
    \addlinespace
    \mysection Programme\\
    Mainstream & 77.68 & 45.7 & 9.71 & 6.16 & 38.43\\
    Academic Development & 22.32 & 24.53 & 26.18 & 5.56 & 43.73\\
    \addlinespace
    \mysection English Home Language\\
    Yes & 65.21 & 47.22 & 7.74 & 5.75 & 39.29\\
    No & 34.79 & 29.27 & 23.97 & 6.53 & 40.23\\
    \addlinespace
    \mysection School Quintile\\
    1 & 1.45 & 23.83 & 38.86 & 7.77 & 29.53\\
    2 & 2.8 & 25.74 & 32.44 & 5.36 & 36.46\\
    3 & 8.44 & 24.58 & 31.7 & 7.48 & 36.24\\
    4 & 5.29 & 26.28 & 28.98 & 6.11 & 38.64\\
    5 & 44.62 & 44.03 & 10.8 & 5.65 & 39.52\\
    Independent  & 37.38 & 44.92 & 7.7 & 6.12 & 41.26\\
    \addlinespace
    \mysection Province\\
    Western Cape & 41.45 & 45.95 & 10.49 & 6.17 & 37.39\\
    Non-Western Cape & 58.55 & 37.45 & 15.44 & 5.92 & 41.19\\
    \addlinespace
    \mysection Year of First Registration\\
    {2006} & 11.54 & 69.32 & 16.48 & 8.21 & 5.99\\
    {2007} & 11.91 & 70.39 & 17.05 & 6.5 & 6.06\\
    {2008} & 13.29 & 66.67 & 17.77 & 7.41 & 8.15\\
    {2009} & 15.32 & 54.05 & 20.86 & 10.7 & 14.38\\
    {2010} & 11.42 & 51.78 & 11.46 & 5.8 & 30.96\\
    {2011} & 10.87 & 14.18 & 11.96 & 4.22 & 69.64\\
    {2012} & 13.11 & 0 & 6.94 & 3.56 & 89.51\\
    {2013} & 12.54 & 0 & 3 & 0.72 & 96.28\\
\end{longtable}

\end{document}

The output:

Tabular on page

[Tex/LaTex] siunitx and missing decimal point

The command \si{units} is for units only. You have to use the \SI{number}{units} for what you want to do.

Best Answer

Related Solutions

[Tex/LaTex] Longtable & siunitx

[Tex/LaTex] siunitx and missing decimal point

Related Question