************************************
************************************
***SOCI 600: INTRODUCTION TO SOCIOLOGICAL DATA ANALYSIS
***APPEND DIFFERENT YEARS OF THE AMERICAN COMMUNITY SURVEY
************************************
************************************

************************************
***CLEAR MEMORY
************************************
clear all

************************************
***CREATE SHORTCUTS AND LOG FILE
************************************
***Shortcut for folders
global codes  = "H:\course\codes"
global data   = "H:\course\data"
global output = "H:\course\output"

***Start saving results window
log using "$codes\Stata05b.log", replace text

************************************
***OPENING COMMANDS
************************************
***Tell Stata to not pause for "more" messages
set more off

***Change directory
cd "$data"

************************************
***APPEND DIFFERENT YEARS
************************************
***Open 2021 ACS (only Texas)
use "ACS2021.dta", clear

***Append 2005 ACS (only Texas)
append using "ACS2005.dta"

************************************
***FOR EVERYBODY
************************************
tab year, missing
tab year, m

************************************
***CLOSING COMMANDS
************************************
***Save data
save "Stata05b.dta", replace

***Save log
log close