#OPEN STATA 13 FILE IN STATA 12 SOFTWARE#
#OPEN STATA 13 FILE IN STATA 12 DOWNLOAD#

Next save this as a Stata database.ДЎ2) Use clear all to start with the second sheet. Change the variable names and make sure that the column with numbers is called company. Now start up Stata en use the sheets in the Excel Worksheet step by step:ДЎ0) First you import the sheet (from step 9) with the price data from Excel using the command import ( or the Menu option File > Import > Excel spreadsheet).ДЎ1) Use the reshape command the rearrange the data to long format: reshape long company, i(Date) j(price). Make sure to copy & paste as value (right-click) to remove any formulas. It should look as follows: 9) Make a new copy of the first changed sheet and delete the first few rows. Example:Д§) Use the Excel function =left() to get the ISIN codes (12 digits) in a separate column or use Search and replace to get rid of the variable indicator (P)ДЁ) Copy and paste this data as values to a new sheet. Example: =$A$1&B1Д¦) Now also make a copy of the first 3 rows and paste the data transposed using the Right-click option in a new sheet. Try downloading everything without transposing and you get everything in long format as follows:Д¬hanging the data to a proper long format for Stata goes as follows:ДЎ) Make a copy of the original data and add a new row at the top.Дў) Above the Dates in column A type in a general name like вЂњ companyвЂќ in Cell A1.ДЈ) Also use numbers for each individual company at the top.Д¤) Insert a new row above the data and give the name Date in Column A above the actual datesДҐ) In the cells of this same row use an Excel formula to generate fake names.

#OPEN STATA 13 FILE IN STATA 12 DOWNLOAD#

If you download, for instance, daily price data from Datastream for many years (using ISIN codes) for x number of listed companies the wide download format (transposed) is not a good option.

#OPEN STATA 13 FILE IN STATA 12 SOFTWARE#

For larger datasets, however, it may become a problem to download the data in wide format and also the Stata software may have difficulty changing the presentation. This option works fine where smaller datasets are concerned and if there is no choice when downloading data. In the past I demonstrated how it was possible to change a dataset from a wide presentation (= data in columns) to a long presentation (= data in rows) using the reshape command in Stata.

Open stata 13 file in stata 12