Dear All, Suppose that I have the following 3 files (in fact, about 4,000 similar files). The file name is 1, 2, 4 with extension xlsx. I wish to import each file, then generate an `id' variable with values all equal to the file name 1, 2, and 4, for all observations in the file, respectively. Finally, I need to -append- them together. Any suggestions?
Related Posts with import many files and generate an `id' variable as the file name.
Interpreting Odds RatiosI need advice on the correct interpretation of an odds ratio of an interaction term. Both the mixed…
dependent variable with gap in a panel data with repeated time valuesHello Statalist, I have panel data with repeated time values. The reason is that there are more tha…
Panel Data: Adding/Merging multiple rows with observations to the same dateHello Statalisters! I have a firm-day panel dataset with firms, dates and stock returns. It looks l…
Common Correlated Effects and Serial CorrelationHello everyone, I have the following question related to testing residuals for serial correlation a…
Interpretation of a reference variableGreetings to the wonderful Stata community, I have a question regarding about interpretation of dum…
Subscribe to:
Post Comments (Atom)
0 Response to import many files and generate an `id' variable as the file name.
Post a Comment