Using Stata for Survey Data Analysis

Using Stata for Survey Data Analysis 
 
Minot 
 
Page 21
3) Copy the table with Edit/Copy Table or Control-Shift C 
4) Paste the table into Excel
To move tables from a log file to a Word table,
1) Open the log file by clicking on File/Log/View 
2) Mark the table by dragging the cursor across it 
3) Copy the table with Edit/Copy Table or Control-Shift C 
4) Paste the table into Word with Control-V 
5) Mark the table and then click Table/Insert/Table 
To move tables from the Results window to Word or Excel, follow the above procedures starting with 
step #2. 
However, one problem with these procedures is that there has to be a clear division between columns.
If there is a heading that overlaps two columns, the two columns will be merged. To avoid this, you 
can exclude the heading when you copy the table.
Exercises for saving commands and output
1) 
Open a do-file (program) to store commands and write a program that 1) opens the 
households.dta data file and 2) produces a table showing the percentage of female-headed 
households in urban and rural areas (hint: use the tab command). Run the program to make 
sure it works. Save the program as “table1” and then exit. 
2)
Open the program “table1” and add a command to create a second table showing the number 
of sample households in each dzongkhag. Run, save, and close.
3)
Open the program “table1” and a log commands to save the output to a file called 
“table1_results”. Be sure to include both a “log using..” command and a “log off” command.
4) 
Copy one of the tables into Excel using the Edit/Copy table menu command. 
5) 
Copy the table into a Word file. 
 

---

Minot