Problem accessing MS Access functions from SAS: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m documented solution of generating temp data |
Ttenbergen (talk | contribs) m link is dead; if we ever chose to go further with this we will have to look for other solution. |
||
| (One intermediate revision 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 == | == 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.