Problem accessing MS Access functions from SAS: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) Created page with "Under the current setup, SAS can not see any queries in Centralized_data_front_end.mdb that contain either user defined or built-in MS Access functions. This means tha..." |
Ttenbergen (talk | contribs) m link is dead; if we ever chose to go further with this we will have to look for other solution. |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
Under the current setup, [[SAS]] can not see any queries in [[Centralized_data_front_end. | 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. | 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]]. | |||
[[Category:2013 data upgrades]] | [[Category:2013 data upgrades]] | ||
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.