https://communities.sas.com/t5/New-SAS-User/proc-sql-to-copy-records-from-one-table-to-another/m-p/675214#M23612 <PRE><CODE class=" language-sas">proc sql; insert into a (select * from b where /* add condition that selects the two rows */) ; quit;</CODE></PRE> <P>For more detailed help, supply example data for both datasets in usable form (data steps with datalines).</P> Fri, 07 Aug 2020 10:44:59 GMT Kurt_Bremser 2020-08-07T10:44:59Z https://communities.sas.com/t5/New-SAS-User/proc-sql-to-copy-records-from-one-table-to-another/m-p/675205#M23606 <P>Hi All,</P> <P>&nbsp;</P> <P>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.</P> <P>&nbsp;</P> <P>Regards</P> <P>Navin&nbsp;</P> Sat, 08 Aug 2020 13:07:21 GMT https://communities.sas.com/t5/New-SAS-User/proc-sql-to-copy-records-from-one-table-to-another/m-p/675205#M23606 Naveen1111 2020-08-08T13:07:21Z https://communities.sas.com/t5/New-SAS-User/proc-sql-to-copy-records-from-one-table-to-another/m-p/675214#M23612 <PRE><CODE class=" language-sas">proc sql; insert into a (select * from b where /* add condition that selects the two rows */) ; quit;</CODE></PRE> <P>For more detailed help, supply example data for both datasets in usable form (data steps with datalines).</P> Fri, 07 Aug 2020 10:44:59 GMT https://communities.sas.com/t5/New-SAS-User/proc-sql-to-copy-records-from-one-table-to-another/m-p/675214#M23612 Kurt_Bremser 2020-08-07T10:44:59Z https://communities.sas.com/t5/New-SAS-User/proc-sql-to-copy-records-from-one-table-to-another/m-p/675238#M23614 Many many thanks for ur support. I m sorry as i m a new learner and will keep posting these qstions. Fri, 07 Aug 2020 13:34:22 GMT https://communities.sas.com/t5/New-SAS-User/proc-sql-to-copy-records-from-one-table-to-another/m-p/675238#M23614 Naveen1111 2020-08-07T13:34:22Z