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
Tag: enterprise-guide
How to count how many time some value appeard with defined ID in PROC SQL in SAS Enterprise Guide?
I have Table in SAS Enterprise Guide like below: Data type: ID – numeric SERVICE – character ID SERVICE 123 P1 123 P1 123 G 444 AB 56 c2 And I need to know how many time each ID bought each SERVICE, so as a result I need something like below: Because for example ID = 123 bought SERVICE =
How to create flag 0/1 inform whether was changed or not during 4 months between two columns in PROC SQL in SAS Enterprise Guide?
I have table in SAS Enterprise Guide like below: name of table: table123 date typ: ID – numeric DT – numeric VAL1 – string VAL2 – string ID DT VAL1 VAL2 123 20210523 PR P 123 20211222 P P 222 20210502 PR M 222 20210711 M PR 38 20210513 PR PR 991 20211123 M P And I need to create
How to query SSMS via SAS EG ODBC connection while using data from WORK?
Is there a way to send a SAS dataset through a proc sql odbc query in SAS EG so that it can be taken in and used by SQL server? ex) SAS Data WORK.A contains 3 columns ID, col1, col2. I have a table in Sql Management Studio environment with the same ID column. I would like to (somehow) do
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