I am a new SAS user , firstly forgive me for my poor English grammar please, then the following is my problem. I want to write a loop to make the table like that: have: id name 1 Jam 2 John 3 Will want: newid id name 1 1 Jam 2 1 Jam 3 2 John 4 1 Jam 5 2 John 6 3 Will P.S. the logic should be following: the logic should be when i have N row in raw table; when I try to create new table, then i write the first row like the first row of raw table; then i try to create second step that copy first row and second rows of raw table and they should be second and third rows in new table; then when i create third step that copy first,second and third rows of raw table and they shoud be forth,fifth and sixth rows in new table; etc the Nth step should be that copy first row to Nth rows of raw table, then the whole number of rows should be (1+N)*(N/2), the first row of raw table is copied in N times and second one should be (N-1) times;
... View more