1 / 5

Bridging (Closing) the “bitness gap” in Sas 9.4

Bridging (Closing) the “bitness gap” in Sas 9.4. Ron Dewar Dalhousie U. and Cancer Care NS. Problem. 9.4 is 64-bit (requires 64-bit Windows 7) MS-Office tools are installed as 32-bit aps A simple proc import that ‘used to work’ now returns an error message:

salaam
Download Presentation

Bridging (Closing) the “bitness gap” in Sas 9.4

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Bridging (Closing) the “bitness gap”in Sas 9.4 Ron DewarDalhousie U. and Cancer Care NS

  2. Problem 9.4 is 64-bit (requires 64-bit Windows 7) MS-Office tools are installed as 32-bit aps A simple proc import that ‘used to work’ now returns an error message: 1101 PROC IMPORT OUT= WORK.topo_2_3 1102 DATAFILE= "&loc.\CCR System Reference Tables 2012.xls" 1103 DBMS=excel replace; 1104 SHEET="ICD-O-2 & 3 Topography codes"; 1105 1106 RUN; ERROR: Connect: Class not registered ERROR: Error in the LIBNAME statement.(Similarly for the ‘File/Import Data’ wizard)

  3. Resolution Google error message, first hit is http://support.sas.com/kb/43/933.html Which refers to ‘PC Files Server’ Google ‘sas PC Files Server’ http://support.sas.com/kb/43/802.html Install and make the following changes to your program

  4. resolution 1107 PROC IMPORT OUT= WORK.topo_2_3 1108 DATAFILE= "&loc\CCR System Reference Tables 2012.xls" 1109 DBMS=excelCS REPLACE; 1110 SHEET="ICD-O-2 & 3 Topography codes"; 1111 1112 RUN; NOTE: WORK.TOPO_2_3 data set was successfully created. … ALSO: ‘PC Files Server’ appears as a ‘Standard Data Source’ to the ‘File/Import Data’ wizard (which will now work)

  5. Similarly: Incompatible Format libraries ERROR: File CANC.FORMATS.CATALOG was created for a different operating system. Recreate the format library with a different name proc format lib = library.formats64; Format search option now looks like proc format ; options fmtsearch = (library.formats64 ); …then you can co-exist with your 32-bit colleagues until they all see the light

More Related