+ Reply to Thread
Results 1 to 2 of 2

From excel table to stata time series

  1. #1
    Registered User
    Join Date
    MS-Off Ver

    From excel table to stata time series


    I harvested GDP data (in current prices, constant price and rates) over 70 years (I have downloaded it), by region (and geographic subset - this is not important).

    However, in my table, each year becomes a variable. From there, when I pass it in statistical software, we cannot do time series studies. We cannot even do graphs.

    The software thinks 1970 = variable. No, 1970 is a n in "time", with time going from 1939 to 2012.

    Does someone know what i could do in order to do so that i have a variable "time" ?
    Someone told me that i need something like that: GDP2000, GDP2001, GDP....20xx.

    I don't need to make very sophisticated analysis here, it's more about comparing (but comparing in details).

    thanks a lot !

    Attached Files Attached Files
    Last edited by Ayadin; 06-24-2016 at 05:07 PM.

  2. #2
    Forum Guru shg's Avatar
    Join Date
    The Great State of Texas
    MS-Off Ver
    2003, 2010

    Re: From excel table to stata time series

    I don't think it's clear to anyone what the difficulty is.

    The top row (containing the year numbers) is formatted as Text. You might start by changing that to General.
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Problem with Reshaping Excel data for Stata use.
    By alex54 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-07-2014, 10:56 AM
  2. Replies: 0
    Last Post: 07-18-2013, 09:14 AM
  3. Excel VBA Time Series Graph
    By dsom in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-26-2013, 03:08 AM
  4. Pivot table and time series
    By Arthurv in forum Excel General
    Replies: 1
    Last Post: 01-06-2012, 10:26 AM
  5. Preparing DATE/TIME for STATA use.
    By samsam in forum Excel General
    Replies: 0
    Last Post: 01-31-2011, 01:21 AM
  6. Replies: 1
    Last Post: 07-14-2010, 04:34 PM
  7. Time Series Plot Table
    By lyzias in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 11-22-2009, 04:04 PM

Tags for this Thread


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1