Reply HA Posted October 9, 2014 at 9:48 am | Permalink Thank you Chris. -H Reply Jim Walker Posted October 22, 2014 at 1:22 pm | Permalink Hey Chris I ran Everything pointed me to this article, some links took a step or two but all led here. And do you use the Import Wizard?What is the version and type (file extension) of the Excel file?Full code and log would help. However, if importing MS Access data, then the EG bitness must match Microsoft Office. http://softbb.net/sas-error/sas-error-class-not-registered-9-3.html
Jon Cass Posted September 30, 2015 at 3:30 pm | Permalink I don't understand the fix for the "incompatible formats catalog" section. ERROR: Connect: Class not registered ERROR: Error in the LIBNAME statement. In previous migrations \ transfers within 32 bit windows I'm used to the fact that a CPORT \ CIMPORT wont transfer the WSAVE's across and have to use a PROC CATALOG Finally let's go the easiest solution: as you may know, SAS 9.1.3 is a 32-bit release, SAS 9.2 and 9.3 are 64-bit release.
The database might support different time precision than SAS. If the compatibility need is paramount, I recommend the 32-bit version. It is really weird. Reply Chris Hemedinger Posted August 6, 2014 at 2:49 pm | Permalink Yes, a few ways: - If you're using DBMS=XLSX, then the Microsoft data libraries aren't used at all, so
Reply Chris Hemedinger Posted December 4, 2014 at 9:20 am | Permalink Chelly, It's difficult to guess what's going on here; we'll need more details. You can accomplish this by using the Generic Library template though. I saw that others suggested SAS Enterprise Guide (EG) as a solution, but I haven't had luck with that. You might already have it in place.
But one of the problems I'm having is that SAS won't read the variable names as you know, 9220184 is an invalid SAS name so SAS changes it to _220184. 3) These approaches use the PC Files Server, which is a separate small application that is provided with SAS/ACCESS to PC Files. I am running windows 7 with 64bit EG and 64bit Office. http://support.sas.com/kb/43933.html SAS Programmer's BookShelf           Related links: Continue to next: How to read large csv file: Number of names found is less than...   SAS tutorial home
SAS Blogs Home > The SAS Dummy > The top gotchas when moving to 64-bit SAS for Windows « The makeup of SAS Global Forum Using Windows PowerShell to view your Gotcha #2: Incompatible FORMATS catalog Suppose that you have a library of user-defined formats that you once created by using PROC FORMAT. Message 5 of 10 (3,135 Views) Reply 0 Likes TomKari Valued Guide Posts: 914 Re: Error in SAS import..connection failed & error in libname statement Options Mark as New Bookmark Subscribe That also uses the PC Files Server, so that component would need to be present/installed.
Is the only way of retrofitting that project to 64-bitness is to convert those Import Data Tasks to written Proc Import code? Then you can rebuild them on the target system using PROC FORMAT and the CTLIN= option. Consider posting your question -- with sample data and details of your SAS version -- to one of our support communities. I've successfully transferred all other catalogs using CPORT\CIMPORT.
Reply Pablo Posted December 9, 2013 at 5:05 pm | Permalink Thank Chris for the answer I will refine my question: can I use the import wizard (File/Import data) or not this contact form I was using proc import for access datatables on my 32 bit mascine at work. I used the PC Files Server, but have been having trouble with export syntax since I'm not on a server, just my local drive using it to translate between bit-ness. Operating System and Release InformationProduct FamilyProductSystemProduct ReleaseSAS ReleaseReportedFixed*ReportedFixed*SAS SystemSAS/ACCESS Interface to PC FilesMicrosoft® Windows® for x649.39.3 TS1M0Microsoft Windows Server 2003 for x649.39.3 TS1M0Microsoft Windows Server 2008 for x649.39.3 TS1M0Windows 7 Enterprise
Then you can spot check the time/datetime values in your actual export file. They fixed the problem by getting me to update my MS access database engine here: http://www.microsoft.com/en-us/download/details.aspx?id=13255 Apparently, the folks that installed office on my machine did not update the engine so Reply Chris Hemedinger Posted August 18, 2014 at 9:25 am | Permalink SAS 9.1.3 can run on a 64-bit Windows machine in 32-bit mode. have a peek here These assume all catalog files are V9, at least.
User-defined formats are stored in SAS catalogs, which are a sort of SAS-specific file system structure that SAS can access during your session. You can't use your local C: drive. I suspect that much of that information is in SAS catalogs, which need to be converted using PROC CPORT or perhaps PROC MIGRATE.
You can then easily recreate the formats "on the fly" by using PROC FORMAT and the CNTLIN option. Reply Chris Hemedinger Posted August 25, 2014 at 8:45 am | Permalink Ray, If importing Excel, then I would expect your import tasks to continue working. EXCELCS helps me to read in most xls file in SAS 9.4. Econ.
But you should be able to do this with your 32-bit Excel today: libname myxl PCFILES "C:\Users\Desktop\test.xlsx"; If you have the PC Files Server component installed. See this SAS Note for how to get started. EG 6.1m1 offers a 32-bit version, and if you can take that option -- that's the best chance of reusing the work you've already captured. http://softbb.net/sas-error/sas-error-handling-example.html The code I am using is proc export data=test dbms= ACCESS outfile="M:\AFolder\BFolder\test1.mdb" replace; run; And what might be the reason of missing of ACCESS export in the wizard.
Gotcha #3: Different data set encoding triggers CEDA If you use SAS data sets that were created by a 32-bit version of SAS, you can read them without modification in 64-bit ERROR The requested URL could not be retrieved The following error was encountered while trying to retrieve the URL: http://0.0.0.9/ Connection to 0.0.0.9 failed. Best, Liang Reply Chris Hemedinger Posted December 15, 2015 at 2:15 pm | Permalink I know that the Microsoft driver can have trouble with certain datetime values. SAS on my laptop was unable to import data containing strange Danish letters (æ,ø,å).
Thanks in advance for your cooperation. Reply Lyn Posted July 19, 2016 at 5:37 am | Permalink Thank you so much for this post- it fixed my problem immediately! Error: Procedure ***** not Found. But this is not available in the 64-bit version, due to the architecture differences." So do you mean I wouldn't be able to export data as MDB as I am using
The Fix: SAS provides the utility procedures CPORT and CIMPORT to allow you to transfer catalog content across different operating environments, and you can certainly take that approach for this scenario. When you say "update your MS Access ..... " so do you mean I need to save the SAS dataset in ODBC dataset and then exporting the dataset into Access using And this problem, I give up on trying to solve. If you have a mixed environment on your team where some people have 32-bit SAS and others have 64-bit SAS, it might be easier to decompose the format definitions down to
In the rare times that these statements are accepted by the different SAS DBMS= options, I get the other problem: SAS only importing 255 columns. Reply Chris Hemedinger Posted August 31, 2015 at 4:24 pm | Permalink Jon, yes, I'd agree with that. Will keep you all posted. And this problem, I give up on trying to solve.
Reply Collins Posted August 18, 2014 at 9:22 am | Permalink Hi, Please I have a portable SAS 9.1.3 running on 32bit computer, how can I convert it to run on Forsyth Posted February 4, 2016 at 4:12 pm | Permalink I have a set of project files created in SAS 9.3 using SAS/ETS 32 bit.