SAS PC Files Server is a Windows service that starts automatically, and is used to translate the 32-bit Office data to 64-bit SAS.Īll existing SAS code to import Excel or Access files will need to be modified: To import Excel or Access files from 32-bit Office to 64-bit SAS, you will need to install 32-bit SAS PC Files Server (included with your SAS installation). If you regularly need to share SAS formats catalogs with others who use 32-bit SAS, be sure to send them the formats catalog in export form, or as a SAS dataset. See Transporting SAS Libraries for more information about this process. LIBNAME saslib64 'C:\mysasdir64\' PROC CIMPORT LIBRARY=saslib64 INFILE='C:\mysasdir\transport.exp' RUN Storing them in a new folder avoids any confusion. This creates 64-bit version of all datasets and formats catalogs originally in C:\mysasdir. Using 64-bit SAS, import transport.exp to C:\mysasdir64. LIBNAME saslib 'C:\mysasdir\' PROC CPORT LIBRARY=saslib FILE='C:\mysasdir\transport.exp' RUN Using 32-bit SAS, export the contents (both datasets and formats catalogs) of C:\mysasdir to file transport.exp. Be sure to complete this before your 32-bit SAS license expires! Here is some sample code: This requires you to have access to 32-bit SAS during the migration process. Lacking original SAS code, export the formats catalog using 32-bit SAS, then import using 64-bit SAS. If you have the original SAS code, simply run that code using 64-bit SAS. If you have formats catalogs created with 32-bit SAS, you will need to re-create them using 64-bit SAS. SAS Formats catalogs (.sas7bcat files) are NOT compatible between 32-bit and 64-bit SAS. For improved efficiency, convert the dataset to 64-bit, using PROC CPORT/CIMPORT, discussed below. However, doing this will create some inefficiency, as SAS will be doing the conversion "on-the-fly". SAS datasets (.sas7bdat files) created with 32-bit SAS can be read directly using 64-bit SAS.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |