Hi,
I have panel data comprising companies and employees. The companies have existing IDs, but I need to 1) create new 3 digit ID's for the companies starting from 101, 102, etc. and 2)IDs for employees where the first 3 digits are that of the company and then add a unique ID for the employee. Example:

Company_name Person_name Company_ID Person ID
xyz Richard 101 10101
xyz Ann 101 10102

How can I go about this?

Thanks