Problem accessing MS Access functions from SAS: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m changed to .accdb |
Ttenbergen (talk | contribs) m link is dead; if we ever chose to go further with this we will have to look for other solution. |
||
| Line 2: | Line 2: | ||
In the short run, we can overcome this by using table-generating queries; SAS can access those. | In the short run, we can overcome this by using table-generating queries; SAS can access those. | ||
== Work-around == | == Work-around == | ||
Latest revision as of 21:29, 13 November 2020
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.