topic Re: proc import through odbc in SAS Programming

proc import through odbc

Peter_C — Fri, 09 Oct 2009 16:01:58 GMT

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

Re: proc import through odbc

LinusH — Mon, 12 Oct 2009 11:45:43 GMT

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

Re: proc import through odbc

Peter_C — Mon, 12 Oct 2009 21:11:05 GMT

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

Re: proc import through odbc

Patrick — Mon, 12 Oct 2009 21:35:52 GMT

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.