全部版块 我的主页
论坛 数据科学与人工智能 数据分析与数据科学 SAS专版
1303 7
2012-08-05
For example, I have a data taking the values as follows. How can I assign each value of t as t(1), t(2), ... , and x as x(1), x(2), ... so that I can compute something likes ln[x(2)/x(1)], ln[x(3)/x(2)], ... , and name these values as a new variable y.Don't tell me to do it in Excel. Of course, I know how to do this simply in Excel, but I just want to know whether it can be perform in SAS so that I do not need to switch from Excel and SAS so frequently.


data a;
input t x;
cards;
1 10
2 13
3 17
4 14
5 16
6 18
7 15
8 12
9 11
10 15
;
run;
二维码

扫码加我 拉你入群

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

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

全部回复
2012-8-7 08:54:55
怎麼没人理我?
二维码

扫码加我 拉你入群

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

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

2012-8-7 09:10:09
如果你需要的结果仅是相邻两数相除的自然对数的话,可以用下面的程序。当然如果不是相邻的,但是间隔是由规律的,也可以,比如lag(x)换成lag2(x)就是隔一个数相除。
data b;
        set a;
        lagx=lag(x);
        y=log(x/lagx);
        if _N_ ne 1 then output;
run;
二维码

扫码加我 拉你入群

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

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

2012-8-7 09:19:05
U can use array or proc IML to deal with your problem.
Sorry, I don't how to use IML, so just illustrate an example by array.

data b(keep = array_ans compare_ams);
        array at{10} _temporary_;
        array ax{10} _temporary_;
        retain at ax;
        do i = 1 to 10;
                set a point=i;
                at{i} = t;
                ax{i} = x;
        end;
        array_ans = ax{3} / ax{2};
        compare_ams= 17/13;
        output;
        stop;
run;
二维码

扫码加我 拉你入群

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

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

2012-8-8 20:17:48
maidenhan 发表于 2012-8-7 09:19
U can use array or proc IML to deal with your problem.
Sorry, I don't how to use IML, so just illu ...
Thanks, I understand your logic. Then, I do something like "ax(j+1)/ax(j)", but why no result is shown?
二维码

扫码加我 拉你入群

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

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

2012-8-9 09:15:01
lam_fukming 发表于 2012-8-8 20:17
Thanks, I understand your logic. Then, I do something like "ax(j+1)/ax(j)", but why no result is s ...
Show us your code, or we don't know what goes wrong.
二维码

扫码加我 拉你入群

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

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

点击查看更多内容…
相关推荐
栏目导航
热门文章
推荐文章

说点什么

分享

扫码加好友,拉您进群
各岗位、行业、专业交流群