Dear Ksharp I read the values from table 'three' and insert it to 'one', how can I keep the rsult of (select *... ) in a table? It seems that it doesn't understand the code. my code is: data three; input name $ sex$ age@@ height@@ weight@@; cards; Patrick M 30 52.2 89.4 ; run; proc sql; insert into one (name, sex, age, height, weight) select name, sex, age, height, weight from three; select * from one except select * from two; quit; run;
... View more