Completed

Stata reshape data

Job Description:

I'm looking for some help reshaping a data set from wide to long using Stata. In more detail, I need the long data to contain all the observations, and I do not need to rename any of the variables.

I have a civil war dataset that has one entry for each state involved in a civil war. It then has the years (StartYr1 and EndYr1) that each side was involved in the war as columns (CcodeA and CcodeB). I need the data transformed so that I have an observation for each year each state was involved in that war.

So, for the US Civil War from 1861-1865, there is one entry for the United States and the Confederate States of America (paired together). CcodeA is the USA (2). CcodeB is the CSA (-8; missing state code). The StartYr1 date is 1861. The EndYr1 date is 1865. So the one dataset with a single observation for the US Civil War would now have 10 observations, one each for the US in 1861-1865 and one each for the CSA from 1861-1865.

I will also need the code for the data. That's as important to me as the dataset itself.

Skills: Excel, Statistics, Data Processing

About the Client:
( 9 reviews ) San Diego, United States

Project ID: #36304318

Awarded to:

theprowriter50

Dear client! I am interested in your project Stata reshape data I have completed similar papers in the past and can assure you of exceptional and original work within the agreed deadline. I have skills in Excel, Data More

$30 USD in 3 days
(0 Reviews)
0.0

23 freelancers are bidding on average $102 for this job

schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 850 + Projects. I have 6 + years of the experience in same kind of projects. If you More

$180 USD in 3 days
(559 Reviews)
8.5
AccountantArman

"Sir, EXCEL is my specialty and I can perform any complex task in EXCEL. I am an EXCEL VBA and CODING, AUTOMATION, TEMPLATE, REPORTS, FORMULA'S, DASHBOARD in EXCEL Advanced Level Expert. This is my field and I can comp More

$99 USD in 1 day
(243 Reviews)
7.0
simonklemp

Hello Matthew, I hope this message finds you well. I will be able to help you with your project. I read through the description and it sounds like I am just the right person for it. I have the right sk More

$200 USD in 3 days
(24 Reviews)
6.0
mehmoodfaisal61

Hello, I hope you are doing well. I hold a master's degree in Statistics from a renowned university. I have extensive experience in solving statistical problems and I have good command over Stata (please visit my profi More

$200 USD in 7 days
(21 Reviews)
5.7
Zied130

Hello Matthew M., I will work on this project until I get good results and complete all the tasks. I am prepared to handle projects requiring Data Processing, Excel, Statistics skills. Lets connect in chat so that w More

$210 USD in 7 days
(66 Reviews)
5.3
Galata16

----------------- Hey, I'm interested in your project. Please send me a message so that we can discuss more. -------------------------

$60 USD in 5 days
(28 Reviews)
4.6
AmazingEngr76386

My expertise lies in the area of data analysis and reshaping. I specialize in reshaping data from wide to long formats and have experience in both Excel and Stata. My technical approach to this project would involve th More

$140 USD in 7 days
(4 Reviews)
4.3
IMBASANTAKUMAR

Dear Sir, I am writing to propose a project that I believe would be a great fit for my skills and experience. As a freelancer, I have a strong track record of delivering high-quality work on time and within budget, an More

$30 USD in 2 days
(24 Reviews)
3.4
matdotz

Hello, I read through your job description and can work on it. I promise to deliver on a timely manner with good quality, both data and Stata code. Please let me know if you are interested. Than you!

$60 USD in 1 day
(5 Reviews)
3.1
GraphicsFamily15

Please consider me and give me a chance to impress you by my quality services. I read job description and I can do your project. I can even work on urgent basis and complete your project soon. Contact me for more info More

$80 USD in 2 days
(0 Reviews)
0.0
deepakvishwaka10

Hi there, Thanks for posting suitable project as per my skill. I am having 1 yrs similar experience and handled lots of projects. I have reviewed your requirements well and I am ready to start this hand writing and cop More

$100 USD in 6 days
(0 Reviews)
0.0
kiranslatte5

Hello, If you are searching for a person who will do Data entry, Excel, PDF, Word, PowerPoint and Copy typing, then I am here for you. Yes, I am ready to do these jobs for you with sufficient payment cast. So give me a More

$30 USD in 7 days
(0 Reviews)
0.0
ayaankhilji758

Hello sir my name is . ayaan i am good in data entry and i am do good work i have also jobs in this field and i have 1 year of thanks

$140 USD in 7 days
(0 Reviews)
0.0
sajidrafiq94

I can do this project. I have great experience in ms Office. I'm new here but had lot of experience

$140 USD in 7 days
(0 Reviews)
0.0
Mharkit

hello I am a freelancer, i can do yor project well and fast , i worked before data entry finical-accountant-kepper store and I can make finical system for any store, I can design system finical like keeper store and More

$32 USD in 1 day
(1 Review)
0.0
sp6775891

Hello Matthew, I hope this message finds you well. I will be able to help you with your project. I read through the description and it sounds like I am just the right person for it. I have the right skill set with sop More

$40 USD in 7 days
(0 Reviews)
0.0
saffinahmed88

Dear hiring manager. At First, take my respect. I read your project. I have gone through your project description. I understand that skills are needed for this project so I have enough skill on your project. I think I More

$100 USD in 5 days
(0 Reviews)
0.0
farrukhqazi20

I can help you, also provide you with a code which will be helpful for you in future. You may contact me.

$30 USD in 1 day
(0 Reviews)
0.0