Translation from Narrative Text to Standard Codes Variables with Stata

20 Pages Posted: 14 Jul 2009 Last revised: 3 Sep 2009

See all articles by Federico Belotti

Federico Belotti

University of Rome Tor Vergata - Department of Economics and Finance; University of Rome, Tor Vergata - Centre for Economics and International Studies (CEIS)

Domenico Depalo

Bank of Italy; Bank of Italy

Date Written: July 10, 2009

Abstract

This paper describes screening, a new Stata command for data-management that can be used to examine the content of complex narrative text variables to identify one or more user-defined keywords. Thus the command is particularly useful to deal with string data type contaminated with abbreviations and/or mistakes. Although the main duty of screening is identification, a rich set of options allow a direct translation from the original narrative string to a user-defined standard coding scheme. Moreover the command is flexible enough to facilitate the merging of information from different sources and to extract substring from the desired variable.

Keywords: screening, keyword-matching, narrative text variables, standard coding schemes

JEL Classification: C81, C87, C88

Suggested Citation

Belotti, Federico and Depalo, Domenico and Depalo, Domenico, Translation from Narrative Text to Standard Codes Variables with Stata (July 10, 2009). Available at SSRN: https://ssrn.com/abstract=1432499 or http://dx.doi.org/10.2139/ssrn.1432499

Federico Belotti

University of Rome Tor Vergata - Department of Economics and Finance

Via Columbia 2
Rome, RM 00133
Italy

University of Rome, Tor Vergata - Centre for Economics and International Studies (CEIS) ( email )

Via Columbia, 2
Rome, RM 00133
Italy

Domenico Depalo (Contact Author)

Bank of Italy ( email )

Via Nazionale 91
00184 Roma
Italy

Bank of Italy ( email )

Via Nazionale 91
Rome, 00184
Italy

Do you have negative results from your research you’d like to share?

Paper statistics

Downloads
178
Abstract Views
1,354
Rank
305,000
PlumX Metrics