topic Re: Creating an 1/0 variable from a text using search words in SAS Procedures

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

shalmali — Fri, 04 Nov 2016 18:23:08 GMT

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,

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

GreggB — Fri, 04 Nov 2016 18:33:55 GMT

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;

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

shalmali — Sun, 06 Nov 2016 17:09:42 GMT

Hello Everyone,

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,

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

shalmali — Sun, 06 Nov 2016 17:10:54 GMT

Thank you for the suggestion.