From a large dataset using the following code I get a table (see table-1). But I would like to get a table that contains some calculated observations (see table-2).
proc freq data=have; table Year*Location / nocum nocol norow nopercent ; run;
Table-1
A
B
C
D
E
F
G
2001
100
299
399
140
29
1
3
2002
105
251
356
93
39
0
2
2003
79
145
224
32
19
1
5
2004
186
322
508
89
24
2
4
2005
220
315
535
107
67
7
6
2006
108
152
260
95
45
11
2
2007
53
56
109
72
45
10
3
2008
18
7
25
35
18
0
0
2009
15
20
35
42
26
6
1
2010
66
103
169
99
58
15
1
Table-2
A
B
C
D
E
F
G
AtoG
A+B
C+D+E+F+G
2001
100
299
399
140
29
1
3
971
399
572
2002
105
251
356
93
39
0
2
846
356
490
2003
79
145
224
32
19
1
5
505
224
281
2004
186
322
508
89
24
2
4
1,135
508
627
2005
220
315
535
107
67
7
6
1,257
535
722
2006
108
152
260
95
45
11
2
673
260
413
2007
53
56
109
72
45
10
3
348
109
239
2008
18
7
25
35
18
0
0
103
25
78
2009
15
20
35
42
26
6
1
145
35
110
2010
66
103
169
99
58
15
1
511
169
342
Thanks,
... View more