topic Write to Table in Programming 1 and 2 https://communities.sas.com/t5/Programming-1-and-2/Write-to-Table/m-p/681237#M581 <P>After deleting data in a table, what is the syntax to write all data to a table with no filtering ?</P> Thu, 03 Sep 2020 06:54:37 GMT PROCDATARUN 2020-09-03T06:54:37Z Write to Table https://communities.sas.com/t5/Programming-1-and-2/Write-to-Table/m-p/681237#M581 <P>After deleting data in a table, what is the syntax to write all data to a table with no filtering ?</P> Thu, 03 Sep 2020 06:54:37 GMT https://communities.sas.com/t5/Programming-1-and-2/Write-to-Table/m-p/681237#M581 PROCDATARUN 2020-09-03T06:54:37Z Re: Write to Table https://communities.sas.com/t5/Programming-1-and-2/Write-to-Table/m-p/681238#M582 <P>What table? A SAS Data set? Show us your code please.</P> Thu, 03 Sep 2020 06:57:17 GMT https://communities.sas.com/t5/Programming-1-and-2/Write-to-Table/m-p/681238#M582 PeterClemmensen 2020-09-03T06:57:17Z Re: Write to Table https://communities.sas.com/t5/Programming-1-and-2/Write-to-Table/m-p/681255#M583 <P>I have a WORK.STATS&nbsp;&nbsp;output on SAS that will be written to a table (MYSQL.STATSINPUT) &nbsp;in SQL server.</P><P>Table is already created in SQL server, data will be dropped using delete statement.</P><P>How to write WORK.STATS to MYSQL.STATSINPUT - all of the data.</P><P>&nbsp;</P> Thu, 03 Sep 2020 08:02:13 GMT https://communities.sas.com/t5/Programming-1-and-2/Write-to-Table/m-p/681255#M583 PROCDATARUN 2020-09-03T08:02:13Z Re: Write to Table https://communities.sas.com/t5/Programming-1-and-2/Write-to-Table/m-p/681262#M584 <P>Define a LIBNAME to the SQL Server schema, and use PROC APPEND.</P> Thu, 03 Sep 2020 08:58:40 GMT https://communities.sas.com/t5/Programming-1-and-2/Write-to-Table/m-p/681262#M584 Kurt_Bremser 2020-09-03T08:58:40Z