[Felix Stips]

Dear Ngozi,

probably you have figured out by now, but there are potentially two problems in post #14:
1. the code should be splitted into two lines
2. if you specify the option excel, then it should also be saved as an excel format

Best,
Felix

[Emma Obed]

I found a different approach to export the correlation table.
Code:

---

* Set the data as time series
*Replace 'time_variable' with your actual time variable name
tsset time_variable


* Set directory to save the results
Replace with your desired directory path
cd "C:\Path\To\Your\Directory"

* Perform pairwise correlation and save the results
*Replace file name with your desired file name
asdoc pwcorr var1 var2 var3 var4 var5 var6, star(0.05) title("Correlation Analysis") replace save("Correlation_Results.doc")

---

Here is an example of the code I used.


* Set the data as time series
tsset time

* Set directory to save the results
cd "C:\Users\MyUserName\Downloads\Regression results"

* Model
asdoc pwcorr EU_CPI EU_FI EU_UTIL EU_TRANSP EU_XEDUSD strucB, star(0.05) title(Model 1) replace save(Model1_pwcorr.doc)

---

NB: Remember to change the title and change "replace" to "append" for the second and successive tables you want to export. This will create separate tables in the same document.

I hope this helps.