Hi Stata Users,
I am using Stata 15 SE on Windows. I have imported some data from Excel where the ID is only filled in the first row as shown below

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input byte id str3 category int value
1 "XXX" 1453
. "YYY" 4598
2 "SSS" 2378
. "BBB" 4578
. "HHH" 6912
3 "DDD" 7235
. "AAA" 9324
end
My goal is to try and fill up the missing information in ID column.

Thanks in advance!