Normalize the dataset

[trishaechual]

Hey all,

i'm trying to figure out how to eliminate repeating attributes in my dataset.

For example, i want:

TICKET_ID     STATUS1    STATUS2    STATUS3    STATUS5     STATUS6

to become:

TICKET_ID     STATUS

Assuming the statuses are unique.

Please help!       

[PGStats]

This operation is usually called "going from wide to long". It can be performed with arrays, which offer efficiency and flexiblility, but a simpler way is to use proc transpose:

proc transpose data=have out=want(rename=col1=STATUS);
by ticket_id notsorted;
var status1-status6;
run;

[Reeza]

Here are two links that illustrate using arrays & proc transpose

http://www.ats.ucla.edu/stat/sas/modules/wtol_transpose.htm

http://www.ats.ucla.edu/stat/sas/modules/widetolong_data.htm

Both methods are also used to go from long to wide.