Hi everyone,
I have the following issue. In one folder, I have stored different xlsx files. Each files corresponds to an identifier and it is repeated four times. Below you have a screenshoot, just to give you a snapshot:
Array
As you can see, each identifier is repeated 4 items with label _1 _2 _3 _4.
What I need to do with Stata is to list each unique idenfitier that starts with "GB" letters, then I have to copy and paste these identifiers for another type of work. The critical point is that, in order to be included in my sample, each identifier must have all _1 _2 _3 _4 files. If, for instance, one identifier is missing _2 or _1, it has not to be included in my list.
I'm wondering whether this can be feasible and effeciently done with STATA.
Would you be so kind to help me?
Many thanks in advance
Related Posts with Searching distinct identifier in a folder
Merge weekly and daily dataHi everyone, I am new here so I will try my best to make my question as clear as possible. Hope you …
how do i match two colums with different patterns of city namesHi, I want to match 2 columns with different patterns of city names (not sorted, no similar observa…
Cross-sectional regressionHello guys, I was wondering if anyone had experience with such regressions. I have a panel data. W…
Population size smaller than number of observation, svysetDear Stata users, After applying svyset command to dataset with weights included in the dataset and…
Hierarchical Cluster Analysis (Centroid Linkage): currently can't handle dendrogram reversalsHello Everyone, I am having an issue displaying a hierarchical cluster analysis dendrogram using ce…
Subscribe to:
Post Comments (Atom)
0 Response to Searching distinct identifier in a folder
Post a Comment