How to export bootstrap results for each iteration in excel?

[Anna Bayne]

Dear all,
I am running a multilevel mediation analysis in Stata using the ml_mediation and xtmixed commands. I would like to store the results of each bootstrap iteration in an excel sheet in order to use Edwarts and Lambert's (2007) technique to assess multilevel moderated mediation. I already searched the internet and forum, but somehow I cannot find an answer.

Your help is highly appreciated!
Kind regards,
Anna Bayne

[Carlo Lazzaro]

Anna:
welcome to the list.
You can save your bootstrap results on a .dta file and then use -export excel- (type -help export excel- to get an insight of that command).

[Anna Bayne]

Dear Carlo,
thank you very much for your warm welcome.
It might be a stupid question, but somehow I am not able to find out. How exactly do I save the bootstrap results as a .dta file? My multilevel syntax would be something like:
bootstrap, reps(1000): xtmixed m x w z|| identifier:

Would I need to add the saving command and _b? Where would I do that?
Your help is highly appreciated.
Kind regards,
Anna

[Carlo Lazzaro]

Anna:
it should be something like:

bootstrap, reps(1000) saving(Anna_file) : xtmixed m x w z|| identifier:

[Anna Bayne]

Dear Carlo,
thank you very much, it worked out perfectly!
Anna