Title | Old Stat/Transfer: Converting SAS datasets to Stata using Stat/Transfer | |
Author | Steve Dubnoff, Circle Systems |
SAS transport files are the subject of most of our technical support questions. Part of the problem is that SAS provides many names for the same file format and a similar name — CPORT — for another format. The only documented format, and the one recommended by SAS for transporting data to other platforms, is the format produced by the XPORT engine. That is the format Stat/Transfer can convert.
In addition, there are in all fairnessa number of computer/technical issues outside of SAS's control that can make what starts as a valid SAS Transport file into an invalid one. This is especially true if the original file starts out on an IBM mainframe or a VAX. SAS provides a technical document on their website that outlines these issues.
Stat/Transfer tries to trap many of the errors that occur because the file is in the wrong format or because it has been damaged in transport from a different host, but, sometimes, it simply becomes confused and must stop with the “No message available” error.
When making Transport files in SAS, make sure you use a reasonable facsimile of the example SAS program in the Stat/Transfer manual. Do not use PROC CPORT, as this produces a file in an entirely different format that is readable only by SAS.
When you have trouble converting a Transport file, particularly if you did not produce the file yourself, look at the very first line of the file. It should say something like
HEADER RECORD*******LIBRARY HEADER RECORD
If it does not, it is not a SAS transport file, and Stat/Transfer will not be able to read it.
Learn
Free webinars
NetCourses
Classroom and web training
Organizational training
Video tutorials
Third-party courses
Web resources
Teaching with Stata
© Copyright 1996–2024 StataCorp LLC. All rights reserved.
×
We use cookies to ensure that we give you the best experience on our website—to enhance site navigation, to analyze usage, and to assist in our marketing efforts. By continuing to use our site, you consent to the storing of cookies on your device and agree to delivery of content, including web fonts and JavaScript, from third party web services.
Cookie Settings
Last updated: 16 November 2022
StataCorp LLC (StataCorp) strives to provide our users with exceptional products and services. To do so, we must collect personal information from you. This information is necessary to conduct business with our existing and potential customers. We collect and use this information only where we may legally do so. This policy explains what personal information we collect, how we use it, and what rights you have to that information.
These cookies are essential for our website to function and do not store any personally identifiable information. These cookies cannot be disabled.
This website uses cookies to provide you with a better user experience. A cookie is a small piece of data our website stores on a site visitor's hard drive and accesses each time you visit so we can improve your access to our site, better understand how you use our site, and serve you content that may be of interest to you. For instance, we store a cookie when you log in to our shopping cart so that we can maintain your shopping cart should you not complete checkout. These cookies do not directly store your personal information, but they do support the ability to uniquely identify your internet browser and device.
Please note: Clearing your browser cookies at any time will undo preferences saved here. The option selected here will apply only to the device you are currently using.