dtable and Specifying Non-Missing Values in the Table

[Ali Abutaleb]

Hi there - for dtable, is it possible to specify non- missing values only to produce the summary table ?

I have a two-way summary table wherein most variable has missing value, but I do not need to count of those missing value to be included in summary statistic.

I tried to use

dtable v1 v2 v3 , by(group,  nomissing ) sample(,  place(seplabels)) sformat("(N=%s)" frequency) nformat(%7.2f mean sd) title(Table 1. Descriptive statistics) note(Mean (Standard deviation)) export(table1.docx, replace)

but this gave me error "option by not allowed
in option by()"


could anyone help with that ?


Thanks,
Ali