[程式] SAS-first語法
[軟體程式類別]:
SAS
[程式問題]:
資料處理
[軟體熟悉度]:
低(1~3個月)
[問題敘述]:
Obs country year sales lag_sales
1 NZ 1999 42323 .
2 NZ 2001 45240 42323
3 NZ 2002 57865 45240
4 NZ 2003 62129 57865
5 NZ 2004 70048 62129
6 NZ 2005 90738 70048
7 TW 1999 4354 90738<<
8 TW 2001 3582 4354
9 TW 2002 8112 3582
10 AN 2001 7009 8112<<
11 AN 2002 15442 7009
12 AN 2003 6257 15442
我看了LOG,顯示
NOTE: Variable first.country is uninitialized.
ERROR: BY variables are not properly sorted on data set MYLIB.Y1DATA.
[程式範例]:
data mylib.Prod;
set mylib.Y1Data;
by country year;
LAG_sales=Lag(sales);
if first.country then LAG_S=.;
run;
-----------------------------------------------------------------------------
資料來源:http://r97846001.blog.ntu.edu.tw/2011/06/18/saslag/
我的程式碼也是參考此網頁的,但結果卻不同,請各位前輩幫忙
感謝
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 140.119.120.6
※ 文章網址: https://www.ptt.cc/bbs/Statistics/M.1426323912.A.349.html
推
03/14 18:02, , 1F
03/14 18:02, 1F
→
03/14 22:30, , 2F
03/14 22:30, 2F
※ 編輯: faceoflove56 (140.119.143.76), 03/14/2015 22:30:38
推
03/15 18:48, , 3F
03/15 18:48, 3F
→
03/16 14:01, , 4F
03/16 14:01, 4F
→
03/16 14:01, , 5F
03/16 14:01, 5F
→
03/16 14:02, , 6F
03/16 14:02, 6F
推
03/16 22:11, , 7F
03/16 22:11, 7F
→
03/16 22:12, , 8F
03/16 22:12, 8F
→
03/16 22:13, , 9F
03/16 22:13, 9F
→
03/16 22:14, , 10F
03/16 22:14, 10F
推
03/16 22:20, , 11F
03/16 22:20, 11F
→
03/16 22:21, , 12F
03/16 22:21, 12F