CODEWITHSUNDEEP
for-loopstatalocalstata-macros
user17558
user17558

Reputation: 1

Including a variable local macro inside a loop

Using a forvalues loop, I am merging a list of 400 individual datasets.

These datasets can be one of 10 distinct values (defined by a variable in the dataset): depending on the dataset, I would merge with a different dataset. For example, if Player 90 was type 9, I would want to merge with Type_9.dta rather than Type_8 or Type_7.

What I want is something like this:

forvalues x = 1/400 {
    use "player_`x'.dta"

    * some way to turn the value of player type into a local macro l *

    merge 1:1 using "type_`l'.dta"
}

How can i get the variable type into a macro that changes for each type through the loop?

Upvotes: 0

Views: 626

Answers (1)

dimitriy
dimitriy

Reputation: 9470

The structure of your data and the ultimate goal are not quite clear to me, so there may be more efficient ways to do that.

If player_type does not vary within each player_* data set, you can use levelsof. This has the feature that if player_type varies for some reason like a data entry error, the loop will error out.

forvalues x = 1/400 { 
   use "player_`x'.dta"
   levelsof player_type, local(l)
   merge 1:1 **some_id_var** using "type_`l'.dta" 
}

Upvotes: 1

Related Questions