topic recoding of the variable in SAS Programming https://communities.sas.com/t5/SAS-Programming/recoding-of-the-variable/m-p/823611#M325216 <P>dear all,</P><P>&nbsp;i have the data in the following format&nbsp;</P><TABLE><TBODY><TR><TD>company_name</TD><TD>Year</TD><TD>investor_name</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Gujarat Venture Capital Fund-1995</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Narendra Manibhai Patel</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2010</TD><TD>Emirates Bank International Pjsc</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2010</TD><TD>Lic Of India Money Plus</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2010</TD><TD>Lic Of India Money Plus -1</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2010</TD><TD>Life Insurance Corporation Of India Ltd</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2010</TD><TD>Norges Bank A/C Government Petroleum Fund</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2010</TD><TD>Reliance Capital Trustee Co Ltd A/C Reliance Equity Opportunities Fund</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2010</TD><TD>Reliance Capital Trustee Co Ltd A/C Reliance Regular Saving Fund Equity Option</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2010</TD><TD>Reliance Capital Trustee Co Ltd Reliance Long Term Equity Fund</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2010</TD><TD>Sundaram Bnp Paribas Mutual Fund A/C Sudaram Bnp Paribas Equity Multiplier Fun</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2010</TD><TD>Swiss Finance Corporation Mauritius Ltd</TD></TR><TR><TD>3M India Ltd.</TD><TD>2010</TD><TD>Acacia Institutional Partners Lp</TD></TR><TR><TD>3M India Ltd.</TD><TD>2010</TD><TD>Acacia Partners Lp</TD></TR><TR><TD>3M India Ltd.</TD><TD>2010</TD><TD>Bright Star Investments Pvt Ltd</TD></TR><TR><TD>3M India Ltd.</TD><TD>2010</TD><TD>Hdfc Trustee Company Ltd - Hdfc Prudence Fund</TD></TR><TR><TD>3M India Ltd.</TD><TD>2010</TD><TD>Tata Offshore India Opportunities Scheme</TD></TR><TR><TD>3P Land Holdings Ltd.</TD><TD>2010</TD><TD>Deep Star Investment &amp; Finance Co Pvt Ltd</TD></TR><TR><TD>3P Land Holdings Ltd.</TD><TD>2010</TD><TD>Santosh S Goenka</TD></TR><TR><TD>3P Land Holdings Ltd.</TD><TD>2010</TD><TD>Shree Global Tradefin Ltd</TD></TR><TR><TD>52 Weeks Entertainment Ltd.</TD><TD>2010</TD><TD>Alpic Finance Ltd</TD></TR><TR><TD>52 Weeks Entertainment Ltd.</TD><TD>2010</TD><TD>Dr Hemant Thacker</TD></TR><TR><TD>52 Weeks Entertainment Ltd.</TD><TD>2010</TD><TD>Jainam Sec Pvt Ltd</TD></TR><TR><TD>52 Weeks Entertainment Ltd.</TD><TD>2010</TD><TD>Suman L Shah</TD></TR><TR><TD>52 Weeks Entertainment Ltd.</TD><TD>2010</TD><TD>Winever Investment &amp; Consultants Pvt Ltd</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2010</TD><TD>Acacia Institutional Partners Lp</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2010</TD><TD>Acacia Partners Lp</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2010</TD><TD>Aic Advantage Fund</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2010</TD><TD>Bharat K. Sheth</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2010</TD><TD>Deutsche Securities Mauritius Ltd</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2010</TD><TD>Fid Funds Mauritius Ltd</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2010</TD><TD>Passport Capital Llc A/C Passport India Investments Mauritius Ltd</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2010</TD><TD>Pivotal Securities Pvt Ltd</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2010</TD><TD>Ravi K. Sheth</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2010</TD><TD>Reliance Capital Trustee Company Ltd A/C Reliance Equity Fund</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2010</TD><TD>Reliance Capital Trustee Company Ltd A/C Reliance Growth Fund</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2010</TD><TD>Reliance Capital Trustee Company Ltd A/C Reliance Vision Fund</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2010</TD><TD>Reliance Life Insurance Company Ltd</TD></TR><TR><TD>A B B India Ltd.</TD><TD>2010</TD><TD>Aberdeen Asset Managers Ltd A/C Aberdeen Global Indian Fund Mauitius Ltd</TD></TR><TR><TD>A B B India Ltd.</TD><TD>2010</TD><TD>General Insurance Corporation Of India</TD></TR><TR><TD>A B B India Ltd.</TD><TD>2010</TD><TD>Icici Prudential Life Insurance Company Ltd</TD></TR><TR><TD>A B B India Ltd.</TD><TD>2010</TD><TD>Lic Of India Market Plus</TD></TR><TR><TD>A B B India Ltd.</TD><TD>2010</TD><TD>Lic Of India Money Plus</TD></TR><TR><TD>A B B India Ltd.</TD><TD>2010</TD><TD>Life Insurance Corporation Of India</TD></TR><TR><TD>A B B India Ltd.</TD><TD>2010</TD><TD>Life Insurance Corporation Of India Profit Plus</TD></TR><TR><TD>A B C Gas (International) Ltd.</TD><TD>2010</TD><TD>Canbank Financial Services Ltd</TD></TR><TR><TD>A B C Gas (International) Ltd.</TD><TD>2010</TD><TD>Naresh K Aggarwala</TD></TR><TR><TD>A B C Gas (International) Ltd.</TD><TD>2010</TD><TD>Savasthi Investment Ltd</TD></TR><TR><TD>A B C Gas (International) Ltd.</TD><TD>2010</TD><TD>St. Helens Nominees India Pvt Ltd</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I have to recode the variable "investor_name" into "1" if the&nbsp; variable contains any of below mentioned words or else "0"&nbsp;</P><TABLE><TBODY><TR><TD><P>“Investment”</P></TD><TD><P>&nbsp;“Ltd”</P></TD><TD><P>“Pvt”</P></TD><TD><P>“India”</P></TD><TD><P>“Lic”</P></TD><TD><P>“Bank”</P></TD><TD><P>“Securities”</P></TD></TR><TR><TD><P>“Corporation”</P></TD><TD><P>&nbsp;“Fund”</P></TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>please suggest to me a suitable SAS code for this purpose</P><P>thanking you in advance&nbsp;</P> Sat, 16 Jul 2022 06:36:28 GMT srikanthyadav44 2022-07-16T06:36:28Z recoding of the variable https://communities.sas.com/t5/SAS-Programming/recoding-of-the-variable/m-p/823611#M325216 <P>dear all,</P><P>&nbsp;i have the data in the following format&nbsp;</P><TABLE><TBODY><TR><TD>company_name</TD><TD>Year</TD><TD>investor_name</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Gujarat Venture Capital Fund-1995</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Narendra Manibhai Patel</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2010</TD><TD>Emirates Bank International Pjsc</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2010</TD><TD>Lic Of India Money Plus</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2010</TD><TD>Lic Of India Money Plus -1</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2010</TD><TD>Life Insurance Corporation Of India Ltd</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2010</TD><TD>Norges Bank A/C Government Petroleum Fund</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2010</TD><TD>Reliance Capital Trustee Co Ltd A/C Reliance Equity Opportunities Fund</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2010</TD><TD>Reliance Capital Trustee Co Ltd A/C Reliance Regular Saving Fund Equity Option</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2010</TD><TD>Reliance Capital Trustee Co Ltd Reliance Long Term Equity Fund</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2010</TD><TD>Sundaram Bnp Paribas Mutual Fund A/C Sudaram Bnp Paribas Equity Multiplier Fun</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2010</TD><TD>Swiss Finance Corporation Mauritius Ltd</TD></TR><TR><TD>3M India Ltd.</TD><TD>2010</TD><TD>Acacia Institutional Partners Lp</TD></TR><TR><TD>3M India Ltd.</TD><TD>2010</TD><TD>Acacia Partners Lp</TD></TR><TR><TD>3M India Ltd.</TD><TD>2010</TD><TD>Bright Star Investments Pvt Ltd</TD></TR><TR><TD>3M India Ltd.</TD><TD>2010</TD><TD>Hdfc Trustee Company Ltd - Hdfc Prudence Fund</TD></TR><TR><TD>3M India Ltd.</TD><TD>2010</TD><TD>Tata Offshore India Opportunities Scheme</TD></TR><TR><TD>3P Land Holdings Ltd.</TD><TD>2010</TD><TD>Deep Star Investment &amp; Finance Co Pvt Ltd</TD></TR><TR><TD>3P Land Holdings Ltd.</TD><TD>2010</TD><TD>Santosh S Goenka</TD></TR><TR><TD>3P Land Holdings Ltd.</TD><TD>2010</TD><TD>Shree Global Tradefin Ltd</TD></TR><TR><TD>52 Weeks Entertainment Ltd.</TD><TD>2010</TD><TD>Alpic Finance Ltd</TD></TR><TR><TD>52 Weeks Entertainment Ltd.</TD><TD>2010</TD><TD>Dr Hemant Thacker</TD></TR><TR><TD>52 Weeks Entertainment Ltd.</TD><TD>2010</TD><TD>Jainam Sec Pvt Ltd</TD></TR><TR><TD>52 Weeks Entertainment Ltd.</TD><TD>2010</TD><TD>Suman L Shah</TD></TR><TR><TD>52 Weeks Entertainment Ltd.</TD><TD>2010</TD><TD>Winever Investment &amp; Consultants Pvt Ltd</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2010</TD><TD>Acacia Institutional Partners Lp</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2010</TD><TD>Acacia Partners Lp</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2010</TD><TD>Aic Advantage Fund</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2010</TD><TD>Bharat K. Sheth</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2010</TD><TD>Deutsche Securities Mauritius Ltd</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2010</TD><TD>Fid Funds Mauritius Ltd</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2010</TD><TD>Passport Capital Llc A/C Passport India Investments Mauritius Ltd</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2010</TD><TD>Pivotal Securities Pvt Ltd</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2010</TD><TD>Ravi K. Sheth</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2010</TD><TD>Reliance Capital Trustee Company Ltd A/C Reliance Equity Fund</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2010</TD><TD>Reliance Capital Trustee Company Ltd A/C Reliance Growth Fund</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2010</TD><TD>Reliance Capital Trustee Company Ltd A/C Reliance Vision Fund</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2010</TD><TD>Reliance Life Insurance Company Ltd</TD></TR><TR><TD>A B B India Ltd.</TD><TD>2010</TD><TD>Aberdeen Asset Managers Ltd A/C Aberdeen Global Indian Fund Mauitius Ltd</TD></TR><TR><TD>A B B India Ltd.</TD><TD>2010</TD><TD>General Insurance Corporation Of India</TD></TR><TR><TD>A B B India Ltd.</TD><TD>2010</TD><TD>Icici Prudential Life Insurance Company Ltd</TD></TR><TR><TD>A B B India Ltd.</TD><TD>2010</TD><TD>Lic Of India Market Plus</TD></TR><TR><TD>A B B India Ltd.</TD><TD>2010</TD><TD>Lic Of India Money Plus</TD></TR><TR><TD>A B B India Ltd.</TD><TD>2010</TD><TD>Life Insurance Corporation Of India</TD></TR><TR><TD>A B B India Ltd.</TD><TD>2010</TD><TD>Life Insurance Corporation Of India Profit Plus</TD></TR><TR><TD>A B C Gas (International) Ltd.</TD><TD>2010</TD><TD>Canbank Financial Services Ltd</TD></TR><TR><TD>A B C Gas (International) Ltd.</TD><TD>2010</TD><TD>Naresh K Aggarwala</TD></TR><TR><TD>A B C Gas (International) Ltd.</TD><TD>2010</TD><TD>Savasthi Investment Ltd</TD></TR><TR><TD>A B C Gas (International) Ltd.</TD><TD>2010</TD><TD>St. Helens Nominees India Pvt Ltd</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I have to recode the variable "investor_name" into "1" if the&nbsp; variable contains any of below mentioned words or else "0"&nbsp;</P><TABLE><TBODY><TR><TD><P>“Investment”</P></TD><TD><P>&nbsp;“Ltd”</P></TD><TD><P>“Pvt”</P></TD><TD><P>“India”</P></TD><TD><P>“Lic”</P></TD><TD><P>“Bank”</P></TD><TD><P>“Securities”</P></TD></TR><TR><TD><P>“Corporation”</P></TD><TD><P>&nbsp;“Fund”</P></TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>please suggest to me a suitable SAS code for this purpose</P><P>thanking you in advance&nbsp;</P> Sat, 16 Jul 2022 06:36:28 GMT https://communities.sas.com/t5/SAS-Programming/recoding-of-the-variable/m-p/823611#M325216 srikanthyadav44 2022-07-16T06:36:28Z Re: recoding of the variable https://communities.sas.com/t5/SAS-Programming/recoding-of-the-variable/m-p/823616#M325219 <P>One way to go:</P> <PRE><CODE class=" language-sas">data demo; infile datalines truncover; input investor_name $100.; match_flag=prxmatch('/\b(Investment|Ltd|Pvt|Fund)\b/i',strip(investor_name))&gt;0; datalines; Gujarat Venture Capital Fund-1995 Narendra Manibhai Patel test fundraiser test ; proc print data=demo; run;</CODE></PRE> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Patrick_0-1657959696233.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/73356iE569282A2F295F8F/image-size/medium?v=v2&amp;px=400" role="button" title="Patrick_0-1657959696233.png" alt="Patrick_0-1657959696233.png" /></span></P> <P>&nbsp;</P> Sat, 16 Jul 2022 08:21:43 GMT https://communities.sas.com/t5/SAS-Programming/recoding-of-the-variable/m-p/823616#M325219 Patrick 2022-07-16T08:21:43Z Re: recoding of the variable https://communities.sas.com/t5/SAS-Programming/recoding-of-the-variable/m-p/823630#M325227 <P>You could set up an array of search terms:</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">data want (drop=i); set have; array invterms {9} $12 _temporary_ ("Investment","Ltd","Pvt","India","Lic","Bank","Securities","Corporation","Fund"); do i=1 to dim(invterms) until (match_flag&gt;0); match_flag=(findw(investor_name,trim(invterms{i}))&gt;0); end; run; </CODE></PRE> Sat, 16 Jul 2022 11:59:08 GMT https://communities.sas.com/t5/SAS-Programming/recoding-of-the-variable/m-p/823630#M325227 mkeintz 2022-07-16T11:59:08Z Re: recoding of the variable https://communities.sas.com/t5/SAS-Programming/recoding-of-the-variable/m-p/823682#M325253 thanks. it is working Sun, 17 Jul 2022 07:51:23 GMT https://communities.sas.com/t5/SAS-Programming/recoding-of-the-variable/m-p/823682#M325253 srikanthyadav44 2022-07-17T07:51:23Z