About Syrph

Syrph · ‎09-07-2011

Thanks for those ideas both appear to work but using the SAS/ODBC seems to work the best for me even though it is somewhat annoying to modify my codes to use it. The potential problem for anyone else using this option is that I have installed a 64 bit version of Microsoft office 2010 which installs the ODBC drivers for microsoft excel and access. This does not happen if you have a 32 bit version of Office. I needed to reinstall my office to get this to work. It would be very nice to get that information about EXCELCS from the people at SAS. I was wondering since SAS seems to create its own standalone server on the computer it is running on, could it be tricked into just using that server? That would be much nicer.

Syrph · ‎09-06-2011

Hello I was recently upgraded to a 64 bit version of Windows 7 using SAS 9.2. It appears that I cannot use dbms=Excel to import my excel files anymore for the reason explained more fully in the following post http://support.sas.com/kb/33/228.html I do not use a server for which to use EXCELCS, so I am left with using the Dbms=xls. Unfortunatly most of my programs import files with datetime formated variables but when I use the dbms=xls they are not retained. Using the origonal dbms=Excel on my old system I used various options such as USEDATE=NO to allow me to import a full datetime variable. It does not appear that dbms=xls has such features (or at least I haven't been able to find them). Can anyone point me in the right direction to solve this one or recommend any alternatives? Thanks

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Retaining datetime formats from excel files when using Proc import on ...

Retaining datetime formats from excel files when using Proc import on ...

Retaining datetime formats from excel files when using Proc import on ...

Retaining datetime formats from excel files when using Proc import on ...