reshape data

  1. M

    Repeated measures ANOVA- reshape data?

    I assessed HIV knowledge at pre, post and follow examinations. It was the same exam 14 items for pre, post and follow-up. Also The same participants completed pre,post and folow up. My data is in wide format. If i want to do a repeated measure ANOVA (this was suggested to me), do I have to...
  2. P

    Reshape to long: how to prepare data?

    Hi, I really need your help. I'm new to Stata so it might be easy to answer for you guys... I have an excel sheet that lists stock prices for specific firms (about 800) on each trading day for 10 years. Firms (coded by their German stock exchange code) are arranged in ROW and dates in COLUMN...
  3. M

    reshape wide

    Hi everyone, I am struggling with the shape wide command because in my dataset I have for each subject (variable: ID) several observations (variable TIME: 1,2,3,n). The problem is that subjects have a variable number of observations (ID=1, TIME= 1, 2, 3; if ID=2, TIME=1, 2, 3, 4, 5). So when...
  4. S

    Long to wide

    Hey guys. I''ve finally gathered the last of the data I need to do some longitudinal research but then I hit a snag. As far as I know, my data is on long format and someone told me, that it needs to be in wide format. Now I just have one variable for year, one for country (dummy) and then a...
  5. C

    Reshaping dataset

    Hi, I have a dataset that has the following variables: date stock1 stock2 stock3 etc. where the stockprices are recorded for each stock at each date for 300 dates. But what I want is to reshape the data in stata such that I get date and then a variable prices where each stock...
  6. P

    Complicated Hierarchical Data: Reshaping or Looping?

    Hello Stata Wizards, hope one of you can help me with my problem. I have hierarchical data that is a little complicated: I want to try and reshape. Office_ID and Branch names are corresponding. Employee_ID is unique for every employee. The Account_ID often has multiple entries for...