I apologize if this has been asked earlier. However, I would like to create and transpose additional columns. My current data set looks like this: Week Beginning Carrier Campaign Q W E R T 6-Oct-14 A Network Guys 70 0.44 0.22 0.19 0.11 6-Oct-14 A College Football Network 0 6-Oct-14 A iPhone 6 75 0.75 0.53 0.40 0.27 6-Oct-14 B Network Guys 145 0.60 0.33 0.29 0.16 6-Oct-14 B College Football Network 10 0.49 0.24 0.16 0.11 6-Oct-14 B iPhone 6 11 0.30 0.12 0.04 0.07 7-Oct-14 C Samsung 52 0.35 0.18 0.06 0.07 I would like to convert this to: Week Beginning Campaign A_Q A_W A_E A_R A_T B_Q B_W B_E B_R B_T C_Q C_W C_E C_R C_T 6-Oct-14 Network Guys 70 0.44 0.22 0.19 0.11 145 0.60 0.33 0.29 0.16 6-Oct-14 College Football Network 0 10 0.49 0.24 0.16 0.11 6-Oct-14 iPhone 6 75 0.75 0.53 0.40 0.27 11 0.30 0.12 0.04 0.07 7-Oct-14 Samsung 52 0.35 0.18 0.06 0.07 Is there a quick way of doing this? I know I can do this using proc sql but that would require me to know the name of the variables. However if I want to create macros then proc transpose or something else like that would be a better way. Any help would be appreciated. Thanks in advance.
... View more