Skip to content

Tag: enterprise-guide

SAS EG append new data and overwrite already existing rows

My goal is to update this table called DAGLIGEKORREKTIONER_lib_xlsx: Here i a sample of my data. Don’t mind the cmd prompt it is only to cover sensitive data. I then have a table with a similar structure called DAGLIGEKORREKTIONER: But how do I append the table DAGLIGEKORREKTIONER_lib_xlsx with DAGLIGEKORREKTIONER. And if DAGLIGEKORREKTIONER_lib_xlsx contains rows with the same “approval_text” as DAGLIGEKORREKTIONER

SAS pass through query to SQL Server

I have some troubles with passing through query to SQL Server. OS is RedHat 6. In SAS Enterprise Guide I try to execute this code: but I faced with error: ERROR: CLI execute error: [SAS][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]INSERT failed because the following SET options have incorrect settings: ‘QUOTED_IDENTIFIER’. Verify that SET options are correct for use