In SAS, you could use a combination of IF statements and PROC SQL for the lookups. Here's how you might structure it: data your_data; set your_data; if substr(a2, length(a2)-5, 6) = 'Number' then result = 'no'; else if (vlookup(b2, 'Names', 2) = 'yes') or (vlookup(b2, 'Location', 2) = 'yes') then result = 'no'; else result = vlookup(c2, 'Matching', 2); run; The vlookup function isn’t available directly in SAS, so you’ll likely need to use PROC SQL for those lookups or use an ARRAY structure if the lookup data is in a table format. I remember struggling with Excel to SAS translation, and what helped me was learning how to view formulas in Excel. It allowed me to break down the logic clearly before attempting the conversion, which saved me tons of time. ... View more