data2的input语句,提交回帖后,美元符号总是会自己消失,很奇怪。
----------------------------
data data1;
input a b c ;
id=_n_;
cards;
1 2 5
. 4 7
6 . 3
;
run;
data data2;
infile cards dsd;
input a $ b $ c $;
id=_n_;
cards;
(1),(3),(5)
,(3),(9)
(4),,(9)
;
run;
---------------------------------------------------------------------------
proc sql;
create table data3 as
select cat(data1.a,data2.a) as newa,
cat(data1.b,data2.b) as newb,
cat(data1.c,data2.c) as newc
from data1,data2
where data1.id=data2.id;
quit;