I want to destring the variable market_return. Since it contains different "chars" for different observations, I am finding it difficult to implement destring.
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input int date str45 market_return str12 company_id 20454 "$$ER: E100,INVALID CODE OR EXPRESSION ENTERED" "" 20454 "0" "CH0002178348" 20454 "0" "CH0012815459" 20454 "$$ER: 2308,NO DATA TO RETURN" "" 20454 "0" "CY0100120910" 20454 "0" "CY0100962113" 20454 "0" "CY0101162119" 20454 "$$ER: E100,INVALID CODE OR EXPRESSION ENTERED" "" 20454 "0" "DE0005141907" 20454 "0" "DE0005227201" 20454 "0" "DE0005493514" 20454 "0" "DE0006048267" 20454 "0" "DE0006053952" 20454 "0" "DE0006601602" 20454 "0" "DE0006778905" 20454 "0" "DE0008086000" 20454 "0" "DE0008114323" 20454 "0" "DE000A0B95Y8" 20454 "0" "DE000A0MSEQ3" 20454 "0" "DE000A13STW4" 20454 "0" "DE000A1X3X33" 20454 "0" "DE000A1YCMM2" 20454 "0" "DE000A2E3707" 20454 "0" "DK0015312474" 20454 "$$ER: E100,INVALID CODE OR EXPRESSION ENTERED" "" 20454 "$$ER: E100,INVALID CODE OR EXPRESSION ENTERED" "" 20454 "$$ER: E100,INVALID CODE OR EXPRESSION ENTERED" "" 20454 "$$ER: E100,INVALID CODE OR EXPRESSION ENTERED" "" 20454 "$$ER: E100,INVALID CODE OR EXPRESSION ENTERED" "" 20454 "$$ER: E100,INVALID CODE OR EXPRESSION ENTERED" "" 20454 "$$ER: E100,INVALID CODE OR EXPRESSION ENTERED" "" 20454 "$$ER: E100,INVALID CODE OR EXPRESSION ENTERED" "" 20454 "$$ER: E100,INVALID CODE OR EXPRESSION ENTERED" "" 20454 "$$ER: E100,INVALID CODE OR EXPRESSION ENTERED" "" 20454 "$$ER: E100,INVALID CODE OR EXPRESSION ENTERED" "" 20454 "$$ER: E100,INVALID CODE OR EXPRESSION ENTERED" "" 20454 "$$ER: E100,INVALID CODE OR EXPRESSION ENTERED" "" 20454 "$$ER: E100,INVALID CODE OR EXPRESSION ENTERED" "" 20454 "$$ER: E100,INVALID CODE OR EXPRESSION ENTERED" "" 20454 "$$ER: E100,INVALID CODE OR EXPRESSION ENTERED" "" 20454 "$$ER: E100,INVALID CODE OR EXPRESSION ENTERED" "" 20454 "$$ER: E100,INVALID CODE OR EXPRESSION ENTERED" "" 20454 "0" "ES0105026001" 20454 "0" "ES0113790226" 20454 "0" "ES0119037010" 20454 "$$ER: E100,INVALID CODE OR EXPRESSION ENTERED" "" 20454 "$$ER: E100,INVALID CODE OR EXPRESSION ENTERED" "" 20454 "$$ER: E100,INVALID CODE OR EXPRESSION ENTERED" "" 20454 "$$ER: E100,INVALID CODE OR EXPRESSION ENTERED" "" 20454 "$$ER: E100,INVALID CODE OR EXPRESSION ENTERED" "" 20454 "0" "FI0009006381" 20454 "0" "FI0009008221" 20454 "0" "FI0009900336" 20454 "0" "FI4000157235" 20454 "0" "FR0000030827" 20454 "0" "FR0000038200" 20454 "0" "FR0000053514" 20454 "0" "FR0000061053" 20454 "0" "FR0000063091" 20454 "0" "FR0000075673" 20454 "0" "FR0000076994" 20454 "0" "FR0000121881" 20454 "0" "FR0000125684" 20454 "0" "FR0004042083" 20454 "0" "FR0004060671" 20454 "0" "FR0004176535" 20454 "0" "FR0010213215" 20454 "0" "FR0010263202" 20454 "0" "FR0010282822" 20454 "0" "FR0010396119" 20454 "0" "FR0010921163" 20454 "0" "FR0011284991" 20454 "0" "FR0013182235" 20454 "0" "GB0000031285" 20454 "0" "GB0000282623" 20454 "0" "GB0000608009" 20454 "0" "GB0001083137" 20454 "0" "GB0003083622" 20454 "0" "GB0009303123" 20454 "0" "GB0009422543" 20454 "0" "GB0009463752" 20454 "0" "GB0033495515" 20454 "0" "GB00B011QL44" 20454 "0" "GB00B01TND91" 20454 "0" "GB00B07W3X22" 20454 "0" "GB00B07XR777" 20454 "0" "GB00B09Y5410" 20454 "0" "GB00B0F99717" 20454 "0" "GB00B0ZSH635" 20454 "0" "GB00B1YMRB82" 20454 "0" "GB00B40SF849" 20454 "0" "GB00B97CW509" 20454 "0" "GB00BFRBTP86" 20454 "0" "GB00BKY7HG11" 20454 "0" "GB00BLG2TG58" 20454 "0" "GB00BQPW6Y82" 20454 "0" "GB00BQQMCJ47" 20454 "0" "GB00BQXKYQ29" 20454 "0" "GB00BRTL8Q42" 20454 "0" "GB00BYYK2V80" end format %td date
Comment