#INSHEET STATA MANUAL#
#INSHEET STATA CODE#
#INSHEET STATA MAC#
#INSHEET STATA WINDOWS#

 Header  Include in do-files – name, project, project location, date, purpose, inputs, outputs, special instructions  Version Control  include version at top of do-file  Why? Replace weightlt200 = 0 if weight >= 200 & weight Header, Version Control

replace weightlt200 = 0 if weight >= 200  INSTEAD. ]  Example 7 (webuse union)   Generally [= Result:  Detailed summaries of variable age, separated over different values of black, includes only obs with year >= 80 19 Stata Syntax, cont. bysort black: summarize age if year >= 80, detail ]  Example 6 (webuse union)   Stata Command: Result:  Summarizes age separately for different values of black, including only obs for which year >= 80 18 Stata Syntax, cont. ]  Example 5 (webuse union)   Stata Command: Result:  Summarizes variable age, includes only first 100 obs and only obs with year >= 80 17 Stata Syntax, cont. ]  Example 4 (webuse union)  Stata Command:  Result:  Summarizes age, includes only observations with year >= 80 16 Stata Syntax, cont. ]  Example 3 (webuse union)   Stata Command: Result: Summarizes variable age 15 Stata Syntax, cont. ]  Example 2 (webuse union)   Stata command:  Result: Summarizes all dataset variables (_all) 14 Stata Syntax, cont. ]  Example 1 (webuse union)  Stata Command. ]  Brackets = optional portions  Italics = user specified 13 Stata Syntax, cont.   compress - saves data more efficiently reshape – long/wide  sort/ gsort  order  rename 12 Stata Syntax  recode  replace 10 Basic Commands, cont. (one-way tabulation of variables) tab2 varlist (two-way tabulations of variables) 9 Basic Commands, cont.

 Handout 1 (green)   Reading raw data  insheet, input, infix, infile Using/saving a Stata dataset  use,  Windows: Programs > Stata8  Command Window: enter commands  Results Window  Other: review, variables, do-editor  Unix:  Interactive Stata  commands and results show in same window  Batch Stata  nice +10 stata –b do  See ATS website for transferring files between SAS, Stata, and SPSS 

#INSHEET STATA WINDOWS#

 DBMS/Copy for Unix (without xwindows)    From Unix prompt   dbmsnoxĪre “pseudo” extensions  spsswin = SPSS for Windows   Stata7 = Stata 7 sas7sun = SAS for Unix v7  ssdsun = SAS for Unix v6 Example – windows spss to stata7

#INSHEET STATA MANUAL#

(replace st with local Stat/Transfer invocation) See manual for more info and options Check results!   Converting Data between Statistical Packages Stata –  Basic Commands  Command Syntax       Abbreviations Missing Values Combining Data Using do-files Getting Help Updating Stata 2Ĭonverting Data – Windows Stat/Transfer  SAS, Stata, S-Plus, SPSS, Excel, and more   Windows interface Enter “in” data and “out” data  Enter info on other tabs as necessary  Check results!Ĭonverting Data – Unix Stat/Transfer        From within stat-transfer invoke stat/transfer (specific to Unix machine) at stat/transfer prompt, enter:ĭatfile1.ext1 = original file, datfile2.ext2 = new file From Unix prompt Insheet using DATA_SRC.CCPR Computing Services Workshop 2: Stata October 20, 2004 Insheet using DATSRCLN.txt,clear delimiter('^') Insheet using FOOTNOTE.txt,clear delimiter('^') Insheet using WEIGHT.txt,clear delimiter('^') Insheet using DERIV_CD.txt,clear delimiter('^') Insheet using SRC_CD.txt,clear delimiter('^') Insheet using NUTR_DEF.txt,clear delimiter('^') Insheet using NUT_DATA.txt,clear delimiter('^') Insheet using LANGDESC.txt,clear delimiter('^')

Insheet using LANGUAL.txt,clear delimiter('^') Insheet using FD_GROUP.txt,clear delimiter('^') Insheet using FOOD_DES.txt,clear delimiter('^') # This converts tildes to quotation marks # This converts quotation marks to two single quotes # could end up modifying important files here! # downloaded files before running the next commands, or you # Make sure you're in the directory containing ONLY the

#INSHEET STATA MAC#

Prior to using State, this method requires the use of the linux ‘sed’ command first (as performed on a Mac in Terminal).Īfter unzipping the SR24.zip (or SR25.zip etc) file downloaded, in Terminal (or a bash shell): This database is useful for quantifying nutritional information and nutritional content of various common food items.

#INSHEET STATA CODE#

Here is some code to help convert the USDA’s National Nutrient Database (ASCII format) into Stata format.

Insheet stata