Re: proc import through odbc

Peter_C · Posted 10-09-2009 12:01 PM

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

LinusH · Posted 10-12-2009 07:45 AM

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

Peter_C · Posted 10-12-2009 05:11 PM

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

Patrick · Posted 10-12-2009 05:35 PM

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.

proc import through odbc