topic Re: Transform vertical data into horizontal data in SAS Enterprise Guide

Transform vertical data into horizontal data

dipalp — Wed, 18 Oct 2017 22:27:47 GMT

I have the below data set

Cust_Num Updatedt

1 10/10/12

1 5/21/15

1 6/17/17

2 4/12/15

2 5/12/16

and would like to Convert it to the following:

Cust_Num First_Update Second_Update Third_Update Fourth_Update

1 10/10/12 05/21/15 6/17/17 CURRENT_DATE

2 04/12/15 05/12/16 CURRENT_DATE CURRENT_DATE

Appreciate your help.

Re: Transform vertical data into horizontal data

Reeza — Wed, 18 Oct 2017 22:40:59 GMT

PROC TRANSPOSE will get you started.

Re: Transform vertical data into horizontal data

ballardw — Thu, 19 Oct 2017 14:23:12 GMT

Can you tell us what you will do the results?

I ask because there a many tasks that get much harder after transposed to the "wide" form you request.

Also, since I have to assume "current_date" means the date the transform is performed, this is a potential problem as running the same code on the same data can yield a different result. Keeping track of such differences may make the project harder to manage.