Hello everyone, undergraduate Bsc Economics student here, I am struggling to use Stata 15. This may be a very simple question to those of you that are competent or experienced in using Stata, but it's has me confused.

I have a dataset (Argentinian enterprise panel survey) containing 527 variables from the years 2015,2016,2017 and 2018.

I am trying to
  1. generate a new variable exp_dum (export dummy) which equals 1 if sales_exp is positive, otherwise 0.
  2. generate new variable foreign_dum (foreign ownership dummy) which equals 1 if foreign is positive, otherwise 0.
  3. generate new variable soe_dum (state ownership dummy) which equals 1 if soe is positive, otherwise 0.
Additionally, I want to produce a summary statistic table of all variables to include the three dummies variables. including observation number, mean, standard deviation, minimum, and maximum values etc

How would I go about generating these three dummy variables in stata 15?

Many thanks in advance

Kieran