Hi, I can only apologise for what is probably about to be a stupid question! I have had a bit of a break from using SAS due to maternity leave and can't clear my head. I've used a macro to bucket a variable. The output is a table, which has two columns, min_score and max_score, and a row for each bucket: min_score max_score 0 1 2 2 3 3 4 4 5 6 7 27 I'd now like to apply that onto the dataset. For example I have the VALUE column and I want to apply a character variable called BUCKET based on the min and max values. I want it to look like: VALUE BUCKET 1 0-1 5 5-6 7 7-27 9 7-27 5 5-6 6 5-6 3 3 where bucket is character. Is this possible? Am I making my life too complicated? Thanks for any input (be kind with a sleep deprived mummy please!)
... View more