sumtable error

[Caroline Clarke]

Hi all,

I am trying to use -sumtable- and I keep getting an error:

. sumtable D_A_Hosp Site, vartype(binary)

file dummy1234 not found
r(601);

Any ideas?

Thanks very much in advance.
Caroline

[Charlie Joyez]

Caroline,
sumtable is a user-written command, so first make sure you have an up to date version. (ssc update sumtable)

In the help file it is written :

A dummy dataset called dummy1234.dta is created and saved in your current directory during use of this command. This dataset is deleted once the last variable has been summarized and the last(1) option has been specified. If you wish to edit the final summary dataset in Stata before exporting it, simply exclude the last(1) option from your code, and then read in dummy1234.dta and edit.

And also


first(1) sets up the temporary dataset that all subsequent summaries are appended to. This option should be specified for the first row of a table (that is, the first time any sumtable code is run for this summary table). Each time this option is specified, the temporary dataset is replaced.

You have to specify the option ,first(1) for the first command launched (to create the dataset dummy1234, the option ,last(1) will erase it, so you'll have to enter ,first(1) afterward again.

So in your case, I guess you can simply do :

sumtable D_A_Hosp Site, vartype(binary) first(1)

Best,
Charlie

[Caroline Clarke]

Hi Charlie, that's done it, thanks very much!

Caroline