Hello everyone, I am trying to find a lookup technique by which i can lookup data by more than one criteria. Something similar as the Vlookup formula with integrated MATCH function in Excel. As you can see below, i want to populate the % column in the first table from the second table, using the Class and the INITIAL MATURITY as a key. I am using SAS Enterprise Guide. Thank you Class MATURITY % MATURITY 0 1 2 3 4 5 Satisfactory Q1-2008 2 ... Class Satisfactory Q2-2016 6 ... Excellent Q1-2017 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% NA Q1-2011 2 ... Excellent Q2-2017 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Special mention Q1-2015 2 ... Excellent Q3-2017 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% NA Q1-2015 2 ... Strong Q1-2017 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Special mention Q3-2017 2 ... Strong Q2-2017 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Special mention Q3-2017 7 ... Strong Q3-2017 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Special mention Q3-2017 2 ... Satisfactory Q1-2017 0.29% 1.15% 2.29% 3.42% 4.54% 5.64% NA Q4-2014 9 ... Satisfactory Q2-2017 0.23% 0.92% 1.84% 2.75% 3.64% 4.53% NA Q1-2008 2 ... Satisfactory Q3-2017 0.29% 1.14% 2.27% 3.39% 4.49% 5.58% NA Q1-2008 16 ... Weak Q1-2017 0.60% 2.38% 4.71% 6.97% 9.19% 11.35% NA Q1-2008 16 ... Weak Q2-2017 0.78% 3.10% 6.11% 9.02% 11.84% 14.58% NA Q3-2017 1 ... Weak Q3-2017 0.70% 2.80% 5.53% 8.17% 10.75% 13.25% Special mention Q1-2017 7.54% 30.17% 51.23% 65.95% 76.22% 83.39% Special mention Q2-2017 6.64% 26.54% 46.04% 60.36% 70.88% 78.61% Special mention Q3-2017 7.12% 28.48% 48.85% 63.42% 73.84% 81.29%
... View more