I have a data set looking like this, when fic is not USA, local_markup is missing value. For the missing values, I want to fill them with the value of USA. The local_markup change every year. Please help me. Thanks!
local_markup fyear fic
8745.155 2001 USA
8745.155 2001 USA
8745.155 2001 USA
8745.155 2001 USA
8745.155 2001 USA
8745.155 2001 USA
8745.155 2001 USA
8745.155 2001 USA
2001 CHE
8745.155 2001 USA
2001 CHE
8745.155 2001 USA
2001 JPN
8745.155 2001 USA
Related Posts with spread one number within a group
Annual constant increase rate from monthly data*Dear all! I have some monthly inflation CPI data and wanted to create two new time series. First, t…
How to write a text.file using loops?Hello everyone! I am trying to solve how to write a text.file using loops. I have hit an obstacle an…
difficulty in exporting summary stat using asdocDear members I am trying to export summary stata for my study key variables per country. I want the…
Matching Panel Data to Diff-in-DiffHowdy, Statalisters, I'm trying to create comparison groups to ultimately move into a diff-in-diff e…
Instrument exogeneity tests.Hello Statalists, I had a question relating both to STATA's instrumental variable post-estimation c…
Subscribe to:
Post Comments (Atom)
0 Response to spread one number within a group
Post a Comment