sorting and grouping in SAS
Hello I have a data set that looks like this:
Basket ItemCount TotalAmount CategoryDescription
102030 3 40 books
205060 1 5 produce
102030 3 40 deli
102030 3 40 dairy
708359 25 120 meat
456023 1 1 candy
Using SAS I want to sort/group the data so that I have: all the baskets
that have only a total of any one category in a new dataset, all the
baskets that have a total of only two categories in another dataset, all
the baskets that have a total of only three categories in another
dataset,..etc. . Given that I have 1134 different categories. Then I want
one dataset that contain all the newly sorted variables.
Many thanks ļ
No comments:
Post a Comment