proc sql to copy records from one table to another

[Naveen1111]

Hi All,

i have one question. There are two datasets A and B, want to move/copy two rows from table B to A. Could someone help me which syntax I should use IN proc SQL.

Regards

Navin 

[Kurt_Bremser · Accepted solution]

proc sql;
insert into a
(select * from b where /* add condition that selects the two rows */)
;
quit;

For more detailed help, supply example data for both datasets in usable form (data steps with datalines).

[Naveen1111]

Many many thanks for ur support. I m sorry as i m a new learner and will keep posting these qstions.