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.
generate t-statHow can we modify this code to generate t-stat of the means instead of standard deviation (sd), and …
spatial weight matrixHello, As part of my research, I want to build a spatial weight matrix. I want a variable that shows…
How to store p-value and CI in a new variable in prais-winsten regression?Hi! I'm new to Stata! I have a database model as shown below (hypothetical data). When running Prai…
Transform a table: making options as variableDear all, I have this type of table: ID Date Culture ID Culture type Sample result 1 1 Jan 202…
Assuming ICCHello everyone, This is my first post here. I need icc for power calculation. I have outcome variabl…
Subscribe to:
Post Comments (Atom)
0 Response to import many files and generate an `id' variable as the file name.
Post a Comment