提醒大家一点，transpose 在转字符型变量时，很容易出错

Once you know how to transpose dataset, you can convert rows into colums. Then row difference become column difference. It is easy to calculate column difference and put results into a new column. If you need, transpose back, you will get the row difference on a new row.

It is a general method and hope it works. There are other ways to program but without looking at data, it is hard to tell.

thanks.. I figured it out already.. It took quite a while transfer from column to row, then change back from row to column.... sigh..

the last problem is how can I merge or combine two sheet with by column? and insert words in the middle of combined chart? thank u so much!

You can "find data merge by "in Help. I trust you can figure it out.

我考，都说洋文。

用iml简直就像哈老白干儿一样简单。

不说洋文难混啊 这年头。。。

The little SAS book is really good for you

thanks a lot. icepolice...

I have the little sas book. it doesn't work a lot for me.. I can not find most of the information I want from there. ..sigh.