I am trying to work with json file. I have a folder which contains 16k json files and I need to
1. import the json file with stata
2. creating a column which will contains the title of json file
3. append
The final dataset will be one dta file with all json files appended.
Of course it needs a loop, nevertheless I'm struggling to understand how to implement it.
Do you have any suggestion?
Below, an example of how the json file looks like
1. import the json file with stata
2. creating a column which will contains the title of json file
3. append
The final dataset will be one dta file with all json files appended.
Of course it needs a loop, nevertheless I'm struggling to understand how to implement it.
Do you have any suggestion?
Below, an example of how the json file looks like
