DATA Step, Macro, Functions and more

proc import through odbc

Reply
Valued Guide
Posts: 2,175

proc import through odbc

Hi there

do you know any way of persuading proc import to access an excel workbook range through the SAS/Access Interface to ODBC.
.. ... ... (not sas/access to PC File formats)
enquiring minds want to know if it is possible;-)

PeterC
Super User
Posts: 5,256

Re: proc import through odbc

Should be possible by using the n literal when specifying work-sheet name. There is a limitation on the total name lenght though:

http://support.sas.com/kb/33/490.html

/Linus
Data never sleeps
Valued Guide
Posts: 2,175

Re: proc import through odbc

thank you Linus,
but I don't think that works through proc import, at least I've found no way, so far. Looks like we need to revert to Access to PC File formats

PeterC
Respected Advisor
Posts: 3,887

Re: proc import through odbc

Excel can be an ODBC data source so accessing it via SAS/ODBC should be possible.
http://www.datamystic.com/datapipe/excel_odbc.html

I never tried it and SAS Access to PC File formats is sure much more convenient.
Ask a Question
Discussion stats
  • 3 replies
  • 140 views
  • 0 likes
  • 3 in conversation