0
votes
1answer
8 views
Accessing SAS Dataset through ODBC SAS.LocalProvider
Hi All
I'm trying to access a local SAS dataset from VBA in Excel 2007. Using code I found on the interwebs I can get it to return an entire table, but am not able to get it to e …
3
votes
3answers
239 views
Proc export - SAS not recognising new version of excel
I'm trying to convert a SAS file to Excel2003, unfortunately my version of SAS doesn't seem to recognise Office applications beyond 2002. Is there any way to change that?
I've trie …
0
votes
0answers
109 views
OLEDB Excel Connection in Read-Only Mode?
I'm having trouble getting OLEDB for Excel to work in read-only mode.
The document is usually accessed by another user, and I'd like to import its contents to SAS without needing t …