o******6 发帖数: 538 | 1 ☆─────────────────────────────────────☆
almom (家有顽童) 于 (Sun Mar 15 02:14:51 2009) 提到:
Might be an entry-level problem --
Dummy/desired procedure is as follows:
proc sql;
create table new as
select a, b, c, max(d1) as d1, max(d2) as d2, .... max(d100) as d100
from table old
group by a, b, c;
quit;
I would like to create a new table from an old table using proc sql.
selected variables include d1 - d100,they are transformed by using max( )
function over the range defined by variables a, b, and |
|