01-08-2015 06:01 AM
we are currently doing some data aggregation via sas studio.
In the table below you can see how the data currently looks like. In our data we have several custIDs, and the goal is to reduce the data to 1 row per customer with newly created variables. We now want to create new variables with name of the T_WG_P variable and the values from the Revenue column.
What we now need is something like a call symput statement but only for non-macro variables to use the value from T_WG_P as a variable name and to assign the revenue as a value to it.
Or maybe you have a completely different approach, all help is very welcome.
Thanks in advance and best regards