I am using "local" in STATA to list out all the names I'm gonna use in the loop that followed. The code will be very long because I have so many names. All these names are in an Excel file and I want to load them after local command, to save time. How can I do that?
And the Excel file is like this:
I read from Stata Help that I can use "macro" command with "adosubdir". Is it right?
Code:
local LetterList A B C D E F...... /// (too long) foreach Letter of local LetterList {...}
Letter | X | Y |
A | ... | ... |
B | ||
C | ||
D | ||
... |
Comment