Hello all,

I am trying to run a simulation on a dataset that contains user reviews. I have a selected a random subsample of 100,000 observations and I would like to create a new userid for these observations. Each userid should be tied to 10 observations, resulting in 1000 total users with each having 10 reviews 'under their belt'. As I previously, mentioned a userid already exists but I would like to create a new one for the sake of the simulation. How would I go about doing this?

Also, here is a screenshot that better illustrates what I am trying to do: https://imgur.com/a/xoIcdSo

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str17 userid double rating
"JwJo4RH2HW"   4
"7oazNLenTf"   4
"y2N9JaJfRz"   5
"ypLukZm71m"   5
"3i9sx2CUnI"   5
"JgFagM5AmQ"   4
"BkQiAqZwWL"   4
"a5LQB3DDhI" 4.5
"98qoOPf4a3"   2
"PiArsx90NW"   5
"TqQbNpjUoZ" 2.5
"ffPt3sBvTk"   5
"musrHV09iR" 4.5
"9DodB4LxYy"   5
"YNxjHi7G35"   5
"SfUr5MxJb1"   4
"5w3PKVR6Qw"   5
"rqQ5OKZQ71" 4.5
"AwQZ8KTZnb"   3
"89TTbMdmWi" 3.5
"Y3gIeiBdiC"   4
"Fxw6A4wu89"   5
"AafCtzZEIu"   5
"Ay7g3XGP9Z"   3
"WhMSNMJ2Fd"   3
"ICbEYFatdW"   3
"MS5Hg5cbiy" 4.5
"PaXUnlH6xk"   1
"W6Hnz9yUD7"   5
"B3AQlDjbWf"   4
"TsRE4o3AiR"   3
"ZhoohOqaes"   3
"sbxQxxc7so"   2
"elEnaJdtYy"   5
"igvVLWRnBC" 2.5
"NAvaUOfegm"   5
"XyBqqMLRiy"   1
"ZcnkHHQsyt"   4
"kLgdHPfR33" 2.5
"qUarbU1zLC"   4
"mKvHsKUTBv"   5
"HXRd7YQXxu"   5
"DPWbaUY6XJ"   4
"bFKqVLcCWf"   5
"yaJXD0lNFL"   5
"xbJU71AJqQ"   5
"bA58frI1AA"   2
"dQYvCieSht"   5
"XukyYZ36h2"   3
"Iap65gxtFn"   4
"FWCkgaTDXk"   3
"OMZlyyiWai"   5
"PidhLzCJbk"   3
"2zkh6WGkA6"   4
"ib78YspTmU"   3
"Gav0A5LArn"   4
"5DZ3JTNz3u"   2
"O6j5nQvibx"   3
"QVpxnCGylZ"   3
"HVM7F6puwu"   4
"1G8aGEowhZ"   4
"wDYWybxNw6"   5
"tZx1nHZzYZ" 4.5
"uT07urREL6"   5
"3H3dTxsM8w"   1
"3ScTlu71Kl"   4
"vW2a0pxsMs"   5
"HSdeHSKw11" 2.5
"LVMd2WJ0LS" 3.5
"rh0MKWcUjN" 4.5
"i3yyCH5ayc"   5
"awYQwiIqF3" 2.5
"O4vmAJbpp0" 3.5
"AaUC8DLDFH"   4
"v2c8pvdBhz" 4.5
"fHkuAxgxdh"   5
"t6WrBwFkY3" 4.5
"aC77j7e3UJ"   4
"LNww3k2Dim"   3
"BSf3DpkGaF" 2.5
"zPrQEIXlYB" 4.5
"7hoF2lvtwn"   5
"C7K7gszD16"   5
"OUiTOgV0JY" 4.5
"n2KArPGvA7"   5
"C9BTKvpvJK"   3
"Y5Ro6mYdFm"   5
"cAGPSoRziV" 3.5
"X9X0Pc0Kwx"   4
"nsHxKfiMJI" 3.5
"81uOK4VGAG" 4.5
"tkOOu6U8IS" 3.5
"IsDZSyLGFg"   4
"GjKAxnpliZ" 4.5
"8PpYzifEnX"   4
"a1OYaGpyUx"   5
"7CqDLTfOWp" 4.5
"eSSjF49C6M"   4
"eUV4j5Dm8t"   5
"cvWXqkWLrI"   5
end