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.

Creating number of obs and summing for new variable value
Creating number of obs and summing for new variable value

Hello,
I have data on loans, one loan per observation, each with a zipcode and amount attached as variables .

1.I looking to get the number of observations/loans per zipcode (string) or zipnumber (same value but long).
So I'm looking to have 1 distinct zipcode as an observation and a number of loans for that zip code as a new variable value.

2. I looking to sum the "amount" variable for each zipcode into a new variable.
So I'm looking to get distinct zipcodes for each observation with an amount summed from the "amount" variable.

Thanks,
Tom

BJ Data Tech Solution

Home / Data Cleaning / Data management / Data Processing / Creating number of obs and summing for new variable value
Creating number of obs and summing for new variable value

0 Response to Creating number of obs and summing for new variable value

Post a Comment

Home / Data Cleaning / Data management / Data Processing / Creating number of obs and summing for new variable value Creating number of obs and summing for new variable value

0 Response to Creating number of obs and summing for new variable value