大作业!请问怎么用sas生成这个数据集的时间序列?(

shiyiming

就是以下的数据:我已经看了坛子里面的关于新手sas时间序列的帖子,但是里面的例子和这个不一样........我还是不会~谢谢大家了~因为这个是大作业的一部分,所以比较急,在线等,谢谢拉  
我自己proc gplot data=quanlib.cluster2;
symbol i=spline v=star h=2 c=green;
plot City*y1;========但是这个显然不对,我觉得应该是每个城市有一条时间序列图的

房价数据及分析 12:59 Saturday, May 22, 2008 39

Obs num City y1 y2 y3 y4 y5 y6

1 1 shanghai 3730 3808 4121 5118 6385 8627.00
2 1 hangzhou 3795 3158 3967 4266 5509 7210.00
3 1 nanjing . 2808 2921 3147 3690 4960.00
4 1 wuxi 2171 2387 2545 3153 3751 .
5 1 suzhou 1687 1827 2162 2553 3203 4460.00
6 1 ningbo 2656 3041 3716 4484 5067 5900.00
7 1 nantong 1389 1533 1631 1829 2119 2587.00
8 1 shaoxin 2042 2379 2842 4660 5895 5968.00
9 1 jiaxing . 2100 2368 3156 3972 4312.00
10 2 guangzho . 4290 4122 4240 4537 5660.00
11 2 shenzhen . 5779 6074 6255 6547 6037.00
12 2 dongwan . . . . 2660 .
13 2 zhuhai . 3492 3475 3221 3285 4135.00
14 2 zhongsha . 2664 2365 2595 2551 2856.00
15 2 foshan . . . . 2807 .
16 3 beijing 4919 5062 4764 4884 5053 6232.00
17 3 tianjin 2327 2377 2487 2760 3346 4760.00
18 3 dalian 2380 3239 3187 3356 3841 4241.00
19 3 qingdao . 2080 2229 2563 2845 4639.00
20 3 jinan 1824 1986 2101 2326 3064 3172.00
21 3 shijiazh 1639 1678 1734 1950 2249 2470.00
22 4 shenyang . 2743 2738 2915 3182 2926.00
23 4 changchu . 2301 2430 2196 2260 2191.00
24 4 haerbin . 2257 2299 2348 2470 2574.00
25 5 chongqin 1351 1443 1556 1596 1766 2732.00
26 5 chengdu 1669 1850 1992 2096 2452 2868.00
27 5 guiyang 1573 1539 1621 2012 2065 3100.00
28 5 kunming . . 2296 2525 2778 3150.00
29 6 xian . 2095 2041 2161 2624 3007.00
30 6 taiyuan . . . 2300 2645 3050.00
31 6 yinchuan . 1905 2190 2139 2069 1930.00
32 6 wulumuqi . 1768 2044 2360 2196 2280.00
33 6 huhehaot . . . 1550 1690 1960.00
34 6 lanzhou . . . 1858 2282 2438.00
35 7 wuhan . 1813 1928 2072 2516 2858.00
36 7 nanchang . 1792 2251 2722 2807 2777.00
37 7 hefei . 1894 1753 2095 2521 2220.00
38 7 changsha . 2300 2376 2468 2738 3030.00
39 7 zhengzho . 2188 2199 2319 2639 2650.00
40 8 haikou . 1962 2117 2096 2173 2330.00
41 8 nanning . 2229 2375 2252 2380 2681.28
42 8 beihai . 1076 1172 1200 1300 .
43 9 xiamen 3481 3523 3597 4148 4936 5156.00
44 9 fuzhou 2496 2606 2692 2724 2983 3368.00
45 9 wenzhou . . . . 6253 9278.00

shiyiming

谢谢大家帮忙了,十分感谢了~

shiyiming

First, the dataset needs to be transposed to vertical format so that SAS can plot it by city.
Second, the symbol option you used will only give green lines, you need the repeat option.
Here is the code. Hope this help.
[code:3l1fubog]

data A (drop=obs);
length City $12.;
input Obs num City y1 y2 y3 y4 y5 y6;
datalines;
1 1 shanghai 3730 3808 4121 5118 6385 8627.00
2 1 hangzhou 3795 3158 3967 4266 5509 7210.00
3 1 nanjing . 2808 2921 3147 3690 4960.00
4 1 wuxi 2171 2387 2545 3153 3751 .
5 1 suzhou 1687 1827 2162 2553 3203 4460.00
6 1 ningbo 2656 3041 3716 4484 5067 5900.00
7 1 nantong 1389 1533 1631 1829 2119 2587.00
8 1 shaoxin 2042 2379 2842 4660 5895 5968.00
9 1 jiaxing . 2100 2368 3156 3972 4312.00
10 2 guangzho . 4290 4122 4240 4537 5660.00
11 2 shenzhen . 5779 6074 6255 6547 6037.00
12 2 dongwan . . . . 2660 .
13 2 zhuhai . 3492 3475 3221 3285 4135.00
14 2 zhongsha . 2664 2365 2595 2551 2856.00
15 2 foshan . . . . 2807 .
16 3 beijing 4919 5062 4764 4884 5053 6232.00
17 3 tianjin 2327 2377 2487 2760 3346 4760.00
18 3 dalian 2380 3239 3187 3356 3841 4241.00
19 3 qingdao . 2080 2229 2563 2845 4639.00
20 3 jinan 1824 1986 2101 2326 3064 3172.00
21 3 shijiazh 1639 1678 1734 1950 2249 2470.00
22 4 shenyang . 2743 2738 2915 3182 2926.00
23 4 changchu . 2301 2430 2196 2260 2191.00
24 4 haerbin . 2257 2299 2348 2470 2574.00
25 5 chongqin 1351 1443 1556 1596 1766 2732.00
26 5 chengdu 1669 1850 1992 2096 2452 2868.00
27 5 guiyang 1573 1539 1621 2012 2065 3100.00
28 5 kunming . . 2296 2525 2778 3150.00
29 6 xian . 2095 2041 2161 2624 3007.00
30 6 taiyuan . . . 2300 2645 3050.00
31 6 yinchuan . 1905 2190 2139 2069 1930.00
32 6 wulumuqi . 1768 2044 2360 2196 2280.00
33 6 huhehaot . . . 1550 1690 1960.00
34 6 lanzhou . . . 1858 2282 2438.00
35 7 wuhan . 1813 1928 2072 2516 2858.00
36 7 nanchang . 1792 2251 2722 2807 2777.00
37 7 hefei . 1894 1753 2095 2521 2220.00
38 7 changsha . 2300 2376 2468 2738 3030.00
39 7 zhengzho . 2188 2199 2319 2639 2650.00
40 8 haikou . 1962 2117 2096 2173 2330.00
41 8 nanning . 2229 2375 2252 2380 2681.28
42 8 beihai . 1076 1172 1200 1300 .
43 9 xiamen 3481 3523 3597 4148 4936 5156.00
44 9 fuzhou 2496 2606 2692 2724 2983 3368.00
45 9 wenzhou . . . . 6253 9278.00
;
run;
proc print; run;

proc sort  data=a;
by city;
run;
proc transpose data=a out=b (rename=(_NAME_= Y col1=price));
by city ;  
var y1-y6 ;
run;

proc print; run;

goptions reset=global;
proc gplot data=b;
symbol i=join l=1 repeat=100;
plot price*y=city;
run;


[/code:3l1fubog]

shiyiming

Hotea!!! thank you so much!
I already transported the data by excel~
your help is so important for me considering that I donnot know how to plot all the cities in one gragh~But now I can do it with your guidance~
So thank you so much <!-- s:D --><img src="{SMILIES_PATH}/icon_biggrin.gif" alt=":D" title="Very Happy" /><!-- s:D -->

shiyiming

You are so welcome <!-- s:D --><img src="{SMILIES_PATH}/icon_biggrin.gif" alt=":D" title="Very Happy" /><!-- s:D -->