Hey there, I am a bit new to Stata, so I hope my question will be clear enough.
I am looking at the distribution of minimum wages in the U.S. for the first period and the last period of a sample. I am given both county fips code and state fips code and I want to select only one county per state. My question is which command would be able to do that?

Code:
period fips state_fips
78 1001 1
40 1001 1 
41 1001 1
57 1003 1 
73 1003 1 
56 1025 1
37 1025 1 
28 1033 1
88 1033 1 
62 1033 1
Thank you in advance!