Hi SAS users, I have a dataset as below: Variable1 Variable2 Variable3 1 W 3.2 1 X 5.1 2 X 7.0 3 E 8.9 3 W 1.3 Whenever, the Variable2 corresponding to Variable1 (ID) is changing its value, I would like to expand it to new columns. In fact per each new category (based on Variable2), two new columns are added to the right: Variable1 Variable2 Variable3 Variable4 Variable5 1 W 3.2 X 5.1 2 X 7.0 null null 3 E 8.9 W 1.3 PURPOSE: At the end, I am interested to have a unique Variable1 in first column; and the corresponding category(ies) are expanded to the right instead of stacking on top of eachother. Could you please help how to do it?
... View more