Creating an 1/0 variable from a text using search words

[shalmali]

Hello Everyone,

I have a dataset with the following information: firm_identifier, Year, Executive_Name, and Executive_biography. I want to create a new variable "Expert" that takes value 1 if the executive has a law school degree, such as JD, LL.M., or LL.D., and/or has working experience as a lawyer at, for example, a law firm or as a legal counsel.

Is there any SAS code that could read the Executive_biography and create the variable? If so, can someone please share the code with me?

The length of executive biographies varies: Some executives' bios are short (ten lines) while some have a long bio (almost a page long). Also the search words (JD, LL.M., LL.D., law firm or  legal counsel) can be placed anywhere in the bios. Also these search words can be in uppercase or lowercase. 

Thank you for your time.

Regards,

S

[GreggB]

Take a look at this: http://www.ats.ucla.edu/stat/sas/faq/index_function.htm

Then, you could add:  If x > 0 then Expert=1; else Expert=0;

[shalmali]

Hello Everyone,

I have a dataset with the following information: firm_identifier, Year, Executive_Name, and Executive_biography. I want to create a new variable "Expert" that takes value 1 if the executive has a law school degree, such as JD, LL.M., or LL.D., and/or has working experience as a lawyer at, for example, a law firm or as a legal counsel.

I tried using the following code to create Expert variable.

data Want;
set Have;
uline= upcase(Executive_biography);
if find(uline,"LL.M.") and find(uline,"JD") or find(uline,"LL.D.")or find(uline,"LAW FIRM")
or find(uline,"LEGAL COUNSEL")
then do;
Expert=1;
output;
end;
run;

This code creates a new dataset where Expert =1. I want a dataset that has all the observations (i.e., Expert =1 and Expert =0). Can somebody please refine this code for me?

Thank you for your time.

Regards,

S

[shalmali]

Thank you for the suggestion.