Data management using Stata: a practical handbook
Saved in:
| Main Author: | |
|---|---|
| Format: | Book |
| Language: | English |
| Published: |
College Station, Tex.
Stata Press
2010
|
| Subjects: | |
| Links: | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=020321048&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| Physical Description: | XI, 387 S. |
| ISBN: | 9781597180764 |
Staff View
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV036448858 | ||
| 003 | DE-604 | ||
| 005 | 20201014 | ||
| 007 | t| | ||
| 008 | 100511s2010 xx |||| 00||| eng d | ||
| 020 | |a 9781597180764 |9 978-1-59718-076-4 | ||
| 035 | |a (OCoLC)699995187 | ||
| 035 | |a (DE-599)BVBBV036448858 | ||
| 040 | |a DE-604 |b ger |e rakwb | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-473 |a DE-19 |a DE-Er8 |a DE-945 |a DE-29 |a DE-188 |a DE-N2 |a DE-739 |a DE-706 |a DE-634 |a DE-384 | ||
| 084 | |a QH 231 |0 (DE-625)141546: |2 rvk | ||
| 084 | |a ST 601 |0 (DE-625)143682: |2 rvk | ||
| 100 | 1 | |a Mitchell, Michael N. |e Verfasser |0 (DE-588)139115366 |4 aut | |
| 245 | 1 | 0 | |a Data management using Stata |b a practical handbook |c Michael N. Mitchell |
| 264 | 1 | |a College Station, Tex. |b Stata Press |c 2010 | |
| 300 | |a XI, 387 S. | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 650 | 0 | 7 | |a Statistik |0 (DE-588)4056995-0 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Stata |0 (DE-588)4617285-3 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Datenmanagement |0 (DE-588)4213132-7 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a Stata |0 (DE-588)4617285-3 |D s |
| 689 | 0 | |5 DE-604 | |
| 689 | 1 | 0 | |a Statistik |0 (DE-588)4056995-0 |D s |
| 689 | 1 | 1 | |a Datenmanagement |0 (DE-588)4213132-7 |D s |
| 689 | 1 | |5 DE-604 | |
| 856 | 4 | 2 | |m HBZ Datenaustausch |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=020321048&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 943 | 1 | |a oai:aleph.bib-bvb.de:BVB01-020321048 | |
Record in the Search Index
| _version_ | 1819364761178996736 |
|---|---|
| adam_text | Titel: Data management using stata
Autor: Mitchell, Michael N
Jahr: 2010
Contents
Acknowledgements v
List of tables xiii
List of figures xv
Preface xvii
Introduction 1
1.1 Using this book.............................. 2
1.2 Overview of this book.......................... 3
1.3 Listing observations in this book.................... 4
Reading and writing datasets 9
2.1 Introduction................................ 10
2.2 Reading Stata datasets.......................... 14
2.3 Saving Stata datasets........................... 16
2.4 Reading comma-separated and tab-separated files........... 18
2.5 Reading space-separated files...................... 20
2.6 Reading fixed-column files........................ 22
2.7 Reading fixed-column files with multiple lines of raw data per ob-
servation .................................. 26
2.8 Reading SAS XPORT files........................ 29
2.9 Common errors reading files....................... 30
2.10 Entering data directly into the Stata Data Editor........... 33
2.11 Saving comma-separated and tab-separated files............ 40
2.12 Saving space-separated files....................... 41
2.13 Saving SAS XPORT files......................... 43
Data cleaning 45
3.1 Introduction................................ 46
Contents
3.2 Double data entry ............................ 47
3.3 Checking individual variables...................... 50
3.4 Checking categorical by categorical variables.............. 54
3.5 Checking categorical by continuous variables.............. 56
3.6 Checking continuous by continuous variables.............. 60
3.7 Correcting errors in data......................... 63
3.8 Identifying duplicates........................... 67
3.9 Final thoughts on data cleaning..................... 75
Labeling datasets 77
4.1 Introduction................................ 78
4.2 Describing datasets............................ 78
4.3 Labeling variables............................. 84
4.4 Labeling values.............................. 86
4.5 Labeling utilities............................. 92
4.6 Labeling variables and values in different languages.......... 97
4.7 Adding comments to your dataset using notes............. 102
4.8 Formatting the display of variables................... 106
4.9 Changing the order of variables in a dataset.............. 110
Creating variables 115
5.1 Introduction................................ 116
5.2 Creating and changing variables..................... 116
5.3 Numeric expressions and functions................... 120
5.4 String expressions and functions..................... 121
5.5 Recoiling ................................. 125
5.6 Coding missing values.......................... 130
5.7 Dummy variables............................. 133
?5.8 Date variables............................... 137
5.9 Date-and-time variables......................... 144
5.10 Computations across variables...................... 150
5.11 Computations across observations.................... 152
Contents ix
5.12 More examples using the egen command................ 155
5.13 Converting string variables to numeric variables............ 157
5.14 Converting numeric variables to string variables............ 163
5.15 Renaming and ordering variables.................... 166
6 Combining datasets 173
6.1 Introduction................................ 174
6.2 Appending: Appending datasets .................... 174
6.3 Appending: Problems .......................... 178
6.4 Merging: One-to-one match-merging.................. 189
6.5 Merging: One-to-many match-merging................. 195
6.6 Merging: Merging multiple datasets .................. 199
6.7 Merging: Update merges......................... 203
6.8 Merging: Additional options when merging datasets ......... 206
6.9 Merging: Problems merging datasets.................. 211
6.10 Joining datasets.............................. 216
6.11 Crossing datasets............................. 218
7 Processing observations across subgroups 221
7.1 Introduction................................ 222
7.2 Obtaining separate results for subgroups................ 222
7.3 Computing values separately by subgroups............... 224
7.4 Computing values within subgroups: Subscripting observations . . . 228
7.5 Computing values within subgroups: Computations across obser-
vations ................................... 234
7.6 Computing values within subgroups: Running sums.......... 236
7.7 Computing values within subgroups: More examples......... 238
7.8 Comparing the by and tsset commands................. 244
8 Changing the shape of your data 247
8.1 Introduction................................ 248
8.2 Wide and long datasets ......................... 248
8.3 Introduction to reshaping long to wide................. 258
x Contents
8.4 Reshaping long to wide: Problems ................... 2(i 1
8.5 Introduction to reshaping wide to long................. 262
8.6 Reshaping wide to long: Problems ................... 266
8.7 Multilevel datasets............................ 271
8.8 Collapsing datasets............................ 271
9 Programming for data management 277
9.1 Introduction................................ 2(8
9.2 Tips on long-term goals in data management ............. 279
9.3 Executing do-files and making log files................. 282
9.4 Automating data checking........................ 289
9.5 Combining do-files............................ 292
9.6 Introducing Stata macros ........................ 296
9.7 Manipulating Stata macros ....................... 300
9.8 Repeating commands by looping over variables............ 303
9.9 Repeating commands by looping over numbers ............ 310
9.10 Repeating commands by looping over anything............ 312
9.11 Accessing results saved from Stata commands............. 314
9.12 Saving results of estimation commands as data............ 318
9.13 Writing Stata programs......................... 323
10 Additional resources 329
10.1 Online resources for this book...................... 330
10.2 Finding and installing additional programs............... 330
10.3 More online resources .......................... 339
A Common elements 341
A.l Introduction................................ 342
A.2 Overview of Stata syntax ........................ 342
A.3 Working across groups of observations with by ............ 344
A.4 Comments................................. 346
A.5 Data types................................. 347
A.6 Logical expressions............................ 357
Contents
A.7 Functions................................. 361
A.8 Subsetting observations with if and in................. 364
A.9 Subsetting observations and variables with keep and drop...... 367
A. 10 Missing values............................... 370
A.11 Referring to variable lists ........................ 374
Subject index 379
|
| any_adam_object | 1 |
| author | Mitchell, Michael N. |
| author_GND | (DE-588)139115366 |
| author_facet | Mitchell, Michael N. |
| author_role | aut |
| author_sort | Mitchell, Michael N. |
| author_variant | m n m mn mnm |
| building | Verbundindex |
| bvnumber | BV036448858 |
| classification_rvk | QH 231 ST 601 |
| ctrlnum | (OCoLC)699995187 (DE-599)BVBBV036448858 |
| discipline | Informatik Wirtschaftswissenschaften |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01538nam a2200385 c 4500</leader><controlfield tag="001">BV036448858</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20201014 </controlfield><controlfield tag="007">t|</controlfield><controlfield tag="008">100511s2010 xx |||| 00||| eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781597180764</subfield><subfield code="9">978-1-59718-076-4</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)699995187</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV036448858</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rakwb</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-473</subfield><subfield code="a">DE-19</subfield><subfield code="a">DE-Er8</subfield><subfield code="a">DE-945</subfield><subfield code="a">DE-29</subfield><subfield code="a">DE-188</subfield><subfield code="a">DE-N2</subfield><subfield code="a">DE-739</subfield><subfield code="a">DE-706</subfield><subfield code="a">DE-634</subfield><subfield code="a">DE-384</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">QH 231</subfield><subfield code="0">(DE-625)141546:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 601</subfield><subfield code="0">(DE-625)143682:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Mitchell, Michael N.</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)139115366</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Data management using Stata</subfield><subfield code="b">a practical handbook</subfield><subfield code="c">Michael N. Mitchell</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">College Station, Tex.</subfield><subfield code="b">Stata Press</subfield><subfield code="c">2010</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XI, 387 S.</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Statistik</subfield><subfield code="0">(DE-588)4056995-0</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Stata</subfield><subfield code="0">(DE-588)4617285-3</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Datenmanagement</subfield><subfield code="0">(DE-588)4213132-7</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Stata</subfield><subfield code="0">(DE-588)4617285-3</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="689" ind1="1" ind2="0"><subfield code="a">Statistik</subfield><subfield code="0">(DE-588)4056995-0</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="1" ind2="1"><subfield code="a">Datenmanagement</subfield><subfield code="0">(DE-588)4213132-7</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="1" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">HBZ Datenaustausch</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=020321048&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="943" ind1="1" ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-020321048</subfield></datafield></record></collection> |
| id | DE-604.BV036448858 |
| illustrated | Not Illustrated |
| indexdate | 2024-12-20T14:33:39Z |
| institution | BVB |
| isbn | 9781597180764 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-020321048 |
| oclc_num | 699995187 |
| open_access_boolean | |
| owner | DE-473 DE-BY-UBG DE-19 DE-BY-UBM DE-Er8 DE-945 DE-29 DE-188 DE-N2 DE-739 DE-706 DE-634 DE-384 |
| owner_facet | DE-473 DE-BY-UBG DE-19 DE-BY-UBM DE-Er8 DE-945 DE-29 DE-188 DE-N2 DE-739 DE-706 DE-634 DE-384 |
| physical | XI, 387 S. |
| publishDate | 2010 |
| publishDateSearch | 2010 |
| publishDateSort | 2010 |
| publisher | Stata Press |
| record_format | marc |
| spellingShingle | Mitchell, Michael N. Data management using Stata a practical handbook Statistik (DE-588)4056995-0 gnd Stata (DE-588)4617285-3 gnd Datenmanagement (DE-588)4213132-7 gnd |
| subject_GND | (DE-588)4056995-0 (DE-588)4617285-3 (DE-588)4213132-7 |
| title | Data management using Stata a practical handbook |
| title_auth | Data management using Stata a practical handbook |
| title_exact_search | Data management using Stata a practical handbook |
| title_full | Data management using Stata a practical handbook Michael N. Mitchell |
| title_fullStr | Data management using Stata a practical handbook Michael N. Mitchell |
| title_full_unstemmed | Data management using Stata a practical handbook Michael N. Mitchell |
| title_short | Data management using Stata |
| title_sort | data management using stata a practical handbook |
| title_sub | a practical handbook |
| topic | Statistik (DE-588)4056995-0 gnd Stata (DE-588)4617285-3 gnd Datenmanagement (DE-588)4213132-7 gnd |
| topic_facet | Statistik Stata Datenmanagement |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=020321048&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT mitchellmichaeln datamanagementusingstataapracticalhandbook |