st: import csv, retain headers Stata11.2

[Tim Evans <Tim.Evans@wmciu.nhs.uk>]

Hi all,

I'm using Stata 11.2 and have potentially multiple .csv files relating to different regions of a country to import into Stata. For the main part, the variables in each dataset are comparable, but their names are not identical. I wish to run a series of summary commands on each variable held within the data and output the results. While I can 'copy and paste' the data from Excel into an empty spreadsheet and retain the heading title of each variable, I would rather automate this. However, using -insheet- results in a loss of variable names. I cant easily use -infile- as the point is I don't know the exact names of the variables in each .csv file to specify.

I've Googled this problem and not been able to find a solution. Does anyone have one.

PS, upgrading to Stata 12 is not even remotely possible at the moment!

Best wishes

Tim

_DISCLAIMER:
This email and any files transmitted with it are confidential. If you are not the intended recipient, any reading, printing, storage, disclosure, copying or any other action taken in respect of this e-mail is prohibited and may be unlawful. If you are not the intended recipient, please notify the sender immediately by using the reply function and then permanently delete what you have received.
 
The information contained in this e-mail may be subject to public disclosure under the Freedom of Information Act 2000. The confidentiality of this e-mail and your reply cannot be guaranteed, unless the information is legally exempt from disclosure.


*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/