I just want an extended version of this output with two more variables. Let's say I have the dataset like the below. data have; input F1$ F2$ F2_1$ F4$ F4_1$ F4_2$ F3$ F5$; datalines; Name1 RD 10 RS 1 2 AS GS Name2 RD 20 RS 3 4 AS TS Name2 RD 20 RS 5 6 AS TT Name2 RD 20 RS 7 8 AS ST Name3 RD 30 RS 11 12 AS GS Name3 RD 30 RS 13 14 AS HG Name4 RD 40 RS 15 16 AS GS ; Is it possible to get an output like the below. There is one more variable which has more than one value for one Name and that the order is also changed. Name1 RD|10 RS|1|2 AS GS Name2 RD|20 RS|3|4 RS|5|6 RS|7|8 AS TS TT ST Name3 RD|30 RS|11|12 RS|13|14 AS GS HG Name4 RD|40 RS|15|16 AS GS Thanks in advance!
... View more
