Hi,
Thank you so much for your code. I managed to solve my problem using the following codes:
data education;
set org.na_dir_profile_education;
if findw(upcase(qualification), 'BACHELOR')>=1 then bachelor = 1;
if findw(upcase(qualification), "BACHELOR'S DEGREE")>=1 then bachelor = 1;
if findw(upcase(qualification), 'BS')>=1 then bachelor = 1;
if findw(upcase(qualification), 'BSC')>=1 then bachelor = 1;
if findw(upcase(qualification), 'BE')>=1 then bachelor = 1;
if findw(upcase(qualification), 'BSE')>=1 then bachelor = 1;
if findw(upcase(qualification), 'BENG')>=1 then bachelor = 1;
if findw(upcase(qualification), 'BA')>=1 then bachelor = 1;
if findw(upcase(qualification), 'B Acc')>=1 then bachelor = 1;
if findw(upcase(qualification), 'B Arch')>=1 then bachelor = 1;
if findw(upcase(qualification), 'B.Acc')>=1 then bachelor = 1;
if findw(upcase(qualification), 'B.Math')>=1 then bachelor = 1;
if findw(upcase(qualification), 'B.Proc')>=1 then bachelor = 1;
if findw(upcase(qualification), 'BAS')>=1 then bachelor = 1;
if findw(upcase(qualification), 'BASc')>=1 then bachelor = 1;
if findw(upcase(qualification), 'BAppSc')>=1 then bachelor = 1;
if findw(upcase(qualification), 'BArch')>=1 then bachelor = 1;
if findw(upcase(qualification), 'BBA')>=1 then bachelor = 1;
if findw(upcase(qualification), 'BBM')>=1 then bachelor = 1;
if findw(upcase(qualification), 'BBS')>=1 then bachelor = 1;
if findw(upcase(qualification), 'BCA')>=1 then bachelor = 1;
if findw(upcase(qualification), 'BCL')>=1 then bachelor = 1;
if findw(upcase(qualification), 'BCom')>=1 then bachelor = 1;
if findw(upcase(qualification), 'BComm')>=1 then bachelor = 1;
if findw(upcase(qualification), 'BCompt')>=1 then bachelor = 1;
if findw(upcase(qualification), 'BEc')>=1 then bachelor = 1;
if findw(upcase(qualification), 'BEcon')>=1 then bachelor = 1;
if findw(upcase(qualification), 'BEd')>=1 then bachelor = 1;
if findw(upcase(qualification), 'BFA')>=1 then bachelor = 1;
if findw(upcase(qualification), 'BInf')>=1 then bachelor = 1;
if findw(upcase(qualification), 'BInfTech')>=1 then bachelor = 1;
if findw(upcase(qualification), 'BJ')>=1 then bachelor = 1;
run;
May I know if there is simplified way like writing a macro to shorten the above, as there are at least 30-40 qualified words for my bachelor indicator?
Thank you.
... View more