Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • how to download several excel sheet each one represents a year

    hello, am new to Stata thank you for your help in advance. I have the data (around 27 variables) for listed companies in Kuwait for 10 years from 2013 to 2022 . each excel file represent one year. i named the excel files by which year they are representing for example: one file name 2013, 2014, Etc.
    how i can download the 10 excel files into stata and make sure that stata are reading the data as continues years from 2013 to 2022. i already put the 10 excel files in one folder

  • #2
    Cross-posted at https://stackoverflow.com/questions/...-a-data-set-fo

    Comment


    • #3
      Do these excel files have a link that we can directly import them from?

      Comment


      • #4
        I strongly suspect you will need -import excel- (if these are XLS or XLSX files) or else -import delimited- (if this is actually a CSV file). I can't suggest further help based on the limited information, but both commands have easy to understand help files with examples.

        Comment


        • #5
          Now answered on SO. Please see the link in #2.

          Comment


          • #6
            No, they don't have a link, I gathered the data and put each year in separate excel file. and then i add all the 10 excel files in one folder in my desktop. so, i need the command in Stata that can import the 10 excel files at the same time and read them as continues years from 2013 to 2022, so I will end having one large data set from 2013 to 2022. all the variables in the 10 excel files are the same, only the number of observations is different.

            Comment

            Working...
            X