Problem accessing MS Access functions from SAS

From CCMDB Wiki
Revision as of 21:29, 13 November 2020 by Ttenbergen (talk | contribs) (link is dead; if we ever chose to go further with this we will have to look for other solution.)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Under the current setup, SAS can not see any queries in Centralized_data_front_end.accdb that contain either user defined or built-in MS Access functions. This means that most queries in front end can not be used by Julie in SAS.

In the short run, we can overcome this by using table-generating queries; SAS can access those.

Work-around

Julie runs Access queries that update temporary tables, which can then be read by SAS. EG: Created Variables.

Retrieved from "https://ccmdb.kuality.ca/index.php?title=Problem_accessing_MS_Access_functions_from_SAS&oldid=147231"