topic Re: Incorrectly labelled values in SAS Data Management

Incorrectly labelled values

pokepim — Sat, 03 Feb 2018 10:25:06 GMT

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.

Re: Incorrectly labelled values

ballardw — Fri, 02 Feb 2018 17:57:13 GMT

Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712 will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the {i} icon or attached as text to show exactly what you have and that we can test code against.

Provide the minimum amount of data to demonstrate your issue and show us what the result should be for any supplied example data.

I'm not following your code as to what is to be accomplished but it almost sound like some of the "condition" information might be useable to build formats??