https://communities.sas.com/t5/SAS-Procedures/Help-please/m-p/63259#M17973 thanks, I have figured it out. Sat, 07 May 2011 00:42:31 GMT piggy 2011-05-07T00:42:31Z https://communities.sas.com/t5/SAS-Procedures/Help-please/m-p/63258#M17972 Hi guys,<BR /> I recently got lots of tables as below,<BR /> <BR /> PLA_R time1 time2 time3 time4 time5 time6 time7 time8 time9<BR /> 2 263.0 263.0 263.0 258.0 253.5 248.4 242.0 238.4 237.0<BR /> 3 206.0 206.0 206.0 206.0 188.4 156.8 144.1 143.0 143.0<BR /> 4 281.0 266.5 240.0 222.4 209.0 209 209.0 209.0 217.8<BR /> 5 225.0 225.0 225.0 219.7 206.8 199.0 195.4 195.0 195.0<BR /> 6 225.0 215.6 210.0 202.7 181.6 167.0 171.1 173.5 179.0<BR /> 7 225.0 222.6 206.0 201.6 182.4 185.0 185.0 185.0 185.0<BR /> 8 281.0 281.0 273.1 254.0 243.3 246.0 241.0 241.0 261.0<BR /> 9 281.0 281.0 281.0 281.0 281.0 281.0 281.0 281.0 281.0<BR /> <BR /> is there any way I can transfer these data/table to the following?<BR /> <BR /> treatment person power time<BR /> PLA_R 2 263 time1<BR /> PLA_R 3 206 time1<BR /> PLA_R 4 281 time1<BR /> PLA_R 5 225 time1<BR /> PLA_R 6 225 time1<BR /> PLA_R 7 225 time1<BR /> PLA_R 8 281 time1<BR /> PLA_R 9 281 time1<BR /> PLA_R 2 263 time2<BR /> PLA_R 3 206 time2<BR /> PLA_R 4 266.5 time2<BR /> PLA_R 5 225 time2<BR /> PLA_R 6 215.6 time2<BR /> PLA_R 7 222.6 time2<BR /> PLA_R 8 281 time2<BR /> PLA_R 9 281 time2<BR /> ...... Sat, 07 May 2011 00:06:40 GMT https://communities.sas.com/t5/SAS-Procedures/Help-please/m-p/63258#M17972 piggy 2011-05-07T00:06:40Z https://communities.sas.com/t5/SAS-Procedures/Help-please/m-p/63259#M17973 thanks, I have figured it out. Sat, 07 May 2011 00:42:31 GMT https://communities.sas.com/t5/SAS-Procedures/Help-please/m-p/63259#M17973 piggy 2011-05-07T00:42:31Z