b******y 发帖数: 234 | 1 用sql procedure怎样 creative table? 或者怎样input data?
比如说
这组数据
Sample Data for Weighted Average
Obs Value Weight Gender
1 2893.35 9.0868 F
2 56.13 26.2171 M
3 901.43 -4.0605 F
4 2942.68 -5.6557 M
5 621.16 24.3306 F
6 361.50 13.8971 M
7 2575.09 29.3734 F
8 2157.07 7.0687 M
9 690.73 -40.1271 F
10 2085.80 24.4795 M | n*****s 发帖数: 10232 | 2 proc sql;
insert into yourdata;
set value=2893.35 weight=9.0868 gender="F";
insert into yourdata;
set value=56.13 weight=26.2171 gender="M";
....
....
注意考虑定义var这些细节
【在 b******y 的大作中提到】 : 用sql procedure怎样 creative table? 或者怎样input data? : 比如说 : 这组数据 : Sample Data for Weighted Average : Obs Value Weight Gender : 1 2893.35 9.0868 F : 2 56.13 26.2171 M : 3 901.43 -4.0605 F : 4 2942.68 -5.6557 M : 5 621.16 24.3306 F
| a****m 发帖数: 693 | 3 这样是不是也可以
proc sql;
insert into yourtargettable(value, weight,Gender)
select value, weight, Gender
from thesampeltable;
quit; | j*******9 发帖数: 27 | 4 proc sql;
create table **.**;
(Value num, Weight num, Gender char(3));
run;
proc sql;
insert into table **.**
values (2893.35, 9.0868, 'F')
.
.
.
;
run;
quit; | b******y 发帖数: 234 | |
|