Change Log

gtools-1.11.8 (2024-06-28)

Features

greg, savecons saves rss, tss, r2, consest without having to specify alphas
greg can now save rss, tss, r2, consest with by()

gtools-1.11.7 (2023-11-08)

Bug fixes

greg with alphas() saves consest with IV and only one absvar.

gtools-1.11.6 (2023-11-08)

Bug fixes

greg with glm and absorb no longer gives error (can't dereference NULL)

gtools-1.11.5 (2023-10-27)

Bug fixes

greg computes rss, tss internally with by (previous version would not work because the error term was not saved by group, it was overwritten; now the full residual vector is saved).

gtools-1.11.4 (2023-10-24)

Features

greg saves rss, tss, r2 in mata (not with by())
greg saves consest in mata with absorb (not with by())

gtools-1.11.3 (2023-09-20)

Bug fixes

Allow var, sd, semean, cv with aw and weights that add up to 1 (previously if weights added up to 1 the function exited, but with aw the bias adjustment is based on the number of observations, not the sum).

gtools-1.11.2 (2023-08-27)

Bug fixes

Allow replace with fasterxtile and gegen xtile
greg njabsorb fills correctly with by (pointer was not incrementing in fun)

gtools-1.11.1 (2023-04-03)

Bug fixes

gegen now accepts quotes in expressions
gregress no longer forces diagonal vcov matrix (!)
gregress gets header when displaying results
fasterxtile now takes init

gtools-1.11.0 (2023-03-24)

Features

gregress adds alphas() to save individual fixed effects; predict() gives right prediction across functions.

gtools-1.10.2 (2023-02-21)

Features

gstats tab adds formatOutput() to get a matrix with outptu formatted.

gtools-1.10.1 (2022-12-05)

Bug fixes

gstats transform [if] [in], replace nogreedy not allowed (since nogreedy reads groups on the fly it can't initialize the entire variable).

gtools-1.10.0 (2022-12-04)

Features

noinit option for gcollapse, merge, gegen, gstats (selected), gregress (and co.) to prevent targets from being emptied out with replace. Prints warning!

Enhancements

gtop prints the number of levels in Other and Missing rows by default. (With missing it only does it if there's more than one type of missing value.)
greshape tries to detect repeated stubs and suggests this possibility to the user when a stub matches multiple variables.

Bug fixes

Closes #87: For OSX, make now compiles x86_64 and arm64 separately then combines via lipo.
geomean (gcollapse, gegen, gstats) no longer exhibits inconsistent behavior with zeros and negative values. A negative value results in a missing value evne if there are zeros present (internally, if a zero is encountered the loop just checks for negative values and returns 0 if it finds none).
gstats winsor, exits with error if replace and if/in are passed (the way it's set up it'd be a bit of a hassle to allow init/noinit).
gstats transform, gstats hdfe, gregress (and co.) all now initialize their targets to be empty (missing values) with if in and replace.
gstats transform now exits with error if excludeself is passed without range, and now prints a warning if it's passed with stats other than range.
gtop no longer incorrectly replaces the display value if the numerical variable has a value label and no missing values. If there was a single value this would result in an error: gtop would think there was always at least one missing value to replace.
gcollapse no longer fails when trying to label the collapsed output if the source labels are blank (this can happen for example with data transformed to .dta from other formats or programs).
gcollapse no longer gives incorrect missing variables list when part of that list is called with varlist notation (e.g. x* y and x* exist but y does not).
gunique no longer ignores if/in with gen and replace

gtools-1.9.2 (2022-09-22)

Bug fixes

Fixed incorrect results with excludeself without specified range in gstats transform (if there were missing values the input buffer was not being copied, but replaced).

Features

Faster excludeself mean and sum without specified range in gstats transform.

gtools-1.9.1 (2022-03-28)

Features

Adds various algorithms for projection (cg, squarem, it, map) to gstats hdfe, gregress, givregress, gglm.
Some ancillary options (tolerance(), traceiter, standardize)
Parallel execution of select functions can be enabled at compile time via GTOOLSOMP
Typed (direct/non-hashed) radix sort to API internals

gtools-1.9.0 (2022-03-14)

Features

Add gstats hdfe (alias gstats residualize) for residualizing variables (i.e. HDFE transform).

gtools-1.8.4 (2022-02-02)

Enhancements

Move plugin compilation to github rather than travis.

Bug Fixes

gregress and accompanying commands were not parsing absorb variable types since version 1.8.2! The relevant code had been commented out. In effect all variables were being taken to be integers.
gregress and accompanying commands with HDFE no longer exit prematurely if there are redundant absorbed FEs next to each other.
Closes #85: Bug in gegen warning message causes errors in some fun calls.
Closes #84, #83, #73: OSX compilation moved to github.

gtools-1.8.3 (2021-11-03)

Bug Fixes

Closes #82: cw in gcollapse now working.

gtools-1.8.2 (2021-08-29)

Features

Add option to save residuals and predict (the behavior of predict() is not consistent at the moment; use with extreme caution).

Bug Fixes

Closes #79: Adds disclaimer to benchmarks.

gtools-1.8.1 (2021-08-27)

Bug Fixes

Closes #78: if now passed raw/in double-quotes throughout the pipeline
Closes #75: gunique returns 0s in r() when there are no obs
Closes #74: gstats transform parses abbreviated targets
Closes #72: Warning for gegen expressions without by group
Fixed GLM issues generating de-meaned variables
Fixed gegen nunique with multiple inputs
Fixed bug in gpoisson where internal weights not copied correctly in loop.
Various fixes to the docs.

gtools-1.8.0 (2021-06-15)

Features

Added gglm to estimate GLM models, including logit.

gtools-1.7.5 (2020-04-18)

Bug fixes

Fixed bug where gstats range (select) returned 0 instead of missing when all values in the input vector were missing.

gtools-1.7.4 (2020-04-14)

Enhancements

User must now specify global GTOOLS_BETA to use beta features.

Bug fixes

Fixed bug where the prefix in gstats was stat_ instead of stat|

gtools-1.7.3 (2020-01-30)

Bug fixes

geomean in gcollapse, gegen, and gstats now returns missing if source has any negative values (complex numbers not supprted and checking special cases when the function might be defined given possibly negative input was too complicated). Further, if any input is zero the function now returns zero (previous behavior was not well-defined).

gtools-1.7.2 (2020-01-26)

Features

Closes #69. greshape wide/spread now allows labelformat() for custom variable labels (only when a single variable is passed to key()/j()). The default is #keyvalue# #stublabel#. Available placeholders are #stubname#, #stublabel#, #keyname#, #keylabel#, #keyvalue#, and #keyvaluelabel#

Enhancements

Closes #68. gegen now allows by: prefix when calling a gstats transform function (this is only allowed because these calls already require single-variable input, so the by: prefix should not present an issue when calling the function).

gtools-1.7.1 (2020-01-26)

Bug Fixes

In gquantiles, data was read incorrectly with by() and weights if xtile was not requested. In particular, the data was copied as if the target had only one column, but since weights need to be included, the target has two columns. This was fixed.

gtools-1.7.0 (2020-01-24)

Enhancements

In givgregress
- Values to missing if model is not identified (not enough instruments).
- hdfe no longer saves projected vars.

Features

In gregress (including givregress and gpoisson) collinear columns are now dropped (LDL' decomposition).
gegen shift, shiftby(#) and gstats transform (shift #) are available to compute lags (negative #) and leds (positive #).

gtools-1.6.4 (2019-09-14)

Enhancements

Collinearity and singularity checks in regression models
colmajor_ix and related functions deleted. Go back to this commit if ever implementing rolling regressions.

gtools-1.6.3 (2019-09-08)

Features

Adds gini, gini dropneg, gini keepneg to gcollapse, gegen, and gstats tab.
Adds cumsum, cumsum +/-, and cumsum +/- varname to gstats transform; options can also be passed to cumsum globally via cumby()

Bug fixes

Fixes bug in greshape, dropmiss where if the number of remaining observations is lower than the observations in memory, set obs would be run, resulting in an error. Now keep in is run for that case.

Enhancements

Removed rowmajor option from gregress

gtools-1.6.2 (2019-08-25)

Features

Adds givregress computed via 2SLS

Bug fixes

Fixed bug in gf_regress_linalg_dgemm_colmajor(), defined in src/plugin/regress/linalg/colmajor.c: Matrix multiplication now correct when axes are of different size. This bug does not affect previous versions because this function was only used to multiply square, albeit non-symetric (but that was not the issue), matrices.

Enhancements

Splits gregress, gpoisson, and givregress. While they are all run by sf_regress internally, they are three distinct commands.
Categorize documentation into "Data manupulation", "Statistics", and "Regression models".

gtools-1.6.1 (2019-08-21)

Features

Adds gpoisson computed via IRLS
Adds weights to gregress and gpoisson

Bug fixes

Fixed cluster regression bug where X was passed instead of xptr

Enhancements

Modularized the code base so that aliases are assigned to internal functions instead of the copy/paste if/else branching statements.

gtools-1.6.0 (2019-08-18)

Features

Adds gregress (alias greg) with regressions by group, including robust SE, cluster SE (one-way or nested only), and absorb several FE (including HDFE, although the algorithm is inefficient at the moment).

gtools-1.5.11 (2019-08-04)

Features

Fixes #67; adds gegen x = rank(varname) [wgt], by(varlist) ties(type) via gstats transform (rank) [wgt], by() ties(). Weights are optional.

Bug Fixes

Fixed bug where a by variable being used as a source but not a target got renamed to the target and was no longer available as a by variable. Now a new variable should be created and the by variable remains unchanged.

gtools-1.5.10 (2019-08-03)

Bug Fixes

Fixed memory leak where the C by variables were not cleared from memory of st_into->output was allocated because free code was upgraded from 6 or 7 to 9. Conditional logic in place said that by variables should not be cleared if free code was greater than 7, but that was only meant to skip free code 8 and free code 9 in some scripts, but not all. Code 8 logic was deprecated and now by variables are allocated with code 8, so they are always clared if free code is 6 or higher.

gtools-1.5.9 (2019-06-22)

Bug Fixes

by: gegen now generates variables using the by prefix. This would give incorrect answers if the expression inside egen assumed that it would be generated with by. For example by var: gegen x = mean(max(y, y[1]))

gtools-1.5.8 (2019-06-11)

Features

gstats transform can compute rolling/range statistics via (range stat #[statlow] #[stathigh] [var]) or (range stat) with the interval(#[statlow] #[stathigh] [var]) option. Access via gegen using range_stat with the interval() option.
gstats range and gstats moving are aliases for gstats transform. They assume that every stat specified is a range stat or a moving stat, respectively.
gcollapse, gegen, gstats tab now allow function geomean for the geometric mean.

gtools-1.5.7 (2019-06-09)

Features

gstats transform, auto[()] allows automagically naming targets based on the source variable's name and the statistic requested. Default is #source#_#stat#.
gstats transform (moving stat lower upper) computes moving window statistics. gegen x = moving_stat(y), window(lower upper) is an alias.

gtools-1.5.6 (2019-06-08)

Features

New function gstats transform which applies a transformation to a variable; that is y_i = f(x_i). For example,
```
gstats transform (demean) y = x, by(group)
```
gives
```
n_j  = sum_i 1{group_i = j}
s_j  = sum_i 1{group_i = j} * x_i
y_ij = x_i - s_j / n_j
```
available:

normalize, standardize: f(x) = (x - mean(x)) / sd(x) demean: f(x) = (x - mean(x)) demedian: f(x) = (x - median(x))
Closes #63: greshape wide/gather allows prefix(...) for custom output names.
Closes #62: New stats available in gegen:
- winsor, winsorize call gstats winsor
- standardize, normalize, demean, demedian call gstats transform

Enhancements

gunique, detail now uses gstats sum, detail

Bug fixes

Closes #64: Removes head command from greshape tests (done a few commits ago but someone noticed before the merge).

gtools-1.5.5 (2019-04-24)

Features

Allows option dropmiss to use multiple output stubs in both long and long, nochecks.

gtools-1.5.4 (2019-04-16)

Features

Adds option dropmiss to drop missing observations when reshaping long (via long or gather).

gtools-1.5.3 (2019-04-04)

Enhancements

Allows the user to specify the temporary directory for files via global GTOOLS_TEMPDIR

gtools-1.5.2 (2019-03-25)

Features

Closes #58; allows uselabels[(varlist, [exclude])] to optionally specify which variables to use labels for (default is all variables). The user can also specify the option exclude to specify which variables not to do this for.

gtools-1.5.1 (2019-03-24)

Features

greshape supports @ syntax for wide and long. Change the string to be matched via match()
greshape supports stata varlist syntax for long to wide (may not be combined with @ within a stub).
greshape does not support varlist syntax for wide to long, but can use match(regex) for complex wide to long matches (see examples).

gtools-1.5.0 (2019-03-23)

Features

Closes #57
glevelsof, mata[(name)] saves the levels to mata. The levels are not stored in r(levels) and option local() is not allowed. With silent, the levels are additionally not formatted.
glevelsof, mata numfmt() requires numfmt to be a mata print format instead of a C print format.
gtop, ntop(.) and gtop, ntop(-.) now allow printing all the levels from largest to smallest or the converse.
gtop, alpha sorts the top levels in variable order. if gtop -var, alpha is passed then they are sorted in reverse order.
gtop, mata uses temporary files on disk to read the levels from C via mata. Matrices and locals are not used, meaning r(levels), r(toplevels), and the resuls stored via the option -matrix()-, r(`matrix'), are no longer available. The user can access each of these via the mata object GtoolsByLevels (the user can change the name of this object via mata(name)). The levels are stored raw in GtoolsByLevels.charx and GtoolsByLevels.numx; the levels are stored formatted in GtoolsByLevels.printed; the frequencies are stored in GtoolsByLevels.toplevels.
r(matalevels) stores the name of the mata object with the levels and frequencies.
gtop also stores r(ntop), r(nrows), and r(alpha) as return scalars, for the numbere of top levels (if ., this will be r(J)), the number of rows in the toplevels matrix (it may or not include a row for "other" and a row for "missing"), and whether the top levels are sorted by their values.
gtop, mata numfmt() requires numfmt to be a mata print format instead of a C print format.

gtools-1.4.2 (2019-02-25)

Enhancements

gstats sum/tab allow saving their results in a mata object via matasave[(name)]. Prior versions hard-coded the object's name.

gtools-1.4.1 (2019-02-24)

Features

gstats sum and gstats tab (alias gstats summarize and gstats tabstat) are a fast, by-able alternative to sum, detail and tabstat
gstats sum or gstats tab with option matasave stores the output and by levels in GstatsOutput, an object of class GtoolsResults.
gcollapse and gegen now allow the stats:
- select#, #th smallest value (select1 is the same as min)
- select-#, #th largest value (select-1 is the same as max)
- rawselect# and rawselect-#, ibid but ignoring weights.
- cv, coefficient of variation, sd/mean
- variance
- range, max - min

Bug fixes

gcollapse no longer crashes when rawstat does not match any entries.
Fixes #54; incorrect checking for greshape wide/spread blank keys
Fixes #55; allows uselabels to use labels as balues in greshape gather

Enhancements

lgtools.mlib added with come pre-compiled mata functios.

gtools-1.3.5 (2019-02-19)

Enhancements

In greshape, levels of key()/j() are now saved before being converted to variable names, meaning the labels preserve the names of the levels (up to the maximum variable label length in Stata).

gtools-1.3.4 (2019-02-17)

Bug fixes

Critical bug fix in gtop; version 1.2.5 introduced a bug in gtop where the levels were incorrectly given.
Minor bug fix in gtop; inverted levels were not correctly sorted with weights. The levels themselves were OK, however.

gtools-1.3.3 (2019-02-15)

Enhancements

Removed locale as a dependency; comma printing done manually.

gtools-1.3.2 (2019-02-14)

Testing

Hopefully fixes #40; might be related to #53

gtools-1.3.1 (2019-02-11)

Enhancements

greshape's preferred syntax is now by() and keys() instead of i() and j(); the docs and most of the printouts reflect this.

Bug fixes

gtop, glevelsof, and gcontract parse wildcards before adding any temporary variables, ensuring the latter don't get included in internal function calls.
greshape no longer crashes if there are missing values in keys()/j(); the mata function strtoname converted "" into ""; now I force missing to be converted to _.
glevelsof and gtop should handle embedded characters better. Printing is still a problem but they get copied to the return values properly.

gtools-1.3.0 (2019-02-08)

Features

greshape long and greshape wide are a fast alternative to reshape. It additionally implements greshape spread and greshape gather, which are analogous to the spread and gather commands from R's tidyr.

Enhancements

Added docs, examples greshape and gstats

Bug fixes

Fixes #49

gtools-1.2.7 (2019-01-23)

Enhancements

Deleted all ancillary files and code related to spookyhash.dll

gtools-1.2.6 (2019-01-19)

Enhancements

SpookyHash code compiled directly as part of the plugin. Might fix #35

gtools-1.2.5 (2019-01-19)

Enhancements

Faster hash sort with integer bijection (two-pass radix sorts for smaller integers; undocumented option _ctolerance() allows the user to force the regular counting sort).
Faster index copy when every observation is read (simply assign the index pointer to st_info->index)

gtools-1.2.4 (2019-01-05)

Bug fixes

Stata 14.0 no longer tries to load SPI version 3 (loads version 2).
Fixes #51: gstats winsor no longer fails with percentiles not strictly between 0 and 100.

gtools-1.2.3 (2018-12-22)

Bug fixes

Fixes #50: gstats winsor no longer fills in missing values as the high percentile.

gtools-1.2.2 (2018-12-18)

Features

gstats winsor now takes weights.

gtools-1.2.1 (2018-12-16)

Bug fixes

gstats winsor no longer crashes with multiple variables.
gstats winsor, trim correctly copies the source to the target.

gtools-1.2.0 (2018-12-16)

Features

gstats general-purpose wrapper for misc functions.
gstats winsor for Winsorizing and trimming data.

gtools-1.1.2 (2018-11-16)

Enhancements

Improved variable parsing in general.
Error message when variable not found now explicit.
If - is found, warning message noting the default is to interpret that as negative, not part of a varlist.
ds and nods control parsing options for -

gtools-1.1.1 (2018-11-14)

Features

gcollapse, merge and gegen now accept the undocumented option _subtract to subtract the result from the source variable. This is an undocumented option meant for advanced users, so no additional checks have been added. If you use it then you know what you're doing.

gtools-1.1.0 (2018-11-02)

Features

gcollapse (nmissing) counts the number of missing values (weights allowed).

Enhancements

gcollapse (nansum) and gcollapse (rawnansum) preserve missing value (NaN) information: If all entries are missing, the output is also missing (instead of 0). This is a more flexible version of the previous implementation, gcollapse, missing.

Bug fixes

gisid no longer gives wrong results when the data is partially ordered. Partially (weakly) sorted data would be incorrectly counted as totally sorted.
gcollapse (rawsum) gives 0 if all entries are missing.
gcollapse and gegen correctly parse types with weights for counts and sums. This includes gcollapse, sumcheck
Closes #45
Closes #46
Closes #47

gtools-1.0.7 (2018-10-27)

Features

Added option sumcheck to create sum targers from integer source as the smallest type that reasonable given the total sum.
Closes #44

Enhancements

Recast upgrade (bug fix from 1.0.5) now done per-variable.
Added about section to readme, with some plugs (good idea? bad idea?)

gtools-1.0.6 (2018-09-25)

Enhancements

All the help files (and the readme) ask the user to run gtools, upgrade

gtools-1.0.5 (2018-09-20)

Bug fixes

gcollapse no longer gives wrong results when count is the first of multiple stats requested for a given source variable. Previous versions wrongly recast the source as long.

gtools-1.0.4 (2018-09-16)

Enhancements

Typo fixes and improvements to gtools help file.

gtools-1.0.3 (2018-08-18)

Bug fixes

Gtools exits with error if _N > 2^31-1 and points the user to the pertinent bug report.

gtools-1.0.2 (2018-08-08)

Enhancements

Specify that you can install via ssc and upgrade via gtools, upgrade
Can selectively specify tests in gtools_tests.do

Bug fixes

Fixed minor bug in gtools.ado (else exit { is now else {)

gtools-1.0.1 (2018-07-23)

Bug fixes

gegen, replace gave the wrong result if the source was also the target (tag and group worked, but all other stats did not).
gunique, by() was affected by this bug and now works correctly.
gcollapse, merge exits with error if there are no observations matching if' in'.

Enhancements

gunique, by() no longer prints the top unique levels by default unless the user asks for them via detail.

gtools-1.0.0 (2018-07-21)

First official release! This will go on SSC once all the tests have passed. Final TODOs:

[X] Tests from github 0.14.2 tag [X] Linux with Stata 13 [X] Windows with Stata 13 [X] Windows with Stata 15 [X] Linux with Stata 15 [X] OSX with Stata 14 [X] Read the documentation (Stata) [X] Read the documentation (online)

Enhancements

gtools, license v prints the licenses of the open source projects used in gtools.

Bug fixes

Fixed typos in test script
gcollapse, merge no longer replces targets without replace
glevelsof, gen(, replace) no longer conflicts with replace

gtools-0.14.2 (2018-07-21)

Feature freeze!

Features

gtop (and gtoplevelsof) now accept weights.
glevelsof has option gen() to store the levels in a variable.
glevelsof has option nolocal to skip storing the levels in a local.

Enhancements

Added weights to the quick showcase in the README
Added gen() to the quick `glevelsof' showcase
Added gen() to the `glevelsof' usage page and examples.
Added tests for gtop [weight] and glevelsof, gen()

Bug Fixes

gegen() with replace sets missing values outside if in range.

gtools-0.14.1 (2018-07-19)

Features

fasterxtile and gquantiles now accept weights (including by())
Note that stata might not handle weights accurately in pctile and xtile (or, at the very least, it does not seem to follow its documented formulas in all cases).
Option compress tries to recast strL variables as str#
Option forcestrl ignores binary values check (use with caution).

Bug Fixes

semean returns missing with fewer than 2 observations.
If strL contains binary data gtools functions now throw an error.
strL missing values now read correctly.
strL partial support for OSX (long strings only).
Added strL-specific tests
All tests passing in Stata 13 in Linux, Windows
All tests passing in Stata 15 in Linux
All tests passing in Stata 14 in OSX

gtools-0.14.0 (2018-07-17)

Bug Fixes

Closes #39 strL partial support (OSX pending).
Closes #41 wild with existing variables gets a warning.
Fixes #42 gunique typo.

gtools-0.13.3 (2018-05-06)

Features

Adds gduplicates as a replacement of duplicates. This is basically a wrapper for gegen tag and gegen count.

Enhancements

_gtools_internals.ado exits when GTOOLS_CALLER is empty.

gtools-0.13.2 (2018-05-03)

Features

Fixes #31 (added option mlast to hashsort to imitate gsort when sorting numbers in inverse order and they contain missing values).

gtools-0.13.1 (2018-05-02)

Pending

For now, throws error for strL variable: #39

Plugin version 2.0 makes no mention of strL variables; however, plugin version 3.0 notes that they are actually not supported by the macros that I use to access strings. I think I'll have to compile a sepparate version of the plugin for Stata 13 and Stata 14 and above. The Stata 13 version will throw an error for strL variables. This is currently the only version until I figure out where to test Stata 14 and how to implement this switch.

Bug fixes

Fixes #38

When the quantile requested was N - 1 out of an array of length N, I makde an exception so the function picked up the largest value, instead of passing N - 1 to the selection algorithm. However, I made a mistake and quantiles between 100 - 150 / N and 100 - 100 / N, left-inclusive right-exclusive, would give the wrong quantile.

gtools-0.13.0 (2018-04-24)

Enhancements

Added some basic debugging code and comments to the code base.

Bug fixes

sd, semean give the correct answer when the group is a singleton or when all observations are the same.
skew, kurt give the correct answer when the group is a singleton or when all observations are the same.

gtools-0.12.8 (2018-04-23)

Features

Added rawsum
Added option rawstat(); you can pass a list of targets for which weights will be ignored. percent cannot be called with rawstat. All targets must be named explicitly (i.e. will not expand varlist notation). Fixes #37

Neither rawsum nor rawstat are very smart. If the user requests them without weights, they will be ignored without warning. If the user requests them with weights, the weighted version will still be called (weighted internals are slower than unweighted internals).

Bug fixes

When not weighted, skew and kurt return missing when all observations are the same. When weighted, they may return -1 or 1 due to numerical (im)precission problems. This issue is also present in Stata's implementation and should only come up when working with doubles rounded to arbitrary decimal places.

gtools-0.12.7 (2018-04-05)

Bug fixes

Added OSX plugin in build.
Enclosed various macros in `""' in case they contain quotations.

gtools-0.12.6 (2018-03-31)

Features

Added skewness and kurtosis to gcollapse and gegen

Bug fixes

Fixed install issues in #36

gtools-0.12.5 (2018-03-06)

Bug fixes

Fixed install issues in matthieugomez/benchmark-stata-r#6
Fixed gegen type issue in #34

gtools-0.12.4 (2018-02-06)

Enhancements

gegen always created a temporary variable in an attempt to fix #33, which was unnecessary and it slowed it down.
Updated typos in documentation.

gtools-0.12.3 (2018-02-01)

Enhancements

Linux and Windows tests passing with updated weights and nunique
Updated documentation.

Bug fixes

Weights used the incorrect rules for outputting missing values when computing sd or se*; this was fixed.
Fixes #33 and now tries to parse and expression first and a varlist second.

gtools-0.12.2 (2018-02-01)

Enhancements

OSX version of gcollapse, gegen with weights and nunique
Travis-compiled; I won't commit to master w/o passing tests

gtools-0.12.1 (2018-01-22)

Features

gcontract supports fweights (Unix only; tests pending)
gcollapse and gegen support nunique (Unix only; tests pending)
gcollapse and gegen now support weights in Windows and Unix (OSX pending). gegen does not support weights with multiple sources (e.g. sum(x y z)).

gtools-0.11.5 (2018-01-16)

Features

gcollapse now allows wild-parsing via option wild (wildparse). E.g. (sum) x* (mean) mean_x* = x* would be valid syntax.

gtools-0.11.4 (2018-01-08)

Features

gcollapse, missing output missing for sums if all inputs are missing.
glevelsof adds option unsorted which is faster and does not sort results
The resulting data from gcollapse and gcontract are now sorted

Bug fixes

gegen now imitates egen when there are no observations selected and leaves the new variable in memory with all missing values.
gegen, missing for total and sum now correctly output missing if all inputs are missing
Fixes #32 (gcontract should allow abbreviations)

gtools-0.11.3 (2017-11-21)

Bug fixes

gtop now reads a global from gtoplevelsof so if there was an error but the exit code should be 0 (in this case, no observations throws an error internally but exits with 0 status externally) gtop no longer throws a syntax error.
Fixed bug in gdistinct where all missing observations without the missing option caused an error.

gtools-0.11.2 (2017-11-20)

Bug fixes

Fixed bug in glevelsof where if string data is already sorted the system does not compute the length of the de-duplicated string data. This caused malloc to attempt to assign the length of an unassigned but declared variable. This treated an object's address as a length and caused malloc to request dozens or hundreds of GiB and crash on some systems.

gtools-0.11.1 (2017-11-20)

Bug fixes

Fixed bug with naming conflicts between internals and gcollapse.

gtools-0.11.0 (2017-11-17)

Backwards Incompatible

gquantiles no longer supports option "binpct[()]"
glevelsof no longer supports option "silent"

Features

gquantiles supports by()
Option hash() gives user control over hashing mechanics. 0 is default (internals choose what it thinks will be fastest), 1 tries to biject, 2 always calls spookyhash.

Enhancements

Improved internal handling of numerical precision issues when computing quantiles (gquantiles, gcollapse, and gegen).
When the data is sorted, groups are indexed directly instead of using the hash. This was 2x faster in testing for an overall ~33% or so speedup.
gtop is a shortcut for gtoplevelsof
bench(2) and bench(3) offer the user more control over what benchmark steps are displayed.

Bug fixes

Fixes possible bug with levelsof where the plugin tries to read more characters than contained in the numfmt local macro. This could cause problems on some systems.

gtools-0.10.3 (2017-11-12)

Bug fixes

Fixes #29; if the sources appear out of order relative to the targets (e.g. sources are 'a b' but targets use sources 'a a b b' instead of 'a b a b') then gcollapse produced the wrong results with option forceio or with the swtich code. The code now reorders the sources, targets, and statistics so the source variables always appear first and the extra targets last.
Fixes bug in gtop where requesting negative levels caused an overflow.
Fixes bug in hashsort where there may be a loss in numerical precision when clearing the sort var. It now adds one observation to the source data, changes the dummy observation, and drops it. This should have the same effect without modifying the original dataset.

Enhancements

Counting sort now uses pointers, which is hopefully faster.
Added special cases for gquantiles to hopefully accelerate reading source variables from Stata.
Added special case for gegen, group so the code orders the groups back to Stata order before copying. It runs faster because it writes to Stata sequentially, but it uses more memory.
The code no longer keeps a copy of the by variables when it is not needed (gcollapse, glevelsof, gtop, and gcontract need a copy; gegen, hashsort, gquantiles, etc. do not).

gtools-0.10.2 (2017-11-08)

Bug fixes

Fixes bug where integer overflows if gtoplevelsof, ntop(-#) is requested.

gtools-0.10.1 (2017-11-08)

Features

gquantiles is a fast alternative to _pctile, pctile, and xtile with several additional features.
fasterxtile is an alias for gquantiles, xtile

Bug fixes

Fixes #27
Fixed numerical precision issue with quantiles. Now ((ST_double) N / 100) is computed first.

gtools-0.9.4 (2017-11-03)

Bug fixes

Fixes #26 so that hashsort sets sortedby to the outermost levels that are positive (e.g. foreign -rep78 sets sortedby to foreign).

Backwards Incompatible

Apparentlly gen in gsort was intuitively specified, so I have now made gen mirror that in hashsort. Previous versions offered this functionality via group.

gtools-0.9.3 (2017-11-02)

Bug fixes

Major bug in gisid: False positive when there was a duplicate row with multiple variable levels but data was otherwise sorted.

gtools-0.9.2 (2017-11-02)

Bug fixes

Previous commit had a corrupted binary for the OSX plugin.

Backwards Incompatible

Option benchmark is no longer abbreviated with b and MUST be abbreviated as bench. This is to ensure consistency with options bench(0), bench(1) and bench(2). bench(1) is the same as benchmark. bench(2) additionally shows benchmarks for various internal plugin steps. bench(0) is the same as not including benchmark.

Enhancements

Improved online docs: Now each example is available as raw code (each example page points to it) and inline monospaced code should be slightly bigger, improving readability.

gtools-0.9.1 (2017-11-01)

Stability improvements.
Commands should be faster when data is sorted (skips hash sorting if data is already sorted).
Misc bug fixes.

gtools-0.9.0 (2017-11-01)

Features

The plugin now works on OSX
gcontract is a fast alternative to contrast
gtoplevelsof is a new command that allows the user to glean the most common levels of a set of variables. Similar to gcontract with a gsort of frequency by descending order thereafter, but gtoplevelsof does not modify the source data and saves a matrix with the results after its run.
gdistinct now saves its results to a matrix when there are multiple variables.
Improved and normalized documentation

Bug fixes

OSX version; fixes #11
gisid now sient w/o benchmark or verbose; fixes #20
Added quotes to cd cwd in gtools; fixes #22
gcontract available; fixes #23

gtools-0.8.5 (2017-10-30)

Features

gcollapse, freq() stores frequency count in variable. Same as gen long freq = 1 and then (sum) freq.
Hashsort is marginally faster (sortindex inversion now done internally in C).

gtools-0.8.4 (2017-10-29)

Enhancements

Normalized types in the C base to ensure I have 64-bit integers (signed and unsigned) as well as ST_doubles all around.
Bijection limit is now limit on signed 64-bit integers.

gtools-0.8.3 (2017-10-28)

Features

gisid includes an internal check to see if the data is sorted. This means that if there are two duplicate rows in unsorted data or if the data is already sorted, gisid will give a result much faster. However, if the data is not sorted it will be marginally slower as it will execute the rest of the code normally.

Backwards Incompatible

gisid and hashsort are no longer rclass. Both will exit early if the data is already sorted, and gisid will also exit if it finds a duplicate row during the sorted check. Hence they will not always store results, making them inconsistent. It would be bad practice to continue to have them store rclass results.

Enhancements

Cleaned up the C base somewhat. Improved modularity.
All int were changed to size_t or int64_t as applicable, since int is not necessarily aliased to a 64-bit integer on all platforms.

gtools-0.8.2 (2017-10-26)

Features

gdistinct is a replacement for distinct. It is functionally identical to gunique except it mimics the output format of distinct.

gtools-0.8.1 (2017-10-26)

Backwards Incompatible

merge now merges labels and formats by default

Bug fixes

Fxied examples in README; fixed minor typos in README
gegen now handles the type of pctile correctly.

gtools-0.8.0 (2017-10-19)

Features

Refactored code base for somewhat faster runtime, but mainly for bug fixes and ease of maintenance.
gcollapse, gegen, glevelsof, gisid, gunique, hashsort all call the function _gtools_internal, which then calls the plugin.
gcollapse includes a target labeling engine.
gcollapse now supports semean, sebinomial, and sepoisson.
gegen will take (almost) any egen function. If it is not implemented by gtools it will simply use hashsort and then call egen.
Windows and Linux versions passing tests, OSX version should be feasible.

Bug fixes

Fixes #19
Fixes #18
Fixes #11

gtools-0.7.5 (2017-10-08)

Features

Updated benchmarks for new commands, all in Stata/MP.
Added counts option (with fill) to gegen group. fill can be a number, group to fill in the counts normally, or data to fill in the first J_th_ observations.
The number of groups is now stored in r(J), along with other useful meta stats.

gtools-0.7.4 (2017-09-29)

Features

hashsort is added as a working replacement for sort and gsort. The sort is always stable. mfirst is not allowed.

gtools-0.7.2 (2017-09-28)

Features

gisid is added as a working replacement for isid and isid, missok. gisid taks if and in statements; however, it does not implement isid, sort or isid using.
glevelsof is added as a working replacement for levelsof. All levelsof features are available.

Enhancements

Fixes #13 so gcollapse maintains source formats on targets.
Improved internal handling of if conditions for egen.

Bug fixes

Prior versions de-facto used a 64-bit hash instead of a 128-bit hash. The new version should use the 128-bit hash correctly.
Prior versions would fail if there was only 1 observation.

gtools-0.7.1 (2017-09-27)

Enhancements

egen now only processes observations in range for id, group
egen, group now marginally faster when all vars are integers

gtools-0.7.0 (2017-09-26)

Enhancements

Temporary variable no longer created for egen, tag or egen, group
Fixes #6
- Variables are sorted internally for egen, group, which matches egen.
- Variables are sorted internally for gcollapse, which is faster.
Various internal enhancements:
- The hash is validated faster
- Hash validation is also used to read in group variables
- Integer bijection now sorts by the integers correctly, obviating the need for a second sort.
- No need to validate the hash with integer bijection.
- The memory usage is marginally leaner.
- Reorganized all the files, making the code-base easier to maintain.
Various commented internal code deleted.

Backwards-incompatible

gcollapse, unsorted no longer supported (due to internal sorting)

gtools-0.6.17 (2017-09-17); fixes #15

Bug fixes

Fixes #15 which was introduced trying to fix #15

gtools-0.6.16 (2017-09-13); addresses #7

Bug fixes

Improves the issues raised by #7 Now the commands only fail if Stata hits the matsize limit (internally, the plugin no longer uses the subinstr hack to go from locals to mata string matrices and uses tokens instead, which is more appropriate; further, the plugin tries to set matsize to at least the number of variables and gives a verbose error if it fails.)

gtools-0.6.15 (2017-09-12); fixes #14, #9

Bug fixes

Fixes #14
Fixes #9 (prior fixes were erratic; this should work)

gtools-0.6.14 (2017-09-12)

Bug fixes

No longer crashes on Linux systems with older glibc versions.

gtools-0.6.13 (2017-09-12)

Bug fixes

Should fix #9 Added legacy plugin using older libgomp.so library.

gtools-0.6.12 (2017-09-11)

Bug fixes

Should fix #12

gtools-0.6.11 (2017-08-17)

Bug fixes

Fixed #8 so gegen is callable via by:; it also gives the stat for the overall group if called without a by.

gtools-0.6.10 (2017-06-27)

Bug fixes

When fixing issue #5 I introduced a bug. This is fixed.

gtools-0.6.9 (2017-06-27)

Enhancements

Addressed the possible issue noted in issue #3 and the functions now use mata and extended macro functions as applicable.
gegen varname = group(varlist) no longer has holes, as noted in issue #4
gegen and gcollapse fall back on collapse and egen in case there is a collision. Future releases will implement an internal way to resolve collisions. This is not a huge concern, as SpookyHash has no known vulnerabilities (I believe the concern raied in issue #2 was base on a typo; see here) and the probability of a collision is very low.
gegen varname = group(varlist) now has a consistency test (though the group IDs are not the same as egen's, they should map to the egen group IDs 1 to 1, which is what the tests now check for).

Bug fixes

gegen no longer ignores unavailable options, as noted in issue #4, and now it throws an error.
gegen varname = tag(varlist) no longer tags missing values, as noted in issue #5
Additional fixes for issue #1
Apparentlly the argument Stata passes to plugins have a maximum length. The code now makes sure chuncks are passed when the PATH length will exceed the maximum. The plugin later concatenates the chuncks to set the PATH correctly.

gtools-0.6.8 (2017-06-25)

Bug fixes

Fixed issue #1
The problem was that the wrapper I wrote to print to the Stata console has a maximum buffer size; when it tries to print the new PATH it encounters an error when the string is longer than the allocated size. Since printing this is unnecessary and will only ever be used for debugging, I no longer print the PATH.

gtools-0.6.7 (2017-06-18)

Debugging

Debugging issue #1 on github (in particular, env_set on Windows).

gtools-0.6.6 (2017-06-18)

Bug fixes

Removed old debugging code that had been left uncommented
Improved out-of-memory message (now links to relevant help section).

gtools-0.6.5 (2017-06-18)

Features

The function now checks numerical variabes to see if they are integers. Working with integers is faster than hashing.
The function is now smarter about generating targets. In prior versions, when the target statistic was a sum the function would force the target type to be double. Now if the source already exists and is a float, the function now checks if the resultimg sum would overflow. It will only recast the source as double for collapsing if the sum might overflow, that is, if _N * min < -10^38 or 10^38 < _N * max (note +/- 10^38 are the largest/smallest floats stata can represent; see help data_types).

Bug fixes

Fixed bug where Stata crashes when it can no longer allocate memory. It now exists with error.
In Windows, gcollapse and gegen now check whether spookyhash.dll can be found before trying to modify the PATH environment variable.

gtools-0.6.4 (2017-06-18)

Bug fixes

On windows, when all variables are numeric and the second variable is constant, there used to be a division by 0 crash. This was fixed.

gtools-0.6.3 (2017-06-18)

Bug fixes

Forgot to provide OS-specific versions of env_set as well...
Linux and Windows versions passing from github.

gtools-0.6.2 (2017-06-18)

Bug fixes

Forgot to commit new files in ./build

gtools-0.6.1 (2017-06-17)

Bug fixes

Program now installs correctly from build folder on Windows. I had to add the assumed spookyhash.dll path to the system PATH at eacah run. I also provide a gtools.ado file that allows the user to troubleshoot some possible issues that may arise.

Misc

Tried and failed to compile on OSX using Travis, but cleaned it up enough that it will be easier to compile once I get access to OSX, if ever. Windows version still OK.

gtools-0.6.0 (2017-06-16)

Features

Windows version passing all tests; benchmarked on virtualbox.

Bug fixes

gegen tag() now gives the correct result when there are no obs that match the tag (e.g. all missing). Previous versions returned all missing values. The new version returns all 0s, matching egen.

Known problems

The multi-threaded version does not load on Windows. Getting this to work on Windows was painful enough that I have 0 plans to debug it at this time. The single-threaded version works fine, however, and is already plenty fast.
The marginal time to add a variable to memory is non-linear. If there are 100 variables in memory, adding the 101th varaible will take longer than if there are 0 variables in memory and we are adding the first one. This is problematic because we try to estimate the time by benchmarking adding two variables. The non-linear relation is not obvious as it would depend on the user's system's RAM and CPU. Hence we simply scale the benchmark by K / 2.
Stata's timer feature is only accurate up to miliseconds. Since adding the two variables for benchmarking is faster than adding marginal variables thereafter, occasionally Stata incorrectly estimates the time to add a variable to be 0 seconds. Empirically it does not bear out that adding variables after the benchmark variables takes more than 0 seconds. Hence we assume that Stata would actually take 0.001 seconds to add 2 variables to memory.

Planned

Sort variables in C, not in Stata (high priority; performance)
Allow merge with an if statement (low priority; feature).
If you sort the data in C, then assert the sort is unique and print "(hashed correctly grouped observations: resulting sort is unique)"
Allow greedy option to skip drops and recasting? (Depending on the implementation this may be slower because adding variables takes longer with more variables in memory.)

gtools-0.5.2 (2017-06-15)

Misc

Added Travis CI integration.
Improved README (logo, cleaner flow, better compilation instructions).

Bug fixes

Properly added spookyhash as submodule.
Compiles with Travis CI

gtools-0.5.1 (2017-06-14)

Bug fixes

In prior versions, if gcollapse was called with no observations or when the result of if in gave no observations, the function throwed an error. Now the program exits and prints "no observations" to the console (gcollapse returns an empty data set; gegen returns a variable with all missing values).
In prior versions, in some cases, when multiple statistics are generated from a single source and the summary statistics are collapsed to disk, the first statistic may be swapped for another. This happened because the function tries to use source variables and targets, and it also tries to be smart about which target statistic to use the source variable for. So if you request mean and min for a byte, the function will want outputs to be at least float and byte, and will use the source variable for the min and generate an additional variable for the mean. This had been implemented incorrectly when collapsing to disk.
Added additional unit tests for collapsing to disk.

gtools-0.5.0 (2017-06-14)

Features

The function tries to be smarter Be smart about memory management. When merge is not specified, N is larger than 1M, and there are more than 3 additional targets to create in memory, the function tries to figure out whether collapsing the data and writing the collapsed data for the extra targets to disk is faster than creating the targets in memory and collapsing to memory.

While collapsing to memory is faster than collapsing to disk, generating variables in memory with N observations, before collapsing, is slower than for J observations, after collapsing. For J small enough (e.g. 10 groups vs 1M observations) it is more efficient to collapse to disk and read the data back in after. The rules
- merge merges back to the original data, so we do not collapse to disk.
- forceio forces the function to collapse to disk.
- forcemem forces the function to collapse to memory.
- Otherwise, if N > 1M and the number of variables to add is K > 3, the function benchmarks how long it would take C to write and read K * 8 * J / 1024^2 MiB and then creating K variables in memory for J observations vs creating K variables for N observations.
- Creating observations is memory is given the "benefit of the doubt" by a factor of 10. So we have to estimate writing to disk and creating variables after the collapse will be at least 10 times faster for the swtich to take place.
String by variables are now read into C and written back into Stata directly. Prior versions generated temporary variables to read string by variables into the temporary variables and then copied them back. This was inefficient.
Moved away from using regexes in C code. Now the function just passes the quantile as a string directly from Stata and uses atof. This is marginally faster and eliminates a dependency.

Backwards-incompatible

All undocumented mf_ options have been changed to debug_

Bug fixes

Option debug_checkhash seems to work properly now. This was fixed by zero-ing the string that was used as the temporary buffer for reading in Stata variables.

Known problems

The marginal time to add a variable to memory is non-linear. If there are 100 variables in memory, adding the 101th varaible will take longer than if there are 0 variables in memory and we are adding the first one.
This is problematic because we try to estimate the time by benchmarking adding two variables. The non-linear relation is not obvious as it would depend on the user's system's RAM and CPU. Hence we simply scale the benchmark by K / 2.
Stata's timer feature is only accurate up to miliseconds. Since adding the two variables for benchmarking is faster than adding marginal variables thereafter, occasionally Stata incorrectly estimates the time to add a variable to be 0 seconds. Empirically it does not bear out that adding variables after the benchmark variables takes more than 0 seconds. Hence we assume that Stata would actually take 0.001 seconds to add 2 variables to memory.

Planned

Allow greedy option to skip drops and recasting? (Depending on the implementation this may be slower because adding variables takes longer with more variables in memory.)
Sort variables in C, not in Stata (high priority; performance)
Allow merge with an if statement (low priority; feature).
If you sort the data in C, then assert the sort is unique and print "(hashed correctly grouped observations: resulting sort is unique)"

gtools-0.4.1 (2017-05-29)

Bug fixes

gegen now generates the expression passed to its functions if the argument is not a varlist.

gtools-0.4.0 (2017-05-23)

Features

Somewhat faster: The function tries to choose the multi-threaded version of the plugin when available, and non-multi otherwise. It is also smarter about recasting variables.
Various undocumented options to test and benchmark different algorithms for reading and collapsing the data.

Bug fixes

gegen now computes the first and last non-missing observations correctly when there is an if statement involved in the call.
gcollapse|gegen now correctly finds first and last when there are missing values.
gcollapse|gegen now correctly populates firstnm and lastnm with missing values when all observations are missing.
gcollapse|gegen now output the sum as 0 of all missing values to mimic collapse.
benchmark now correctly times parallel execution.

Known problems

gcollapse does not work correctly with merge when the user asks for an if statement, so when it is tried the function exits with error.
Checkhash may give false positives when checking strings. It will occasionally read more data than necessary to make the comparison, resulting in a false positive. Working on a fix, but for now I moved the function to be undocumented, mf_checkhash

Misc

Updated benchmarks
Cleaned up method for reading data in from Stata. Kept the sequential and the out-of-order methods (parallel out of order for the multi-threaded version).
Normalized method of reading data from Stata in gegen.
Added some undocumented options to control what is executed in parallel and what isn't when running with multi.

Planned

Allow merge with an if statement (low priority; feature).
Sort variables in C, not in Stata (high priority; performance)
If you sort the data in C, then assert the sort is unique and print "(hashed correctly grouped observations: resulting sort is unique)"
Be smart about memory management when J is small relative to N.

gtools-0.3.3 (2017-05-21)

Features

Significantly sped up integer-only hash by computing the ranges in C, not in Stata.
Data is now read sequentially from Stata. More extensive testing revealed this is usually faster.
In the multi-threaded version, data is read in parallel. More extensive testing revealed this is usually faster.

Planned

Decide on a method to read in variables from stata; implement across all single and multi-threaded versions.

gtools-0.3.2 (2017-05-20)

Features

Added checkhash option to check for hash collisions.

Bug fixes

Finished the benchmarks, both locally (IC) and on the server (MP)
Normalized the execution of gegen and gegen, multi

Misc

Tested reading data from Stata sequentially (it's not faster)
Improved README
Various typo fixes in comments

gtools-0.3.1 (2017-05-19)

Bug fixes

Speed up quantiles! (Also, all other functions). Encoded stat string to numeric: It's WAY faster to select a function based on a number than a string. String comparisons are expensive. I was also parsing the quantile string at EVERY function call, which was the bottleneck in computing quantiles, not quicksort.
first and last observations now computed correctly when quantiles are also requested.
Fixed gtools.pkg
Added documentation for gegen
Function names and calls closer to egen

gtools-0.3.0 (2017-05-19)

Features

gegen implementation with all of gcollapse's functions, as well as total as an alias for sum, group to generate an id for a given group, and tag to tag the first observation in a given group.
if and in are correctly supported in gegen.
Both gegen and gcollapse have multi-threaded versions.
Note gegen newvar = group(varlist) tags the first appearance of a group as 1, and so on. egen sorts the data, so the group taged as 1 is the 'first' group, and so on. If you want that behavior you should use egen; gegen is only suitable when you want to index the data and you don't mind that it won't be sorted right away.

Bug fixes

Fixed bug in hashing strings so it now passes the correct number of bytes to the spooky hash (in prior versions, string hashes were not consistent).
Fixed bug in integer bijection so it can now handle missing values.
Fixed bug in quantile function where the first comparison element was selected to be the first entry read from Stata, not the first group entry.

Problems

Only available when c(os) is Unix.
Memory management is terrible. See previous notes or README.md section on memory management.
Several by-able egen functions are missing
Not provided
- semean
- sebinomial
- sepoisson
- rawsum

Planned

checkmem feature to call fcollapse or collapse when the plugin suspects there will not be enough memory.
The rest of gegen's by-able functions
Improve memory management.

gtools-0.2.0 (2017-05-19)

Features

gcollapse smart option indexes the data based on the sorted groups so no hashing and sorting is necessary. It no longer calls collapse, which is slower.
gcollapse provides merge to merge the collapsed data back with the original data. This is much fastere than collapsing and then merging.
gcollapse provides multi to invoke the multi-threaded version of the collapse routine.
Computing percentiles is less inefficient, but it is still inefficient. When this is particularly slow, the multi option can compensate.
The code base is cleaner and the C code is (mostly) commented.

Problems

Only available when c(os) is Unix.
Memory management is terrible. See previous notes or README.md section on memory management.
Not provided
- semean
- sebinomial
- sepoisson
- rawsum

Planned

checkmem feature to call fcollapse or collapse when the plugin suspects there will not be enough memory.
gegen as a drop-in replacement for egen's by-able functions that should be faster than fegen.
Improve memory management.

gtools-0.1.0 (2017-05-16)

Features

gcollapse provides a C-based near-drop-in replacement for collapse that is (almost always) several times faster than fcollapse.
Though computing percentiles is currently very inefficient (see below), gcollapse, unlike collapse (or fcollapse as best I can tell) can compute quantiles, not just percentiles (e.g. p2.5, p15.25)

Problems

Only available c(os) is Unix.
Quantile implementation is massively inefficient (via C's qsort). In fact, it it possible that fcollapse will be ~50% faster if there are many levels/sgroups (hundreds of thousands or millions) and more than a few percentiles (3 or more).
Memory management is terrible. fcollapse does not consume too much more memory than collapse because mata can add and drop variables at requisite times. C, on the other hand, cannot add or drop variables in Stata, and target variables must already exit. This means that for every additional summary variable (i.e. 2 or more) based on a single source variable, Stata must create them before collapsing the data. Thus it is possible that systems that run collapse or fcollapse with ease are not able to run gcollapse due to the additional memory overhead. See the memory management section in README.md to estimate whether your system will be able to take advantage of the speed improvements of gcollapse if you are concerned about memory management.
Not provided
- semean
- sebinomial
- sepoisson
- rawsum

Planned

gegen as a drop-in replacement for egen's by-able functions that should be faster than fegen.
Improve quantile implementation (perhaps using a better implementation of quickselect; my attempt at implementing quickselect was slowe than qsort).
Improve memory management.

Files

changelog.md

Latest commit

History

changelog.md

File metadata and controls

Change Log

gtools-1.11.8 (2024-06-28)

Features

gtools-1.11.7 (2023-11-08)

Bug fixes

gtools-1.11.6 (2023-11-08)

Bug fixes

gtools-1.11.5 (2023-10-27)

Bug fixes

gtools-1.11.4 (2023-10-24)

Features

gtools-1.11.3 (2023-09-20)

Bug fixes

gtools-1.11.2 (2023-08-27)

Bug fixes

gtools-1.11.1 (2023-04-03)

Bug fixes

gtools-1.11.0 (2023-03-24)

Features

gtools-1.10.2 (2023-02-21)

Features

gtools-1.10.1 (2022-12-05)

Bug fixes

gtools-1.10.0 (2022-12-04)

Features

Enhancements

Bug fixes

gtools-1.9.2 (2022-09-22)

Bug fixes

Features

gtools-1.9.1 (2022-03-28)

Features

gtools-1.9.0 (2022-03-14)

Features

gtools-1.8.4 (2022-02-02)

Enhancements

Bug Fixes

gtools-1.8.3 (2021-11-03)

Bug Fixes

gtools-1.8.2 (2021-08-29)

Features

Bug Fixes

gtools-1.8.1 (2021-08-27)

Bug Fixes

gtools-1.8.0 (2021-06-15)

Features

gtools-1.7.5 (2020-04-18)

Bug fixes

gtools-1.7.4 (2020-04-14)

Enhancements

Bug fixes

gtools-1.7.3 (2020-01-30)

Bug fixes

gtools-1.7.2 (2020-01-26)

Features

Enhancements

gtools-1.7.1 (2020-01-26)

Bug Fixes

gtools-1.7.0 (2020-01-24)

Enhancements

Features

gtools-1.6.4 (2019-09-14)

Enhancements

gtools-1.6.3 (2019-09-08)

Features

Bug fixes

Enhancements

gtools-1.6.2 (2019-08-25)

Features

Bug fixes

Enhancements

gtools-1.6.1 (2019-08-21)

Features

Bug fixes