topic Re: Normalize the dataset in SAS Enterprise Guide

Normalize the dataset

trishaechual — Wed, 04 Jan 2017 21:58:16 GMT

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!

Re: Normalize the dataset

PGStats — Wed, 04 Jan 2017 22:13:33 GMT

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;

Re: Normalize the dataset

Reeza — Wed, 04 Jan 2017 22:27:35 GMT

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.