I'm analyzing the association between a public policy of interest and various indicators of job quality among a sample of adults who transition from unemployment to employment from one month to the next. One of the indicators of interest is earnings. I lack pre-job loss earnings information; so I thought I would compare the distance between a respondent's current wage, and the median wage of the industry and occupation in which they're employed. To start, I thought I would compute the ratio between the current wage and the industry and occupation median. How would I do that in Stata? I generated a sample dataset to give a sense of what I have, and what I'm aiming for. Thank you so much for any help.

Code:
* Example generated by -dataex-. For more info, type help dataex
clear
input byte personid float(ind wage) byte ratio
 1  2 7.25 .
 2  1   10 .
 3  3 12.5 .
 4  5   15 .
 5  7 7.25 .
 6  7   20 .
 7  8 7.25 .
 8  2   10 .
 9 12 12.5 .
10 14   15 .
11 14 7.25 .
12  6   20 .
13  6 7.25 .
14  6   20 .
end