Hi, I have a large dataset in which i am trying to fill blanks in a particular column based on certain criteria. My dataset looks like below. Customer_Name Degree Country Steve MS USA Dan MA CAN Edward M.Tech USA Emily MS -1st USA John MBA - 2nd USA If Degree variable has blanks, Customer_Name will have a reference to the degree in it. So, i want to build a logic that If Degree is blank then search Customer_Name for 'MS' and create a new variable "Degree_mod" and fill "MS" in it. In the above table, Emily and John should have entries in the new variable. Somehow i am not able build it. data work.Daily_dump; set work.Daily_Dump; Format Degree_Mod $15.; if Degree =' ' then do; if FINDW(Customer_Name, 'MS')>0 then do; Degree_Mod1="MS"; end; I am not sure if my SAS code is correct here. Can you please help?
... View more