topic How to reverse a table in SAS? in SAS Data Science

How to reverse a table in SAS?

dparnes — Thu, 29 Sep 2011 15:27:36 GMT

Hi,

I need to reverse a table in SAS.

For example I have a list of stores (1, ,2, 3, ..., 2000) on the first column and for each store I have a list of customers (1, ,2, 3, ..., 2000) in the following columns, but this list is limited to up to 12 customers (random number of customers per store).

Now I need to reverse the story, i.e. to build a list of costumers sorted from 1 to 2000 on the first column, and for each customer to find from the original table a list of corresponding stores.

How can I do that in SAS?

Thank you!

How to reverse a table in SAS?

art297 — Thu, 29 Sep 2011 15:42:14 GMT

Not sure I understand what you have. Does the following approximate what your file looks like for the first two stores?:

Store Cust1 Cust2 Cust3 Cust4 Cust5 Cust6 Cust7 Cust8 Cust9 Cust10 Cust11 Cust12

1 24 2 5 6 1000 50 80 900 901 902 903 700

2 54 22 58 76 25 90 70 800 801 802 803 600

and you want to end up with a file that looks like?:

Cust Store

24 1

2 1

5 1

6 1

etc.