BJ Data Tech Solution

Specialized on Data processing, Data management Implementation plan, Data Collection tools - electronic and paper base, Data cleaning specifications, Data extraction, Data transformation, Data load, Analytical Datasets, and Data analysis. BJ Data Tech Solutions teaches on design and developing Electronic Data Collection Tools using CSPro, and STATA commands for data manipulation. Setting up Data Management systems using modern data technologies such as Relational Databases, C#, PHP and Android.

Making the first row become Variable Names and Transposing the data
Making the first row become Variable Names and Transposing the data

Hello,

How can I make the first row of observations become the Variable name?

I would also like to have the data in a panel format (altough it's only for one country), therefore, how could I transpose this to a panel?

Code:

* Example generated by -dataex-. To install: ssc install dataex
clear
input str52 A str12 B str37 C str14 D str18 E str17(F BJ)
"Country Name" "Country Code" "Indicator Name"                        "Indicator Code" "1960"             "1961"             "2017"            
"Italy"        "ITA"          "Inflation, consumer prices (annual %)" "FP.CPI.TOTL.ZG" "2.35016141377048" "2.05069731278691" "1.22653316645808"
end

BJ Data Tech Solution

Home / Data Cleaning / Data management / Data Processing / Making the first row become Variable Names and Transposing the data
Making the first row become Variable Names and Transposing the data

0 Response to Making the first row become Variable Names and Transposing the data

Post a Comment

Home / Data Cleaning / Data management / Data Processing / Making the first row become Variable Names and Transposing the data Making the first row become Variable Names and Transposing the data

0 Response to Making the first row become Variable Names and Transposing the data