Hello everyone,
I have a dataset with two missing values.I hope I can predict these two value from other rows.(curved line)
so I want build a regression model (this is not a linear line,but a curved like line)to predict the missing values when var in (98,99).
please advise me.
Thank you very much!
data have;
input value var;
cards;
75.447 1
74.628 2
73.737 3
72.846 4
71.964 5
71.064 6
70.173 7
69.273 8
68.382 9
67.482 10
66.582 11
65.691 12
64.800 13
63.900 14
63.009 15
62.118 16
61.227 17
60.345 18
59.463 19
58.590 20
57.735 21
56.871 22
56.007 23
55.134 24
54.252 25
53.388 26
52.506 27
51.624 28
50.742 29
49.860 30
48.969 31
48.087 32
47.214 33
46.332 34
45.450 35
44.577 36
43.695 37
42.822 38
41.940 39
41.067 40
40.185 41
39.330 42
38.466 43
37.602 44
36.747 45
35.883 46
35.028 47
34.173 48
33.318 49
32.490 50
31.653 51
30.816 52
29.988 53
29.160 54
28.359 55
27.540 56
26.730 57
25.929 58
25.119 59
24.309 60
23.517 61
22.752 62
21.969 63
21.195 64
20.457 65
19.710 66
18.954 67
18.207 68
17.469 69
16.776 70
16.065 71
15.381 72
14.697 73
14.049 74
13.401 75
12.771 76
12.168 77
11.565 78
10.980 79
10.404 80
9.846 81
9.288 82
8.784 83
8.289 84
7.794 85
7.335 86
6.903 87
6.489 88
6.102 89
5.733 90
5.346 91
5.040 92
4.734 93
4.410 94
4.077 95
3.780 96
3.483 97
. 98
. 99
2.357 100
;
run;
let me get a start model;
proc sgscatter data=have;
plot value*var/
reg=(nogroup clm degree=2) grid ;
run;
I want use regression like this line to estimate values when var in(98,99). please help me find out how to do this.
Thanks!
... View more