I'm working on dataset and to make my causal effect free from any state fixed effects I need to create state control like : unemployment rate.

My question Is how can I create unemployment rate ( categorical variables are : "person is employed or not" and "person is in labor force or not" ) for 50 states in multiple years from both of these variables ?

Is there any particular comment I can use to make it easier to do ?