Hi. Wondering if anyone can point me toward how to get Gretl to do the equivalent of STATA's collapse command. For example, I have a data set with about 1,000 observations with YEAR X2 and X3 (where YEAR is an integer with values from 1760 to 1880). I want to get a data set that is the count and average of X2 by YEAR. In STATA I write
collapse (count) num2=X2 (mean) avg2=X2, by(YEAR) and I get a data set with that is YEAR and counts and means of the variable X2 for each year. >From what I've seen of Gretl it seems this should be a trivial exercise but I seem to be stumped. Thanks for your consideration. -- jim irwin (economic historian, trying to migrate from STATA).
