Hi, Based on your comments, I would recommend you to use a transpose step for each variable. By doing a simple transpose for each ID and variable, you can receive a row for each customer and an array for each column of variable. After creating these files, you can then merge them together to form a single file. However, the best possible approach is actually to use a simple data step with retain statement and by statements to generate this data. Regards, Murphy ... View more