Means per multiple variables and multiple observations, with missing values

[Mink Sjamsoedin]

Dear Statalist,

I am very new to STATA and Statalist, so please forgive me if in some way my question is unclear.


I am using STATA17 and want to calculate the means, standard deviations and p-values of a dataset combining multiple variables and multiple observations with missing values in between.

I have conducted a survey, for which participants were asked to rate achievement, on a 5-item Likert scale with "0" as the option for "not applicable", for 47 criteria (my variables). I have recoded for "0" to be missing values and now I would like to calculate means for subgroups, combining the multiple variables. I have familiarized myself with

mean()

and

rmean()

and

rowtotal()

But how can I get a mean (with weighted missing values) for both rows and columns combined in STATA? I can do it by hand (or calculator) but would like to get the additional information on standard deviation and p-value.

Thank you in advance for your advise.

Kind regards,
Mink Sjamsoedin