BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
PROCDATARUN
Obsidian | Level 7

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

1 ACCEPTED SOLUTION
3 REPLIES 3
PeterClemmensen
Tourmaline | Level 20

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

PROCDATARUN
Obsidian | Level 7

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.

 

sas-innovate-2024.png

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!

LIBNAME 101

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.

Discussion stats
  • 3 replies
  • 768 views
  • 2 likes
  • 3 in conversation