SAS DATA格式转换

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

怎样把SAS DAT中的column转换到ROW里去阿。。。

哪位高手指点下阿。。。急

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏1 回帖

关键词：Data 格式转换 column colum 高手指点 格式 SAS Data

用 TRANSPOSE

在HELP里找不到TRANSPOSE这个关键词阿。。

楼上能给个具体的COMMAND语句吗？谢谢！！

PROC TRANSPOSE DATA=EXAMPLE;
OUT=TRANSPOSED_EXAMPLE;
RUN;


Help 中有具体的用法. 特别是 BY 选项

帮助你都不会用，搞鸡巴

thanks.. I am new in SAS... but I know how to use help.. weired that I can not find the transpose at the first try. but now, it is okay. Thank you!

I have another question is how to compare the difference of the value between the rowes? I know how to compare the difference between columns, but seems it is different to compare the difference between the rowes... can u help? Thank you!

提醒大家一点，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.