Tagged Questions

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 …