Help using Base SAS procedures

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

Reply
Frequent Contributor
Posts: 96

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

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

 

 

Super Contributor
Posts: 279

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

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;

Frequent Contributor
Posts: 96

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

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

Frequent Contributor
Posts: 96

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

Thank you for the suggestion. 

Ask a Question
Discussion stats
  • 3 replies
  • 187 views
  • 1 like
  • 2 in conversation