topic Re: Converting formats and informats between Windows and Linux in SAS Procedures

Converting formats and informats between Windows and Linux

deleted_user — Wed, 20 May 2009 08:39:37 GMT

I'm using Linux and want to use a SAS file with formats that was made on a Windows computer. The formats are in a file (catalog) named formats.sas7bcat. I do not have access to the original SAS proc formats that created this file. I am able to read the datafile, but when a proc need a format I get the error "ERROR: File TUM.FORMATS.CATALOG was created for a different operating system.
ERROR: Format $CENTER not found or couldn't be loaded for variable Center." How can I convert the formats to Linux?

KnutH

Re: Converting formats and informats between Windows and Linux

LinusH — Wed, 20 May 2009 08:47:06 GMT

Basically, you need to export the catalog from the Windows environment in a transport file (see PROC CPORT/CIMPORT for details). If it's impossible to get an extract from your format catalog origin, maybe you have other collogues/friends with Windows SAS that can do it for you, or, ultimately, SAS mat do it for you if ask very friendly...;-)

/Linus

Re: Converting formats and informats between Windows and Linux

deleted_user — Tue, 16 Jun 2009 20:04:22 GMT

You can use the FileZilla to transfer file from Window to unix in ASCII mode

Re: Converting formats and informats between Windows and Linux

sbb — Tue, 16 Jun 2009 20:49:55 GMT

Hacks aside - suggest from experience that you stick with what works for the SAS system catalogs and files, and even so, post-migration test scenario execution is highly recommended.

Scott Barry
SBBWorks, Inc.

Moving and Accessing SAS Files between Operating Environments
http://support.sas.com/documentation/cdl/en/movefile/59598/HTML/default/moveacc.htm

Tips and Techniques For Moving Between Operating Environments
J. Meimei Ma, Quintiles, North Carolina, U.S.A.
Sandra Schlotzhauer, Schlotzhauer Consulting, North Carolina, U.S.A.
http://sas.com/proceedings/sugi23/Begtutor/p56.pdf