Currently I am doing my thesis and use Stata to run my analysis. However I am having a problem right now with my data.

I have two collumns with values (both 0 to 100 scores) which need to merged into one value. Does anybody know how to do this in Stata? (read somewhere to use alpha command)

In addition I need to create a dummy variable (of this result of the two merged values). This dummy variable needs to be 0 for everything below the mean and 1 for everything above the mean. What is the command for this one in Stata?

Thanks in advance and kind regards,

Klaas