SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

Import excel file using pc file server not getting correct length

Reply
Super Contributor
Posts: 398

Import excel file using pc file server not getting correct length

Hello,

I'm using SAS 9.3  (TS1M2) 64-bit with Microsoft Office 2010 32-bit.  I have installed the 32-bit version of the pc file server.

I have followed 35563 - The location of the TypeGuessRows registry is different in SAS® 9.2 Phase 2 than in SAS® 9.1... and modified the TypeGuessRows to equal 0.    Within the excel file I would like to import there is a column that has notes and this can be up too 5000 characters.  When I use this code

proc import

    out=ImpTest

    datafile='C:\notes.xls'

    dbms= excelcs replace ;    

    sheet='Test' ;    

run ;

The notes column comes back as 1024, but when I replace "ExcelCS" with "XLS" as the DMBS value I get the correct max character length.   Is there a way to get the correct length using the PC File server value (ExcelCS)?

Thank you for any help,

Jerry

Post a Question
Discussion Stats
  • 0 replies
  • 275 views
  • 0 likes
  • 1 in conversation