Hello,
I have some data that I need to link to many other datasets.
However, in order to create a field to link on I need to concatenate the variable named code(see below) with the prefix "p".
I attempted to do so as follows:
gen p = "p"
egen Pseudo_ID = concat(p code)
However, the variable code is displayed as a scientific number e.g. 1.000e+1 and the created variable becomes p1.000e+11, but I need the created variable to have the non scientific value e.g. p100004512968. I have tried several ways of doing this but have not been successful. Code does not need to be a numeric data type, it would be better if it was string but with the non scientific display of the number.
Can anyone advise please?
I have some data that I need to link to many other datasets.
However, in order to create a field to link on I need to concatenate the variable named code(see below) with the prefix "p".
I attempted to do so as follows:
gen p = "p"
egen Pseudo_ID = concat(p code)
However, the variable code is displayed as a scientific number e.g. 1.000e+1 and the created variable becomes p1.000e+11, but I need the created variable to have the non scientific value e.g. p100004512968. I have tried several ways of doing this but have not been successful. Code does not need to be a numeric data type, it would be better if it was string but with the non scientific display of the number.
Can anyone advise please?
Code:
* Example generated by -dataex-. For more info, type help dataex clear input str64 m double code str7 Der_Financial_Year int RPStartDate str5 OrgSiteIDActualDelivery str4 AgeRPEndDate str10 lod float delivery_date "0CQZMICZC2SUHFR" 100004512968 "2021/22" 22705 "ZZ201" "34" " 3/16/2022" 22720 "02eb9ce3074537ce1664c1d196cb6c31a7c4b40a98a9cc2689eb12243e8f32cd" 100052001065 "2021/22" 22371 "ZZ201" "NULL" " 4/22/2021" 22392 "09BRDW4O12XC9MT" 100023186155 "2021/22" 22432 "ZZ201" "35" " 6/30/2021" 22461 "02XABUYEDFUSPSJ" 100052194005 "2021/22" 22493 "ZZ201" "38" " 8/18/2021" 22510 "07VIF89PJD4OWMF" 100013764191 "2021/22" 22705 "ZZ201" "32" " 3/14/2022" 22718 "0ARI2MGPVIT1PFN" 100007110370 "2021/22" 22677 "ZZ201" "35" " 2/4/2022" 22680 "0aa6cf161581873c146f9f0fc72d649f09f1d98b5a99d9d5a3dbc796a6e5dfc2" 100034529529 "2021/22" 22371 "ZZ201" "NULL" " 4/7/2021" 22377 "02VSMRBY10E13VP" 100029248479 "2021/22" 22677 "ZZ201" "26" " 2/25/2022" 22701 "01abd2695e9d4ed6644ffa01329e824d89be1fb563f256487cff4e3ffc2c10ea" 100025264383 "2021/22" 22371 "ZZ201" "NULL" " 4/8/2021" 22378 "071Z1TQ901IZ1UP" 100029376267 "2021/22" 22493 "ZZ201" "29" " 8/15/2021" 22507 "09OATI9H4VN18CK" 100064123323 "2021/22" 22646 "ZZ201" "31" " 1/15/2022" 22660 "048F2XZE3RCM75O" 100013144801 "2021/22" 22493 "ZZ201" "29" " 8/1/2021" 22493 "050R5DLPCEXK8UI" 100050219732 "2021/22" 22462 "ZZ201" "29" " 7/17/2021" 22478 "08e471864ce4cb0ad354a372667605c4cae482886724d27c02915e4ddf846f1c" 100003852968 "2021/22" 22371 "ZZ201" "NULL" " 4/6/2021" 22376 "00IBAGV4YCV68R9" 100013561228 "2021/22" 22615 "ZZ201" "33" " 12/8/2021" 22622 "00812136fca214b01bcc18222a58b208a57af3debe1c28a3143a177c8d98aec8" 100016010849 "2021/22" 22371 "ZZ201" "NULL" " 4/5/2021" 22375 "05MQPG4SKK9R8YO" 100023099970 "2021/22" 22646 "ZZ201" "31" " 1/22/2022" 22667 "04IRIDE3OX42F8E" 100049784479 "2021/22" 22585 "ZZ201" "28" "11/24/2021" 22608 "0TM5XGI6UOZ2PKL" 100029460961 "2021/22" 22585 "ZZ201" "28" "11/24/2021" 22608 "000I87ZBERQZPBM" 100044143737 "2021/22" 22432 "ZZ201" "27" " 6/22/2021" 22453 "00CNTMFQ632M481" 100054618460 "2021/22" 22493 "ZZ201" "36" " 8/6/2021" 22498 "08R9IAZORDYCEAD" 100052826758 "2021/22" 22401 "ZZ201" "31" " 5/13/2021" 22413 "026K48SL7IVA3FV" 100031575123 "2021/22" 22705 "ZZ201" "34" " 2/26/2022" 22702 "09b651d976a36afc07ba9ddd8796b4847f9aeaf697f416eaee23a29ad04319fe" 100038943058 "2021/22" 22371 "ZZ201" "NULL" " 4/12/2021" 22382 "02RR1884XBL5W79" 100026432975 "2021/22" 22462 "ZZ201" "40" " 7/26/2021" 22487 "0AB47JCJMNBGVV9" 100029066308 "2021/22" 22401 "ZZ201" "38" " 5/24/2021" 22424 "0QW3CN7AP0Q9PFP" 100020679391 "2021/22" 22705 "ZZ201" "24" " 3/30/2022" 22734 "0FABNKJMYTRPNIM" 100045029735 "2021/22" 22677 "ZZ201" "24" " 2/23/2022" 22699 "02b8c450ff12103122c528609372625f8ed0151a812aad26222806a7d1e9b422" 100658119130 "2021/22" 22371 "ZZ201" "NULL" " 4/25/2021" 22395 "0B5M5PZCLGJ73TH" 100063104085 "2021/22" 22493 "ZZ201" "37" " 8/23/2021" 22515 "0VV8H2VBTXRVKXB" 100046263473 "2021/22" 22462 "ZZ201" "37" " 7/20/2021" 22481 "01PSW6DY1ZZJK1X" 100057497601 "2021/22" 22554 "ZZ201" "33" " 10/5/2021" 22558 "02d1e3f484d5fc6880f6952a870acabbed7634589a56765df19ca07a5edf33ce" 100046038493 "2021/22" 22371 "ZZ201" "NULL" " 4/11/2021" 22381 "03BYS329YEZHZMO" 100039815339 "2021/22" 22493 "ZZ201" "37" " 8/5/2021" 22497 "00SV5U936Z2NP6T" 100648875850 "2021/22" 22585 "ZZ201" "37" " 11/7/2021" 22591 "04191BKPQ4UVKR4" 100023404018 "2021/22" 22462 "ZZ201" "27" " 7/17/2021" 22478 "05EXLWYLZUZ64BZ" 100067227472 "2021/22" 22524 "ZZ201" "26" " 9/28/2021" 22551 "03b4bfac687a9a76bc1d96c975d30c3484f52a356b37c1683dd7f708c1b5a925" 100006439941 "2021/22" 22371 "ZZ201" "NULL" " 4/14/2021" 22384 "05Q299GN993I148" 100035581335 "2021/22" 22462 "ZZ201" "37" " 7/10/2021" 22471 "02R7PCQ6ESZR5EC" 100033309588 "2021/22" 22646 "ZZ201" "28" "12/26/2021" 22640 "08db48367eeb9e69961b08078ca3f56408d7d2c5e186061ecf02f7712e58c763" 100018018688 "2021/22" 22371 "ZZ201" "NULL" " 4/28/2021" 22398 "01XJYM1US63B0TX" 100001389534 "2021/22" 22401 "ZZ201" "31" " 5/17/2021" 22417 "05TTTXYVQHTE5AY" 100018979525 "2021/22" 22493 "ZZ201" "35" " 8/8/2021" 22500 "03fb2620e193b6d0bdcc68bf0d51574724ff42d4ba78a48dea97bbd3a9dd3603" 100018989524 "2021/22" 22371 "ZZ201" "NULL" " 4/28/2021" 22398 "02POBDBHIF1O1IY" 100645991814 "2021/22" 22493 "ZZ201" "29" " 8/24/2021" 22516 "0GBVGUTFGABXZSB" 100057999652 "2021/22" 22585 "ZZ201" "39" "11/21/2021" 22605 "06X8A29A01VWV8A" 100044466694 "2021/22" 22585 "ZZ201" "36" "11/28/2021" 22612 "0A43D3FELXNYVCY" 100053925272 "2021/22" 22493 "ZZ201" "35" " 8/11/2021" 22503 "04YPUDUKWS6GOFR" 100055954339 "2021/22" 22677 "ZZ201" "33" " 2/4/2022" 22680 "09badc6e6eb7c552ef4c052d280e99940a9c6e80beb3282af04021c56396ae08" 100005884498 "2021/22" 22371 "ZZ201" "NULL" " 4/8/2021" 22378 "0DQ9QLNA0HB6EIN" 100052519845 "2021/22" 22432 "ZZ201" "42" "NULL" . "07d2039a2a75494bbb30797a3e0d1cd234b566b5f3a8c9a66ea984e0a18ff276" 100054102787 "2021/22" 22371 "ZZ201" "NULL" " 4/21/2021" 22391 "05D4OKW4ETNAJIB" 100018539467 "2021/22" 22432 "ZZ201" "33" " 6/14/2021" 22445 "03FYIPSPLVXMXR8" 100031789797 "2021/22" 22493 "ZZ201" "35" " 8/19/2021" 22511 "0905b3e52bb568a78903dee75118f90724f935aa5e213d9137165271123a074c" 100006659848 "2021/22" 22371 "ZZ201" "NULL" " 4/7/2021" 22377 "0ed982d7ccf4eee2d6e427eccb6df81e6eebea9ab5b275c3c407ce6c1b6d3988" 100062273389 "2021/22" 22371 "ZZ201" "NULL" " 4/6/2021" 22376 "08bddd4537a7f67c8b06cfc6ad4ae1b34cb84d4dfe12cde5875a30e1e3cd8627" 100008133633 "2021/22" 22371 "ZZ201" "NULL" " 4/30/2021" 22400 "03T04W0HP8VHVFC" 100049806273 "2021/22" 22524 "ZZ201" "28" " 9/14/2021" 22537 "07JFU957OXPPL6B" 100013628426 "2021/22" 22585 "ZZ201" "29" "11/14/2021" 22598 "066X0DQ3WY2HUFA" 100059714528 "2021/22" 22493 "ZZ201" "26" " 8/30/2021" 22522 "0DR77THG5QRONJ1" 100019196539 "2021/22" 22432 "ZZ201" "40" " 6/20/2021" 22451 "0HMWRTD73FKX7AK" 100027944991 "2021/22" 22432 "ZZ201" "32" " 6/13/2021" 22444 "0MMXGZUCKTFPH95" 100037760303 "2021/22" 22493 "ZZ201" "31" " 8/15/2021" 22507 "05RNSN7X4OARMY8" 100014592201 "2021/22" 22401 "ZZ201" "40" " 5/7/2021" 22407 "0G0VHZ5HYMCUTGL" 100052328610 "2021/22" 22585 "ZZ201" "28" " 11/9/2021" 22593 "0eec6b4b1c3f0bc5e0f8bba71b192558efe09b62e51ff0e9cea374b21d445df5" 100048488962 "2021/22" 22371 "ZZ201" "NULL" " 4/1/2021" 22371 "0AYR8OF8HT8ZL3O" 100063238496 "2021/22" 22401 "ZZ201" "35" " 5/1/2021" 22401 "08096723a1bd1c8eea81b4514a0792b2775c75493e43f0041c945b6529ea8f7d" 100058762638 "2021/22" 22371 "ZZ201" "NULL" " 4/2/2021" 22372 "0A3PRUBCJQLA9CF" 100020773954 "2021/22" 22401 "ZZ201" "26" " 5/12/2021" 22412 "0M63T1ADWX30GSJ" 100003743100 "2021/22" 22432 "ZZ201" "37" " 6/3/2021" 22434 "0BL1U06P9J6U2XS" 100050137033 "2021/22" 22554 "ZZ201" "41" "10/21/2021" 22574 "0BQYE57GRT2Z1SG" 100009062198 "2021/22" 22554 "ZZ201" "29" "10/10/2021" 22563 "069b0fe9c89601ee3f2b0a50c6f50d85f0df28a66ae41eae914db922cff3e4b1" 100045367874 "2021/22" 22371 "ZZ201" "NULL" " 4/23/2021" 22393 "10ZLN0U5TLS746M" 100032761776 "2021/22" 22493 "ZZ201" "37" " 8/6/2021" 22498 "09WY88IIMU6QDWZ" 100035237815 "2021/22" 22462 "ZZ201" "32" " 7/17/2021" 22478 "0PK5ZVJAMHGKDMO" 100049026025 "2021/22" 22677 "ZZ201" "34" " 2/18/2022" 22694 "0O1XDNRH70BX9W4" 100034145914 "2021/22" 22462 "ZZ201" "37" " 7/24/2021" 22485 "07e7ab91a3e4e5723700b36c4038c90de23ce38a87da63a9165aabf1699ff74a" 100015348520 "2021/22" 22371 "ZZ201" "NULL" " 4/16/2021" 22386 "0UKRWF5I5ENMQAR" 100066947480 "2021/22" 22585 "ZZ201" "33" "11/30/2021" 22614 "0O12GL2BYABMW76" 100008155938 "2021/22" 22646 "ZZ201" "28" " 1/1/2022" 22646 "14DAGRHSJC81DWY" 100037083347 "2021/22" 22432 "ZZ201" "23" " 6/17/2021" 22448 "12ff859a3d86c01180cf5f95d326cfbc002f9a620e4031884a4c13016175db67" 100032830601 "2021/22" 22371 "ZZ201" "NULL" " 4/9/2021" 22379 "0e4811c406569e9fa1c25b54e0b9c22e211a8ef349e4dcc18eaf425e49eb104d" 100041246071 "2021/22" 22371 "ZZ201" "NULL" " 4/6/2021" 22376 "147SSP9TPJV31DV" 100062294758 "2021/22" 22677 "ZZ201" "22" " 2/4/2022" 22680 "0AD67E0D8R5V8I0" 100046821514 "2021/22" 22524 "ZZ201" "37" " 9/14/2021" 22537 "1E4150X7X0HDMG0" 100013422369 "2021/22" 22462 "ZZ201" "30" " 7/30/2021" 22491 "0V8P7RVCA0H3PWK" 100047725707 "2021/22" 22493 "ZZ201" "33" " 7/7/2021" 22468 "0IT0MNLBAPMFMJ8" 100046912037 "2021/22" 22432 "ZZ201" "39" " 6/19/2021" 22450 "063YOV4RCFUO55C" 100007135618 "2021/22" 22401 "ZZ201" "39" " 5/31/2021" 22431 "0ITO4A38IP2DT5X" 100012570905 "2021/22" 22677 "ZZ201" "34" " 2/1/2022" 22677 "1JNM0CWPNLJTKSM" 100028716384 "2021/22" 22401 "ZZ201" "27" " 5/27/2021" 22427 "0BPUIHV8V11DRP2" 100001667679 "2021/22" 22462 "ZZ201" "34" " 7/14/2021" 22475 "0DIDPHIDJ3G3PY7" 100035399003 "2021/22" 22432 "ZZ201" "31" " 6/27/2021" 22458 "09WLZVVQ11EWX5Z" 100041589511 "2021/22" 22493 "ZZ201" "34" " 8/26/2021" 22518 "032O3VFPK9KUXGM" 100070357210 "2021/22" 22462 "ZZ201" "20" " 7/8/2021" 22469 "075636701067d980d45da876a4c459cd87cebb9edc92a41c390cb0fcd179e402" 100058406661 "2021/22" 22371 "ZZ201" "NULL" " 4/25/2021" 22395 "0c89f0d95351db2ceda1a0b673146cebaf236eb67e1d1a3052cfa32fa8889692" 100025568803 "2021/22" 22371 "ZZ201" "NULL" " 4/5/2021" 22375 "05c4188f388b3e93db979fc5bdb2d0aa550373812a9431d80a7b53cfb39dbbb8" 100007212936 "2021/22" 22371 "ZZ201" "NULL" " 4/26/2021" 22396 "0GGE50LMJDSY26P" 100019094178 "2021/22" 22493 "ZZ201" "34" " 8/25/2021" 22517 "09B5IU19TL3GLQK" 100030283402 "2021/22" 22524 "ZZ201" "31" " 9/15/2021" 22538 end format %tdnn/dd/CCYY RPStartDate format %td delivery_date
Comment