Write to Table

[PROCDATARUN]

After deleting data in a table, what is the syntax to write all data to a table with no filtering ?

[PeterClemmensen]

What table? A SAS Data set? Show us your code please.

[PROCDATARUN]

I have a WORK.STATS  output on SAS that will be written to a table (MYSQL.STATSINPUT)  in SQL server.

Table is already created in SQL server, data will be dropped using delete statement.

How to write WORK.STATS to MYSQL.STATSINPUT - all of the data.

[Kurt_Bremser · Accepted solution]

Define a LIBNAME to the SQL Server schema, and use PROC APPEND.