set seed

[Thein Zaw]

Hi All,
As I understand set seed the numbers to produce the same result for randomization when running, again and again, But I found a different result in every time of running randomization.
Please suggest me how to fix this, and to get a constant random result.

[FernandoRios]

Hi Thein
To help with this, you should post a reproducible version of your code, (which has the problem you describe) so someone may be able to see what is the source of the problem.
Fernando

[Thein Zaw]

Here is my code

use "$dta\eligible_list.dta"
*drop surveyCTO system variables
drop deviceid-timestamp

*keep only for randomization sample

keep resp_id cl_id b5_wk key


set seed 45012490


************************************************** ******************************
// Randomization :Clinic level
************************************************** ******************************

*keep b5_wk cl_id

*Option 1: clinic level randomization
*clinic level randomization and 2 portions on gestation week


xtile gp = b5_wk , nq(2)

bysort cl_id gp: gen rand = runiform()


sort gp rand

.

by gp (rand) : gen sample_type = ///
cond( (_n < .25*_N) , 1 , ///
cond( (_n >= .25*_N) & (_n < .50*_N) , 2 , ///
cond( (_n >= .50*_N) & (_n < .75*_N) , 3 , ///
cond( (_n >= .75*_N) , 4 , . ) ) ) )


Here is sample dataset,

dataex,count(200)

----------------------- copy starting from the next line -----------------------

* Example generated by -dataex-. To install: ssc install dataex
clear
input str2 cl_id str7 resp_id byte b5_wk str41 key byte gp float(rand sample_type)
"14" "0514191" 18 "uuid:744c0561-57af-4e50-8363-9430398f9ea2" 1  .002916307 1
"21" "0821012"  8 "uuid:5abe8f42-f6a4-41bd-ab5c-bd053e807423" 1   .00359785 1
"14" "0514028" 18 "uuid:7a0c4e3b-228c-4f68-8949-7f1e8fc95826" 1 .0037440876 1
"15" "0515147" 16 "uuid:19c8b35d-c410-4f29-b921-f8d9324abc90" 1  .004072859 1
"08" "0308031" 16 "uuid:9640ca8d-5174-4c69-b717-ca4a60e152c6" 1 .0041398634 1
"15" "0515064" 18 "uuid:b1434655-ce74-402b-ad1f-fb2ae6090066" 1  .009065456 1
"38" "1938002" 18 "uuid:bce13816-23e6-44cc-85bf-4232144b7584" 1   .00984202 1
"15" "0515057" 16 "uuid:d41f93fb-32ec-4c60-85ff-e88a16c7b437" 1   .01059161 1
"19" "0719007" 18 "uuid:af31dc7f-bd7c-43d4-ae8b-c0b20609ca8f" 1   .01311665 1
"13" "0413012" 12 "uuid:e6706c9b-0779-490e-9ebc-a85d778f2e2c" 1  .013432967 1
"06" "0206001" 16 "uuid:e227d33f-4434-4dc8-9199-a93b7362de50" 1  .017203579 1
"05" "0205042"  8 "uuid:41662c3c-d7b6-4afd-be45-4fe7700f1864" 1  .017733157 1
"16" "0516005"  8 "uuid:28c01e65-7550-4990-9c53-c9f85d023f02" 1   .01953931 1
"19" "0719012" 10 "uuid:d3ce31cd-5fe0-489b-b98a-3a4a8e64edac" 1   .01960439 1
"15" "0515159"  6 "uuid:74024cf3-98cb-4a79-84e0-d14be69afa38" 1   .02059218 1
"34" "1634003" 18 "uuid:c0b43ce5-fcf4-422f-9ab8-884bb8e0f93e" 1  .021359507 1
"22" "0922014" 10 "uuid:5c00119b-942a-4013-8d14-9acb4a5701b7" 1  .023247764 1
"15" "0515020" 18 "uuid:5aedd493-3d44-45e9-9051-0ccb30c8ffbf" 1  .024261514 1
"36" "1836001"  8 "uuid:34d31bd4-fd22-427b-9987-a439efe9cf35" 1  .024284584 1
"12" "0412060" 18 "uuid:0a8a0558-cc8f-4e89-b861-c46747b99e1c" 1  .032460485 1
"09" "0309001"  8 "uuid:567dbc98-48f2-49bb-9dc6-a565ee81da34" 1  .034857314 1
"18" "0618008" 10 "uuid:88ef2556-5f4a-42ff-9f5a-91d36bb6fb94" 1   .03588092 1
"19" "0719026" 12 "uuid:602cca18-41b1-4914-91ff-122b65323596" 1   .03749714 1
"33" "1633138" 18 "uuid:21f7a5fb-2d37-451c-ae85-1bfc6c3eb595" 1    .0375795 1
"12" "0412031" 16 "uuid:e4872230-7dfd-419c-9492-d143a7e24f5f" 1   .03809322 1
"05" "0205045"  5 "uuid:bcdb299d-00df-4cf8-b6cc-f982b6c68a0b" 1   .03897767 1
"25" "1225004" 18 "uuid:2cb5d031-2ce0-4eea-a7c9-0be939be9903" 1   .04053076 1
"08" "0308046" 12 "uuid:3b9ae119-8e48-40bb-a244-b861a109b8d3" 1   .04065176 1
"22" "0922003" 12 "uuid:0af6f586-4b52-4d92-9506-eb12111c0904" 1   .04221722 1
"34" "1634002" 18 "uuid:3f024fc6-3bd2-45c0-9584-f6c8e9cf1826" 1   .04238107 1
"14" "0514148"  8 "uuid:1659d9b6-f07e-4154-bfd6-e583edb32e02" 1   .04393878 1
"16" "0516016"  6 "uuid:fff1cd5f-83c8-487b-84e5-079e3b52ea0e" 1   .04564479 1
"35" "1735025" 16 "uuid:517a9d62-39e1-4fe2-b036-e72f27bd4346" 1   .04662263 1
"40" "1940006"  9 "uuid:3ee5682d-99d1-4ed0-8d85-1ac08cfc2d16" 1   .04882263 1
"05" "0205005" 14 "uuid:d510e93c-e2e3-4104-a3c0-deb8cf604c54" 1   .04890369 1
"14" "0514088" 18 "uuid:27701d24-365e-481b-a6d7-669d1ccf96fc" 1   .05119184 1
"03" "0103004" 18 "uuid:afd42e21-17ec-464d-8387-e783e34e1a29" 1   .05396593 1
"23" "1023002" 12 "uuid:24bce7d6-bf01-427f-a5a4-489be67c1d22" 1   .05603277 1
"02" "0102002" 18 "uuid:179e6dfa-63ae-43e5-849d-ca46fe7b58e9" 1   .05606024 1
"33" "1633094"  7 "uuid:ac4d3f07-a276-4034-a04e-f67fd50d2cda" 1    .0611153 1
"12" "0412016" 16 "uuid:f9b23a7d-4a4c-4bc9-bccd-6481297b81f4" 1   .06442379 1
"17" "0517004"  8 "uuid:6ceb8109-a30e-4023-bfe8-51fea98781de" 1   .06734723 1
"30" "1530007" 14 "uuid:50997dcd-e3e3-4a06-a56c-f54b8242934d" 1   .07054578 1
"03" "0103017" 12 "uuid:23218972-c5b6-4918-a943-f474338888fe" 1   .07819151 1
"05" "0205076" 18 "uuid:17a6c687-88fa-4ce4-bc5b-a93c530dbd0b" 1   .08068626 1
"38" "1938009" 12 "uuid:ece0e809-1127-4057-b170-7f407b85a6a1" 1   .08332559 1
"06" "0206011" 15 "uuid:c5d18fd4-85fe-4e30-8f61-507cc07ef557" 1   .08446746 1
"14" "0514102" 16 "uuid:39cdb6b9-b13e-4535-bdb2-8825bb357193" 1   .08467489 1
"25" "1225022" 11 "uuid:beecf82d-8b08-4ee6-9093-4356e88c1c59" 1   .08484397 1
"24" "1124002" 12 "uuid:80230742-3d25-4fd4-8365-7fdb65a0962b" 1   .08712746 1
"15" "0515096"  6 "uuid:f9486a71-229a-46f0-8151-851f31dcf981" 1    .0924606 1
"17" "0517022" 16 "uuid:ba4ddd76-a652-4eec-926a-93e15fb1b7b2" 1    .0971065 1
"33" "1633044" 13 "uuid:33f23ad6-9c81-4bac-a785-719e2f52653a" 1   .09850814 1
"30" "1530036" 13 "uuid:ca2c55c9-8894-421a-9af8-463ad6b4f63e" 1   .09971898 1
"05" "0205078" 18 "uuid:bb57efb2-0811-4322-8ca7-e20d3775640a" 1   .10014156 1
"14" "0514196" 14 "uuid:ad94b8e2-8039-46c7-84ae-7da6af40618e" 1   .10277603 1
"14" "0514198"  8 "uuid:35eb01af-f210-4ada-9073-c8530bf4f47b" 1    .1038148 1
"16" "0516013" 10 "uuid:10e8d436-3c93-493c-a5b1-544f4af7abeb" 1   .10431948 1
"13" "0413006" 16 "uuid:4b7c9db2-5c7c-4739-8e22-b70596bccbab" 1   .10518562 1
"25" "1225023" 18 "uuid:16929c2f-b73c-4a60-a25e-072b0d276733" 1   .10699096 1
"23" "1023017" 16 "uuid:2606a502-8156-4cb1-bb3b-11421b3a4122" 1   .10734697 1
"08" "0308070" 16 "uuid:65ea4c7f-5ca9-48bc-beaa-8a0a43cf36c7" 1   .10843022 1
"14" "0514089" 12 "uuid:f54d61c7-6e2c-4c28-a150-c0ad0b563e60" 1   .11030074 1
"18" "0618015" 10 "uuid:e4bbc18b-a930-407c-a9ac-40b9f67f62dc" 1    .1110801 1
"07" "0207007" 16 "uuid:8f6110d0-4bc0-4d8c-b4f1-1110d5b5e4f9" 1   .11136024 1
"14" "0514011" 16 "uuid:78cf9346-391e-4964-a49a-cead98f7edff" 1    .1142562 1
"11" "0311007" 14 "uuid:4af65d57-57db-4954-be16-d5e53fed7c2d" 1   .11463143 1
"18" "0618029"  6 "uuid:97a36a6a-9156-45a9-9df5-26637107c9c2" 1   .12079717 1
"08" "0308025" 16 "uuid:2ca26fd5-563c-435b-8940-7586db2ebb00" 1   .12187283 1
"26" "1326032" 12 "uuid:046d9b27-9d91-4165-85e4-149822050142" 1   .12364689 1
"11" "0311004" 12 "uuid:24eafe1e-b06f-4ca8-b311-e6b885d22e5e" 1   .12580691 1
"18" "0618019" 12 "uuid:2ce407aa-4c50-46ad-911a-79a27aa280af" 1   .12669888 1
"14" "0514080" 16 "uuid:e2873530-5b11-41d9-a872-be37ef8791ac" 1   .12790388 1
"33" "1633013" 15 "uuid:4f8d98e7-ca60-4ad2-8879-10ad406112dd" 1   .12921908 1
"13" "0413008" 16 "uuid:26823b31-a44c-4743-9f17-23f82d621882" 1   .13155629 1
"17" "0517013" 12 "uuid:a9b8cf45-4bd6-4b25-9794-10bcc4424162" 1   .13449825 1
"13" "0413007" 12 "uuid:2b50c88d-eca0-4961-9fa4-cf474f9fc793" 1   .13530251 1
"12" "0412046" 12 "uuid:6c5d2494-e0c5-40a2-aa2e-b452fde7f890" 1    .1368871 1
"06" "0206023" 12 "uuid:ff994b18-a288-4b0b-b558-69f88d43af3e" 1   .13861781 1
"03" "0103011"  8 "uuid:d95d3084-73d9-4562-a44d-eeb6050db4e9" 1   .14014007 1
"14" "0514174"  8 "uuid:b5e38b7f-a6ca-43ed-8ad4-b16c12e4520e" 1   .14028813 1
"21" "0821005" 14 "uuid:7e3104c2-c3e0-4cb3-bf7e-07b450b71019" 1    .1409157 1
"02" "0102003" 18 "uuid:e3f7164e-e50d-4297-b40f-8260eb0d7d3b" 1   .14163189 1
"16" "0516015"  7 "uuid:807782a8-e4c0-49cb-bd31-3e905be934aa" 1   .14227629 1
"14" "0514162"  8 "uuid:3387e3bd-830b-453a-9f7c-33f874bc35cf" 1   .14243644 1
"33" "1633148" 15 "uuid:a61cb1b6-0d98-49dc-bdaa-5b727ca8acbc" 1   .14311185 1
"01" "0101017" 12 "uuid:69126e1e-a432-4a8d-84c6-0999b7ecc5b8" 1   .14398003 1
"02" "0102004" 12 "uuid:94ec93f3-f1f4-4928-b02c-b246919e1903" 1    .1449553 1
"15" "0515003" 10 "uuid:9509ef98-5150-49e0-983e-b4314be62cf9" 1   .14668019 1
"16" "0516051" 16 "uuid:927c2ac4-2190-4247-bcec-8a5ea29f023c" 1   .14706679 1
"14" "0514173"  8 "uuid:51f711f2-a5d7-47cb-92fb-bb303f5e2860" 1    .1476839 1
"18" "0618017" 10 "uuid:10bd2e04-f206-494d-b582-183040cea62a" 1   .14781845 1
"35" "1735018" 14 "uuid:e35c4422-da10-40f0-bdc6-7235314f722a" 1   .14912136 1
"23" "1023035" 12 "uuid:bbc77451-f8b6-40d2-bd4c-fba2a8ded924" 1    .1520021 1
"15" "0515069" 16 "uuid:7419f96d-7b4d-4ab5-ac02-f88af6c44830" 1    .1535436 1
"13" "0413014" 12 "uuid:d3177d48-e61e-4e38-8b46-7e7234a18fa3" 1   .15541224 1
"12" "0412045" 12 "uuid:aed8d3b9-726b-4496-a0ae-39b5b696d44e" 1   .16033833 1
"23" "1023032" 17 "uuid:04afa61c-2156-4056-a0f5-01fb58103d82" 1    .1632488 1
"08" "0308020" 10 "uuid:43178164-daf9-4b28-a6f8-e9d51a97d1f9" 1    .1633358 1
"14" "0514109" 10 "uuid:02c230d2-259f-4414-b35f-4a92e592bfc7" 1   .16492577 1
"09" "0309016" 16 "uuid:b3c524f3-9989-48fb-9e5f-c482b6a88af5" 1    .1682417 1
"23" "1023024"  5 "uuid:bad9b969-810f-4cb8-b30d-beb03fa7ebae" 1   .16873322 1
"30" "1530043"  8 "uuid:2a2ee1a0-da03-4d00-98c9-efe03eefd18a" 1    .1697162 1
"08" "0308015" 14 "uuid:c2d73c5b-b7ab-4a27-a23f-a91a1535176f" 1    .1721893 1
"36" "1836029"  8 "uuid:f4f55cb6-3a27-40ed-9190-fc27cc1624cb" 1    .1748932 1
"08" "0308007" 14 "uuid:549d59b3-b224-4ea1-8973-302d26eab8f1" 1   .18106046 1
"39" "1939004" 16 "uuid:8bbc7d1c-929c-41c0-9db0-bd0765738972" 1    .1825416 1
"30" "1530019"  8 "uuid:0e1ecef5-35ff-49ee-b54a-80606d4be4b3" 1   .18417923 1
"13" "0413002" 12 "uuid:4f6fe5f5-e09e-49d1-b183-16c4edb376dd" 1   .18540415 1
"16" "0516031" 12 "uuid:aae2dc32-8a2a-4a31-b618-2d8ce5804cae" 1    .1878098 1
"18" "0618002" 18 "uuid:e524e3f5-b289-4ed8-9915-82ce7946002c" 1   .19058745 1
"14" "0514116" 12 "uuid:c11af141-d747-4560-8aee-45245acab6d9" 1   .19067043 1
"26" "1326036" 16 "uuid:f4211f79-90ac-4b7d-9d21-0ffdf83bc101" 1   .19069663 1
"13" "0413003" 12 "uuid:538b8b61-e60f-4ecf-83c6-e695fe6d4a98" 1    .1922809 1
"14" "0514189" 12 "uuid:db1ccb90-fc3c-4de8-ad8c-a62018b4d24a" 1   .19306457 1
"15" "0515044" 12 "uuid:89d45def-7934-428b-a78c-99ef2cc28248" 1   .19666913 1
"41" "1941013"  9 "uuid:ccb21c2a-4e7c-45e2-aaef-9b1aa38ae033" 1    .2000146 1
"05" "0205067" 18 "uuid:5537bac9-a42b-4f77-99cd-472488b6f0f5" 1   .20017336 1
"05" "0205059" 12 "uuid:39f82f6f-4994-4718-8f32-d98abe1ba0b4" 1   .20149945 1
"32" "1532002" 10 "uuid:6ec12e42-3edf-4482-a04d-e048dadf6ed2" 1    .2018675 1
"05" "0205046" 13 "uuid:db0229b9-727f-4225-abec-ae93af2c4254" 1    .2040085 1
"16" "0516045" 13 "uuid:20a1fb88-7ec4-498b-b263-7384ee9f8265" 1   .21253736 1
"14" "0514033" 12 "uuid:cfbb4345-ef0e-4e2e-8291-0c9ffdaa04b5" 1    .2175322 1
"35" "1735007" 16 "uuid:fc9ae9a9-119b-4810-a410-46df70e967c0" 1    .2183818 1
"14" "0514052" 18 "uuid:762fca3a-00a7-4233-8d66-fc4753733424" 1     .221003 1
"14" "0514049" 16 "uuid:826d5233-270a-4b04-b01c-4e09693ce998" 1   .22356854 1
"03" "0103027" 12 "uuid:ddda2ce6-f9e6-4922-8bf6-6b167685af64" 1   .22536495 1
"32" "1532006" 18 "uuid:ad381ca7-44c3-4936-bd89-11004e1b7bb3" 1   .22574177 1
"21" "0821010"  8 "uuid:6a3dc670-bcf4-4a7d-ae0e-86656f36f68e" 1   .22676685 1
"05" "0205087" 14 "uuid:463d1545-6c55-4b1d-b06e-f07b9a0e012b" 1   .22896035 1
"30" "1530042" 12 "uuid:d9ea6842-6e99-4b4a-a48f-bc31d97bca1d" 1   .22939286 1
"38" "1938017" 11 "uuid:a56c3ac5-060a-4fd2-9a28-66b2656e7f54" 1    .2312546 1
"09" "0309002" 10 "uuid:e908f850-85d6-43e4-afd7-4b5028aee070" 1   .23420465 1
"08" "0308045" 14 "uuid:f5c1f1ad-5601-4a6b-9015-7c14dbea78fa" 1    .2347497 1
"06" "0206019" 18 "uuid:91d38187-46e7-41a9-90e2-ab82aa545e25" 1     .234858 1
"08" "0308016" 16 "uuid:4b16a83c-ff9f-4091-92ba-b104e2b19c9c" 1   .23695847 1
"08" "0308023" 16 "uuid:6c025bd1-2ede-4646-aaa5-af2f82deb008" 1    .2380275 1
"25" "1225008" 18 "uuid:67e85bd9-e95c-4ce2-9ace-e56f130ad2a1" 1    .2407516 1
"15" "0515011" 16 "uuid:8a2fcd7b-9672-460c-971f-ff2100e0c55a" 1   .24141812 1
"23" "1023022"  8 "uuid:1e35bbf3-0dda-4259-96a3-13b630da6bd4" 1   .24268296 1
"05" "0205073" 16 "uuid:0ea90199-8fd2-46e0-a2c1-5eddc3ffe43d" 1   .24330227 1
"40" "1940004" 18 "uuid:f96b65e7-344c-4cfe-967b-8df851bac4b9" 1   .24369863 1
"12" "0412059" 16 "uuid:508c0693-fd13-4ada-9ab9-89b4df57b208" 1   .24386683 1
"15" "0515098" 16 "uuid:39af2650-ff4e-4cd8-af17-a4094f159db6" 1   .24564934 1
"35" "1735005" 18 "uuid:10dc5ee2-0e50-4628-86c6-73e4f0d3158f" 1    .2479511 1
"36" "1836014"  6 "uuid:90ac2bf0-c413-4720-a319-bd5ac0356f9d" 1    .2492103 1
"33" "1633025" 18 "uuid:a8bc5905-aca1-4557-821d-1e1622ceeebe" 1   .25248548 1
"11" "0311013" 18 "uuid:7cbd5a94-8eb3-434d-9cd0-bf4327ef2fec" 1   .25305364 1
"12" "0412056" 16 "uuid:89b14aec-1667-4011-8a4f-dec43a6a4e5e" 1    .2540034 1
"18" "0618028" 18 "uuid:f4989660-4c38-45d7-a14e-73b6418c659c" 1    .2557237 1
"30" "1530011" 16 "uuid:14b2d68e-4f97-4c6d-b53f-29a7a6762322" 1   .25601763 1
"30" "1530012"  6 "uuid:5485fc9e-0f62-47ad-947b-3d8e06d2f9f2" 1    .2567523 1
"16" "0516017" 11 "uuid:fe8f7ed8-e195-4489-9349-31405de8f394" 1   .26030865 1
"30" "1530060" 12 "uuid:42e1dd83-536e-4383-af0f-a3674e04a95f" 1   .26293257 1
"32" "1532011"  8 "uuid:f0503d5c-dc41-438c-b6b7-b716637b8c35" 1   .26323855 1
"14" "0514223" 10 "uuid:03abd86f-bad4-4ff5-a7e3-12317122af2d" 1   .26494274 1
"15" "0515157" 10 "uuid:02bf64a4-c1e8-4021-8b3d-3503e50e1f71" 1   .26600957 1
"14" "0514078" 16 "uuid:b6e68583-6fe3-4d02-ac1f-027f685fd72e" 1    .2675201 1
"11" "0311005"  8 "uuid:c2915374-7b05-4863-84dd-495b98cb9116" 1   .27050248 1
"14" "0514053" 16 "uuid:1af6bd16-a0f5-456a-a1e2-b38accfdc90e" 1   .27120733 2
"33" "1633072" 17 "uuid:1995c247-7d9e-4e19-a8a2-9c185fd2a32e" 1   .27422598 2
"35" "1735004" 14 "uuid:56c05230-e55f-4781-87b6-0976485450b9" 1   .27784604 2
"06" "0206024" 14 "uuid:27bd1854-1d95-4e8e-8c38-af490e8df7dc" 1   .27927753 2
"15" "0515126" 12 "uuid:29cc8705-3dee-4144-9a91-061c8e9ae80e" 1   .27947825 2
"16" "0516052" 11 "uuid:a38266fe-3f77-4598-ada2-c2431102efb1" 1    .2797383 2
"14" "0514209" 16 "uuid:c5e16fe5-a430-4dc2-847a-851e91467f83" 1   .27986425 2
"40" "1940018" 16 "uuid:40385da7-4a41-4ee5-9dd6-35877182da62" 1    .2822891 2
"14" "0514207"  8 "uuid:37e19af5-072c-4818-94c6-5cba2a42009c" 1   .28281465 2
"08" "0308003" 18 "uuid:a5a3cf81-c0e6-44e7-8180-4914bfd6973b" 1   .28310576 2
"14" "0514222"  8 "uuid:ab34b992-5ca6-4df6-ae08-5357395c9136" 1   .28471673 2
"30" "1530030" 16 "uuid:d2be278c-450b-4766-8333-8d49243f2706" 1    .2852429 2
"38" "1938018" 18 "uuid:f1314626-d8bc-45d2-9ab0-594e63018933" 1    .2861324 2
"25" "1225035" 12 "uuid:5cd20e85-38a3-4831-a603-baf6f1efadc1" 1   .28756103 2
"41" "1941006" 10 "uuid:e89ed1d6-9eba-4bea-abdd-b6a9b6f957bb" 1    .2895263 2
"01" "0101014" 16 "uuid:a4f944ef-4780-4aa6-8675-4a86da079e5a" 1    .2904596 2
"36" "1836017" 16 "uuid:8b0b6eea-dc30-4981-8cfa-a8671f4b4f30" 1   .29531556 2
"04" "0104002" 12 "uuid:315686cf-e39a-4e0f-b1fe-1ccf90fd81ea" 1   .29542944 2
"18" "0618034"  4 "uuid:3dca622c-395d-45c9-a6d6-6480d9a90067" 1   .29626176 2
"22" "0922009" 18 "uuid:509613f4-c281-40a3-ae82-7db8d0122be3" 1   .29709285 2
"23" "1023018" 12 "uuid:15d06c5d-d07e-4fdc-a2e8-d78fcb2fafb7" 1    .3000236 2
"25" "1225016"  9 "uuid:b860b5ab-983a-4cf9-a648-f94817cfbec4" 1    .3048518 2
"30" "1530054" 16 "uuid:4f5d4181-606a-40d8-962d-9ee4debeb344" 1    .3058895 2
"36" "1836008" 16 "uuid:e2b5ab9a-d6b3-4319-85d3-8c3ae3c6f0ab" 1    .3060802 2
"05" "0205026" 12 "uuid:ac75e6f7-73ca-4657-bcae-d6a869dd2ff7" 1    .3092196 2
"14" "0514152"  6 "uuid:fda1d9e2-6779-4cfa-ad5b-23bb20e09bde" 1    .3130533 2
"21" "0821009" 12 "uuid:e61b8627-ee66-4c80-83af-617df928059a" 1    .3131619 2
"38" "1938008" 18 "uuid:ec029e1e-819e-4a02-b43c-5b89da97d206" 1    .3146883 2
"30" "1530037" 16 "uuid:d7f36a6c-dc2b-4c3b-8630-04e662e44da1" 1    .3159043 2
"08" "0308002" 12 "uuid:3d9daa25-850d-4498-b782-b34497a76e1f" 1    .3161242 2
"36" "1836016"  8 "uuid:d1f7ef20-7499-4de2-b00e-0e38ab110916" 1    .3165147 2
"36" "1836018" 12 "uuid:ca82fb5e-5de5-43f6-aa54-1674d4400ce5" 1    .3184295 2
"20" "0720007"  4 "uuid:ab770db6-4136-47c8-9162-49a61a024471" 1    .3193705 2
"38" "1938006" 10 "uuid:ebba755e-a898-45dc-b3ea-41a824fdf5e9" 1    .3208839 2
"14" "0514054"  8 "uuid:e203010b-6fe2-438a-8618-5d9a2bf2d456" 1    .3216643 2
"25" "1225028" 12 "uuid:ae194d5a-d8f9-4bbf-a6e8-cab066a59ab6" 1    .3237695 2
"33" "1633070" 11 "uuid:baf20416-a99a-4628-83db-0c4dd258b021" 1    .3249146 2
"08" "0308063" 16 "uuid:0774b0d3-1388-429c-a60d-34ef3207d13e" 1    .3284217 2
"41" "1941011"  8 "uuid:e00a4d04-86eb-4983-8f55-6dc16b863ef3" 1    .3290599 2
"25" "1225021" 12 "uuid:398dccf8-966a-4190-aaa6-9174cf505795" 1    .3305277 2
"15" "0515030"  6 "uuid:2d0bcb25-a6fc-49f0-9a72-e636e6493424" 1    .3305722 2
end

------------------ copy up to and including the previous line ------------------

Listed 200 out of 1136 observations

[FernandoRios]

the reason is the command sort.
try using the option "stable".

See these two examples:

clear
. set obs 1000
. gen x=_n
. gen x1=runiform()<.5

set seed 1
sort x1, stable
gen n1=_n
sort x

set seed 1
sort x1, stable
gen n2=_n
sort x
scatter n1 n2

clear
. set obs 1000
. gen x=_n
. gen x1=runiform()<.5

set seed 1
sort x1,  
gen n1=_n
sort x

set seed 1
sort x1,  
gen n2=_n
sort x

scatter n1 n2

HTH