I'm trying to categorize variables in one tables based on the conditions coming from another table. Currently im using macro which assigns categories (by creating a new table and putting categories under the variables) to those values however it seems that it is assigining them even if the value doesnt not meet the conditions. For example 2nd value of first variable is 78 which should be category 2 but it still assigns it to category 1.
With this post I'm providing the two datasets(tables)- one is for categorization conditions and the other one is containing all the variables with values.