Hello. My name is Charlie. I am an undergraduate student in the department of economics at the University of Maryland, College Park. I am interested in investigating gay locational patterns from 2005-2017. I am, however, new to research and not the best at coding in STATA. I realize that from 2013 and onward there is a variable SSMC that identifies the presence of a same-sex married couple. But because my interval of interest stretches back to 2005, I need a way to break down the data set to just include same sex couples, both married and unmarried, from 2005 to 2017. My goal right now is to create summary statistics depicting their household characteristics. I have used the command “keep if sex==sex_sp,” but I am uncertain as to whether this gets the job done or more coding is required to narrow the data set down further. I am also not sure how to create summary statistics and graphs on STATA for a large panel data set like this, with many discrete observations over several years. Any help or advice on this matter would be greatly appreciated. Thanks.