After deleting data in a table, what is the syntax to write all data to a table with no filtering ?
Define a LIBNAME to the SQL Server schema, and use PROC APPEND.
View solution in original post
What table? A SAS Data set? Show us your code please.
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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Register now!
Follow along as SAS technical trainer Dominique Weatherspoon expertly answers all your questions about SAS Libraries.
Find more tutorials on the SAS Users YouTube channel.