楼主: alaleilei999
4667 13

SAS DATA格式转换 [推广有奖]

  • 0关注
  • 0粉丝

初中生

66%

还不是VIP/贵宾

-

威望
0
论坛币
24 个
通用积分
0
学术水平
0 点
热心指数
0 点
信用等级
0 点
经验
106 点
帖子
18
精华
0
在线时间
2 小时
注册时间
2007-10-19
最后登录
2016-11-18

楼主
alaleilei999 发表于 2008-3-12 03:13:00 |AI写论文

+2 论坛币
k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群
赵安豆老师微信:zhaoandou666

经管之家联合CDA

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

感谢您参与论坛问题回答

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

+2 论坛币

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

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

二维码

扫码加我 拉你入群

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

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

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

回帖推荐

icepolice 发表于4楼  查看完整内容

PROC TRANSPOSE DATA=EXAMPLE;OUT=TRANSPOSED_EXAMPLE;RUN;Help 中有具体的用法. 特别是 BY 选项

本帖被以下文库推荐

沙发
icepolice 发表于 2008-3-12 04:43:00
用 TRANSPOSE

藤椅
alaleilei999 发表于 2008-3-12 04:47:00

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

楼上能给个具体的COMMAND语句吗?谢谢!!

板凳
icepolice 发表于 2008-3-12 06:06:00
PROC TRANSPOSE DATA=EXAMPLE;
OUT=TRANSPOSED_EXAMPLE;
RUN;


Help 中有具体的用法. 特别是 BY 选项
已有 1 人评分经验 论坛币 收起 理由
bakoll + 3 + 10 精彩帖子

总评分: 经验 + 3  论坛币 + 10   查看全部评分

报纸
losttemple 发表于 2008-3-12 08:40:00
帮助你都不会用,搞鸡巴

地板
alaleilei999 发表于 2008-3-12 10:58:00

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!

7
wolfcrying 发表于 2008-3-12 11:52:00
提醒大家一点,transpose 在转字符型变量时,很容易出错

8
icepolice 发表于 2008-3-12 12:10:00
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.

9
alaleilei999 发表于 2008-3-12 12:26:00

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!

10
icepolice 发表于 2008-3-12 12:57:00
You can "find data merge by "in Help. I trust you can figure it out.

您需要登录后才可以回帖 登录 | 我要注册

本版微信群
加好友,备注cda
拉您进交流群
GMT+8, 2025-12-9 08:16