01-04-2017 04:58 PM
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
Assuming the statuses are unique.
01-04-2017 05:13 PM
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;
01-04-2017 05:27 PM
Here are two links that illustrate using arrays & proc transpose
Both methods are also used to go from long to wide.