Hi All,
I need some help with the following:
This data is saved from some traditional source (Ms Word). Though one can do this easily in excel, I wonder how to do this in SAS.
Have |
|
Want |
Category |
Item |
|
Item |
Category |
Dog |
|
|
Sheepdogs |
Dog |
|
Sheepdogs |
|
Pinschers |
Dog |
|
Pinschers |
|
Terriers |
Dog |
|
Terriers |
|
Dachshunds |
Dog |
|
Dachshunds |
Abyssinian |
Cat |
Cat |
|
|
Aegean |
Cat |
|
Abyssinian |
|
Balinese |
Cat |
|
Aegean |
|
Bambino |
Cat |
|
Balinese |
|
Bengal |
Cat |
|
Bambino |
|
Birman |
Cat |
|
Bengal |
|
|
|
|
Birman |
|
|
|
Thanks,
JAR