X hits on this document

Word document

click on “Load Preferences”; (4) click on “Factory Settings.” If the ... - page 40 / 44





40 / 44

Recoding and Missing Data (Search and Replace in Excel): (1) highlight the

Data (probably, column) you want to change (if you want to change all the columns just keep highlighting as you move from left to right); (2) Click on “Edit” (upper left side of screen); (3) Click on “Find”; (4) In the “Find What” box tell it what number you want to change [if you want to convert a blank space into a “dot” (i.e., “.”) then leave the “Find What” box blank – i.e., don’t type the word “blank” in the box]; (5) Click on “Replace” (right side of gray box); (6) Put the number you want to change it to in the “replace with” box (if a dot –“.” – then put a “.” in the box); (7) Click on “Replace All.” If You need to move the gray box so it does not cover the column you are working with click in the blue area of the find/replace box and “drag” it to uncover what you need to uncover; (8) make sure to click to remove the black screen (if not, I don’t think the change occurs)

To Highlight an Entire Dataset: Click on the blank gray box which is to the left

         of column A and above row 1.

Adding a Row to an Existing Excel File: Click on the row number just below

where you want the new row inserted.  You will see an entire row turn black.  Then go to the top and pull down the menu that says “insert.”  You will then have an option for “rows, columns or cells” listed below one another.  Highlight “rows” and click.  A new row should be created.  If you want to add another row directly below the newly created row simply hit “control Y.”   

Transposing a Row to a Column (or vice versa): See discussion in Stata

under “Transpose Rows and Columns.”  In Excel: (1) highlight the row you

want to transpose; (2) under “edit,” click on “copy”; (3) open the document you want the new data in (it may be preferable to put it in a separate spreadsheet and work from there); (4) under “edit,” click on “paste special”; (5) check “transpose”; (6) click on “OK.”  Given that Excel limits you to 256 variables, you might need to convert an Excel file in Stata.  Save the Excel file as .csv and, using the “insheet” command in Stata, read the file into Stata.  Then use the “xpose” command to transpose your data (see Stata manual on using the “xpose” command).NOTE: In “Vista” version of Excel you: (1) open document you want to transfer the transposed data to; (2) highlight want you want to transpose; (3) right click on the mouse; (4) click on “copy”; (5) right click again on mouse and click on “paste special”; (6) check “transpose”  You might also try Stata.  

In Stata type: xpose, clear  (You’ll lose the variable names however)

Delete a Row or Column: (1) highlight the row or column you wish to delete; (2)

Document info
Document views462
Page views526
Page last viewedSun Jan 22 08:19:16 UTC 2017