Friday, 27 September 2013

sorting and grouping in SAS

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