Monday, 9 November 2009

Can't convert STATA 10 dta files using Stat Transfer? Try the Outsheet Command.

If you find you have problems converting your STATA 10 dta files into other formats using Stat Transfer 8, one method is to use Outsheet,to produce a delimited data file.

From the STATA window use File > Export > Comma or tab-separated data.

You can then use Stat Transfer to convert the file into a filetype of your choice.

Another option is to use the command Outsheet in the command window.

Outsheet using c:\statafile.txt

will output into a tab delimited ascii file on your C: drive

Outsheet using c:\statafile.xls

will output into an excel file, with the variable headings on the first row.

For more detailed instructions and options using outsheet type help outsheet in the command window of STATA - or - go to

Tuesday, 21 July 2009

How to copy text from a Word Document and keep Track Changes

If you are reviewing a Word document and want to copy a paragraph, page or a couple of pages into a new document, any reviews/track changes will be lost when you paste the text into the new file.

To keep your review/track changes in the new document do the following.

  1. Save a copy of the Word document. [This is your backup]

  2. Select the text you want to copy.

  3. Press CTRL + F3. This will cut the text along with track changes. [Hence the need to follow step 1 and make a backup of the original Word document].

  4. Open a new Word document.

  5. Press CTRL + SHIFT + F3. This will paste your selected text AND your reviews/track changes along with it.

Friday, 26 June 2009

Installing Outreg2 on your desktop.

Create C:\ado\personal
Run Stata
Type net set ado C:\ado\personal
Type ssc install outreg2

You can now use the Outreg2 command

Monday, 23 February 2009

RSS Feeds: Want to keep up to date with CEP News or Publications or Events on Outlook?

Want to find out the latest news or publications or events from the Centre for Economic Performance, but don't want the hassle of searching through the CEP website or signing up to a mailing list?

Want your news appearing live on Outlook, organized in a folder of its own and updated automatically? Now you can with CEP's RSS feeds.

RSS stands for Really Simple Syndication - which allows site content to be shared easily and viewable in other programmes. Any site with the following RSS icon has content which can be shared:

Follow the simple instructions from the RLAB IT Website to get started: