Thanks Jagadish for the code. If I need to create another variable, GRAD, that takes value 1 if the executive has a masters degree in accounting, finance, or economics; 2 if the degree is in field other than accounting, finance, or economics; and 3 if the field is missing, how should I modified the above code? Also from the subset of data, I need to create a new variable, CPA, that takes value 1 if the executive is a CPA or certified public accountant. The subsample is as follows: Derek Burke Mr. Derek C. Burke is Founder of WBQ Design & Engineering Inc. and serves as its President. Mr. Burke is a licensed professional engineer. He served as the Chairman of the City of Orlando Downtown Development Board and Community Redevelopment Agency Advisory Board. He has been a Director of 1st United Bancorp, Inc., since April 1, 2012. He has been a Director of Old Harbor Bank since April 2012. He serves as a Director at Anderen Bank, a subsidiary of Anderen Financial, Inc. Mr. Burke also serves on the Board of the Orlando Neighborhood Development Corporation. Mr. Burke served as a Director of Florida Choice Bankshares, Inc. and Florida Choice Bank from January 2005 to January 2008. He has been the president of the Orlando-based consulting firm WBQ Design & Engineering, Inc. since its founding in 1994. He served as Director of Southern Community Bank until its acquisition by First National Bank of Florida. Mr. Burke is also a noted civic leader who has served on several Committees and Boards. Mr. Burke is highly respected in the engineering community and was nominated for the 2008 Central Florida Engineer's Week Leadership Excellence award. He holds a Master's degree in civil engineering from the University of Central Florida in June 1988. william dean Mr. William Dean Karrash, CPA serves as an Executive Vice President of Burke, Lawton, Brewer & Burke, LLC. Mr. Karrash serves as Chief Compliance Officer at Venture Securities Corp. Mr. Karrash  was Advisory Director of Abraxas Petroleum Corp. from November 2011 to May 2012.  He serves as Portfolio Manager of BLB & B Advisors, LLC. He has over 20 years of experience in the financial services industry. Mr. Karrash served as the President and Chief Executive Officer of Rutherford, Brown & Catherwood, LLC. He served as Executive Vice President and Chief Financial Officer of Walnut Asset Management, LLC. He also served as Vice President of Finance for Lincoln Investment Planning, Inc. and was a Senior Manager with Pricewaterhouse Coopers. He served as Chairman of FINRA's District No. 9 Business Conduct and Nominating Committees. He has been a Director of Abraxas Petroleum Corp. since May 2012. Mr. Karrash is a member of FINRA's Small Firm Advisory Board (SFAB) and the Financial Responsibility committee. He has also served as a member of First Clearing, LLC's Correspondent Advisory Board. Mr. Karrash is a CPA, CPF, and is registered with FINRA as a General Securities Registered Representative (Series 7), a General Securities Principal (Series 24), a Municipal Securities Principal (Series 53), and an Investment Advisor Representative (series 65). Mr. Karrash is a 1996 graduate of the Temple University Executive M.B.A. program and a 1983 graduate of Pennsylvania State University where he obtained a B.S. in Accounting. james andersen Mr. R. James Andersen, Jim, CA, CPA (Illinois), CFP has been the Chief Financial Officer and Vice President of Finance at Avalon Rare Metals Inc. since June 2001. Mr. Andersen has been a Partner of Forbes Andersen LLP for nine years. He is a Partner of the Toronto accounting firm Andersen and Company PC. He founded Andersen & Company, PC and served as its President from January 2007 to October 2011. He served as Chief Financial Officer of Highvista Gold Inc. until October 6, 2011. He served as the Chief Financial Officer of Pele Mountain Resources Inc. from May 9, 2007 to September 30, 2011 and served as its Vice President of Finance. He served as the Chief Financial Officer and Secretary of Triumph Ventures Corp. until October 2011. He has more than 15 years of experience in public practice, and a wide variety of experience in small-cap companies. He served as the Chief Financial Officer of Baymount Incorp. from September 2005 to June 2010 and served as its Vice President of Finance since September 2005. He served as an Interim Secretary and Chief Financial Officer of Phantom Fiber Corp. since April 20, 2005. He served as the Chief Financial Officer and Vice President of Finance at Academy Capital Corp. since September 12, 2005. He served as the Chief Financial Officer of Kilo Goldmines, Inc. Mr. Andersen served as the Chief Financial Officer and Vice President of Finance of Macusani Yellowcake Inc. from May 29, 2007 to September 11, 2008. He served as a Director of Triumph Ventures Corp. from January 2010 to October 2011. He is experienced in mining accounting as well as corporate governance rules and regulations. He served as a Director of Macusani Yellowcake Inc. He was a part-time professor in the MBA program at the Schulich School of Business at York University. Mr. Andersen is also a Certified Public Accountant. He holds generic degree with high distinction from Trinity College at the University of Toronto in 1991 and placed 20th in Ontario on the CICA's Uniform Final Exam in 1992. Wade D. Miquelon Mr. Wade D. Miquelon has been the Chief Financial Officer of Walgreen Co. since June 16, 2008 and has been its Executive Vice President since July 2009. Mr. Miquelon has also been President of International at Walgreen Co. since September 17, 2012. He joined Walgreen Co. on June 16, 2008 as Senior Vice President and was responsible for its accounting, tax and treasury functions, including investor relations. Prior to Walgreens, he served as the Chief Financial Officer and Executive Vice President of Tyson Foods Inc. from June 29, 2006 to May 12, 2008 and was responsible for its worldwide finance and accounting functions. From 1989 to 2006, Mr. Miquelon served at Procter & Gamble as Vice President of Finance, Western Europe. He served as the senior most financial officer of P&G and was responsible for the 17-country Western Europe operation. He also served as the Chief Financial Officer and Senior Director for P&G's 42 country ASEAN, Australia and India region based in Singapore. He served as the Head of Finance and Accounting for the ASEAN, Australasia, and India region, and served as a Director and Investment Partner of I Venturesd. Mr. Miquelon co-founded Emmperative Marketing, Inc. and served as its Chief Financial Officer and Senior Vice President of Business Development and Human Resources. He has been a Director of Alliance Boots GMBH since August 2, 2012. Mr. Miquelon has been a Director of Acadia Healthcare Company, Inc. since January 19, 2011. He serves as a Member of The Board of The Lyric Opera of Chicago and the Shedd Aquarium in Chicago. He also serves as a Member of the Dean s Advisory Board for the Sam M. Walton College of Business, University of Arkansas. Mr. Miquelon holds a Bachelor of Science Degree in Civil Engineering from Purdue University in 1987 and an M.B.A. in Finance and Marketing from Washington University in 1989. Arthur S. Locke, III Mr. Arthur S. Locke, Art, III served as the Chief Financial Officer and Senior Vice President of Websense, Inc. from July 31, 2009 to August 2011 and also served as its Principal Accounting Officer until August 2011. Mr. Locke served as the Chief Financial Officer of Microstrategy Inc. since January 2005 until March 2009 and served as its Executive Vice President of Finance until March 25, 2009. Mr. Locke served as Vice President of Finance of Microstrategy Inc. since ... January 2005 and served as its Principal Accounting Officer. Prior to joining MicroStrategy Inc., Mr. Locke served as Chief Financial Officer of Metropolitan Area Networks, a start-up wireless broadband company, from February 2000 to January 2001, and as corporate controller of EIS International, Inc., from March 1997 to February 2000. Mr. Locke is a certified public accountant and holds a Bachelor of Science in Business Administration (BSBA) in Accounting and Computer Systems from American University. From this the output should look like Name Biography cpa Derek Burke Mr. Derek C. Burke is Founder of WBQ Design & Engineering Inc. and serves as its President. Mr. Burke is a licensed professional engineer. He served as the Chairman of the City of Orlando Downtown Development Board and Community Redevelopment Agency Advisory Board. He has been a Director of 1st United Bancorp, Inc., since April 1, 2012. He has been a Director of Old Harbor Bank since April 2012. He serves as a Director at Anderen Bank, a subsidiary of Anderen Financial, Inc. Mr. Burke also serves on the Board of the Orlando Neighborhood Development Corporation. Mr. Burke served as a Director of Florida Choice Bankshares, Inc. and Florida Choice Bank from January 2005 to January 2008. He has been the president of the Orlando-based consulting firm WBQ Design & Engineering, Inc. since its founding in 1994. He served as Director of Southern Community Bank until its acquisition by First National Bank of Florida. Mr. Burke is also a noted civic leader who has served on several Committees and Boards. Mr. Burke is highly respected in the engineering community and was nominated for the 2008 Central Florida Engineer's Week Leadership Excellence award. He holds a Master's degree in civil engineering from the University of Central Florida in June 1988. 0 william dean Mr. William Dean Karrash, CPA serves as an Executive Vice President of Burke, Lawton, Brewer & Burke, LLC. Mr. Karrash serves as Chief Compliance Officer at Venture Securities Corp. Mr. Karrash  was Advisory Director of Abraxas Petroleum Corp. from November 2011 to May 2012.  He serves as Portfolio Manager of BLB & B Advisors, LLC. He has over 20 years of experience in the financial services industry. Mr. Karrash served as the President and Chief Executive Officer of Rutherford, Brown & Catherwood, LLC. He served as Executive Vice President and Chief Financial Officer of Walnut Asset Management, LLC. He also served as Vice President of Finance for Lincoln Investment Planning, Inc. and was a Senior Manager with Pricewaterhouse Coopers. He served as Chairman of FINRA's District No. 9 Business Conduct and Nominating Committees. He has been a Director of Abraxas Petroleum Corp. since May 2012. Mr. Karrash is a member of FINRA's Small Firm Advisory Board (SFAB) and the Financial Responsibility committee. He has also served as a member of First Clearing, LLC's Correspondent Advisory Board. Mr. Karrash is a CPA, CPF, and is registered with FINRA as a General Securities Registered Representative (Series 7), a General Securities Principal (Series 24), a Municipal Securities Principal (Series 53), and an Investment Advisor Representative (series 65). Mr. Karrash is a 1996 graduate of the Temple University Executive M.B.A. program and a 1983 graduate of Pennsylvania State University where he obtained a B.S. in Accounting. 1 james andersen Mr. R. James Andersen, Jim, CA, CPA (Illinois), CFP has been the Chief Financial Officer and Vice President of Finance at Avalon Rare Metals Inc. since June 2001. Mr. Andersen has been a Partner of Forbes Andersen LLP for nine years. He is a Partner of the Toronto accounting firm Andersen and Company PC. He founded Andersen & Company, PC and served as its President from January 2007 to October 2011. He served as Chief Financial Officer of Highvista Gold Inc. until October 6, 2011. He served as the Chief Financial Officer of Pele Mountain Resources Inc. from May 9, 2007 to September 30, 2011 and served as its Vice President of Finance. He served as the Chief Financial Officer and Secretary of Triumph Ventures Corp. until October 2011. He has more than 15 years of experience in public practice, and a wide variety of experience in small-cap companies. He served as the Chief Financial Officer of Baymount Incorp. from September 2005 to June 2010 and served as its Vice President of Finance since September 2005. He served as an Interim Secretary and Chief Financial Officer of Phantom Fiber Corp. since April 20, 2005. He served as the Chief Financial Officer and Vice President of Finance at Academy Capital Corp. since September 12, 2005. He served as the Chief Financial Officer of Kilo Goldmines, Inc. Mr. Andersen served as the Chief Financial Officer and Vice President of Finance of Macusani Yellowcake Inc. from May 29, 2007 to September 11, 2008. He served as a Director of Triumph Ventures Corp. from January 2010 to October 2011. He is experienced in mining accounting as well as corporate governance rules and regulations. He served as a Director of Macusani Yellowcake Inc. He was a part-time professor in the MBA program at the Schulich School of Business at York University. Mr. Andersen is also a Certified Public Accountant. He holds generic degree with high distinction from Trinity College at the University of Toronto in 1991 and placed 20th in Ontario on the CICA's Uniform Final Exam in 1992. 1 Wade D. Miquelon Mr. Wade D. Miquelon has been the Chief Financial Officer of Walgreen Co. since June 16, 2008 and has been its Executive Vice President since July 2009. Mr. Miquelon has also been President of International at Walgreen Co. since September 17, 2012. He joined Walgreen Co. on June 16, 2008 as Senior Vice President and was responsible for its accounting, tax and treasury functions, including investor relations. Prior to Walgreens, he served as the Chief Financial Officer and Executive Vice President of Tyson Foods Inc. from June 29, 2006 to May 12, 2008 and was responsible for its worldwide finance and accounting functions. From 1989 to 2006, Mr. Miquelon served at Procter & Gamble as Vice President of Finance, Western Europe. He served as the senior most financial officer of P&G and was responsible for the 17-country Western Europe operation. He also served as the Chief Financial Officer and Senior Director for P&G's 42 country ASEAN, Australia and India region based in Singapore. He served as the Head of Finance and Accounting for the ASEAN, Australasia, and India region, and served as a Director and Investment Partner of I Venturesd. Mr. Miquelon co-founded Emmperative Marketing, Inc. and served as its Chief Financial Officer and Senior Vice President of Business Development and Human Resources. He has been a Director of Alliance Boots GMBH since August 2, 2012. Mr. Miquelon has been a Director of Acadia Healthcare Company, Inc. since January 19, 2011. He serves as a Member of The Board of The Lyric Opera of Chicago and the Shedd Aquarium in Chicago. He also serves as a Member of the Dean s Advisory Board for the Sam M. Walton College of Business, University of Arkansas. Mr. Miquelon holds a Bachelor of Science Degree in Civil Engineering from Purdue University in 1987 and an M.B.A. in Finance and Marketing from Washington University in 1989. 0 Arthur S. Locke, III Mr. Arthur S. Locke, Art, III served as the Chief Financial Officer and Senior Vice President of Websense, Inc. from July 31, 2009 to August 2011 and also served as its Principal Accounting Officer until August 2011. Mr. Locke served as the Chief Financial Officer of Microstrategy Inc. since January 2005 until March 2009 and served as its Executive Vice President of Finance until March 25, 2009. Mr. Locke served as Vice President of Finance of Microstrategy Inc. since ... January 2005 and served as its Principal Accounting Officer. Prior to joining MicroStrategy Inc., Mr. Locke served as Chief Financial Officer of Metropolitan Area Networks, a start-up wireless broadband company, from February 2000 to January 2001, and as corporate controller of EIS International, Inc., from March 1997 to February 2000. Mr. Locke is a certified public accountant and holds a Bachelor of Science in Business Administration (BSBA) in Accounting and Computer Systems from American University. 1 Thank you for patiently answering all my question. Shalmali ... View more

Thanks Jagadish for the code. For some reason I am not able to get Undergrad =3 for the last observation (Dereck Burke) of my subsample. I will work on it and see what the problem is. Thanks again for your prompt reply. ... View more

Thanks a lot Arthur for the code. Also I appreciate for explaining the code. ... View more

Hi Ksharp, Your current code works perfectly fine. But if I want the link to create an additional link (link2) by replacing ".txt" on the link with "-index.htm", what code would I need? That is, I want link2 to be http://www.sec.gov/Archives/edgar/data/785024/0000916480-10-000041-index.htm Thank you, Shalmali ... View more

Thanks Ksharp for the code. ... View more

Thanks Richard for helping me with the code. I greatly appreciate it. ... View more

Dear Richard, Thanks for providing the code. The problem is that "n" and the "m" for all the bios in Data X (after step 3) are zero. In other words, the output of Data X looks as follows: Name     Age     Bios       n     m Mr.A     53          xxxx     0     0 Mr.B     60          xxxx     0     0 As a result after running the following code, I am not able to pick the company names from the bios. proc import out=bios datafile= "C:\Desktop\june1.xls" dbms=xls replace; getnames=yes; run; data x; set bios; if compress(lowcase(lag(biographies)),,'ka') in ('incorporated' 'inc' 'corporation' 'corp' 'llc')  then n+1; run; data x; set x; by n; if first.n then m=0; if   compress(lowcase(lag(biographies)),,'ka') in ('of' 'at' 'and' 'a') then m+1; run; proc sql; create table temp as   select * from x group by n having m=max(m) /* order by obs */; quit; data temp1; set temp; by n; length x $ 2000; retain x; x=catx(' ',x,biographies); if last.n then do; output;call missing(x);end; keep x; run; data temp2; set temp1; id=prxparse('/\bincorporated|\bInc|\bcorporation|\bcorp|\bLLC|\bco|\bcompany/io'); if prxmatch(id,x) then output; drop id; run; proc transpose data=temp2 out=want; var x; run; I would grately appreciate if you help me figure it out how to get the desired output. Thank you for you time. Shalmali. ... View more

Dear Richard, Thanks for your reply. Some biographies are short with few sentences and characters while others are long. I imported the excel file into SAS using the following function: proc import out=bios; datafile= "C:\destop\june1.xls" dbms=xls replace; getnames=yes; run; After the import my work.bios has three columns: executive name, age, and bios. I want to retain the name and age and extract the company names from the bios. After importing a file with few selected observations, I checked the column attributes of the bios. It says the length of this column is 2791 and type is character. I do not know what I need to do next (after proc import) to get the desired output without having to copy and paste the bios beetween cards4 and ;;;;expression. Also is it possible to have an output without restricting it to 100 characters? I am currently using SAS 9.3. I dont think it is the lastest version with "SAS Access to PC file format". Thank you once again, shalmali ... View more

Thanks Arthur for the code. ... View more

Thank you guys for the prompt reply. ... View more