desired 结果
ProdId Price ProductType Sales Returns
K12S 95.50 OUTDOOR 15 2
B132S 2.99 CLOTHING 300 10
R18KY2 51.99 EQUIPMENT 25 5
3KL8BY 6.39 OUTDOOR 125 15
DY65DW 5.60 OUTDOOR 45 5
DGTY23 34.55 EQUIPMENT 67 2
我的code:
data products;
length ProductType$9;
input ProdId$ Price ProductType$ Sales Returns;
datalines;
K12S 95.50 OUTDOOR 15 2
B132S 2.99 CLOTHING 300 10
R18KY2 51.99 EQUIPMENT 25 5
3KL8BY 6.39 OUTDOOR 125 15
DY65DW 5.60 OUTDOOR 45 5
DGTY23 34.55 EQUIPMENT 67 2
;
run;
proc print;
run;
结果,column顺序不对
Obs ProductType ProdId Price Sales Returns
1 OUTDOOR K12S 95.50 15 2
2 CLOTHING B132S 2.99 300 10
3 EQUIPMENT R18KY2 51.99 25 5
4 OUTDOOR 3KL8BY 6.39 125 15
5 OUTDOOR DY65DW 5.60 45 5
6 EQUIPMENT DGTY23 34.55 67 2
请问怎么能调整column顺序?拜谢!!!