Question: Is there a way to get my results from Datastream in a format that Stata can work with? The transpose option doesn’t do what I would like it to do. I would like Company name, Year and variables in columns.
Answer: Yes there is a way. You have to use a request table for this. You find this request table in the Datastream menu in the add in in Excel. For a manual on how to use a request table look elsewhere on this blog. I have added a example of a request table for Stata for the FTSE100 companies. You will have to enter each company code separately to first get all the years for company one and then all the years for company two etc. NOTE ! There is no way to get the company name in your results so you have to add them manually later in your results.
Have a close look at this example request table and try to program it for your personal purposes.