05-27-2014 09:50 AM
I have sas 9.4. Another person in our office has 9.2 and she can't read the data sets I save. How do I save data sets to she can read them. I also have a 64 bit machine, I think she has 32 bit. Pretty sure we are all running on windows 7.
05-27-2014 10:09 AM
I don't see SAS datasets being an issue between versions. Are you sure there is nothing else wrong. Only compiled SAS catlogs cause an issue between 32bit and 64bit.
For porting between platforms there is cport, or export to csv/xml.
05-27-2014 10:13 AM
Really? So someone using 9.2 on a 32 bit machine should be able to read a data set I saved using 9.4 on a 64 bit machine? (except for the compiled sas catalog issue) Anything else I should look for?
05-27-2014 10:17 AM
Yep, as far as I am aware, datasets are backward compatible whereas catalogs are not. What is the error do you get when you libname to a location where the datasets are placed and then they double click on the datasets in the Explorer with SAS?
05-27-2014 10:15 AM
It might help to provide some information such as how your colleague is trying to read the data set and how you transferred it to her. Do you put the file on a shared network drive, send it via email or something else. Any error messages involved? Code used to read/use the set?
05-27-2014 11:46 AM
I can't find the definitive statement in the documentation after a short search, but I'm quite positive that the file formats are the same in these two versions. The only thing I can think of is you may be using different internationalization and localisation options (different character sets). Please post error messages.
05-27-2014 11:55 AM
Fortunately, the person who had trouble reading my data set is getting 9.3 installed, so that will take care of it for the moment. However, we may still need to do this in the future, so I'll look at Dave R's link, and keep all the other answers in mind too.
Thanks to everyone!
05-27-2014 12:00 PM
Well, I wouldn't be too optimistic. Since I believe that the 9.2 through 9.4 file formats are identical, in theory the problem should still arise.
Keep us posted!
08-09-2014 04:06 AM
EXTENDOBSCOUNTER=YES | NO
requests an enhanced file format in a newly created SAS data file that counts
observations beyond the 32-bit limitation. Although this SAS data file is created for
an operating environment that stores the number of observations with a 32-bit
integer, the data file behaves like a 64-bit file with respect to counters. This is the
Restrictions A SAS data file that is created with an extended observation count is
incompatible with releases prior to SAS 9.3. If the SAS data file was
created in SAS 9.3 or later and EXTENDOBSCOUNTER was set to
YES when the SAS data file was created, you must re-create the SAS
data file with EXTENDOBSCOUNTER=NO.
EXTENDOBSCOUNTER=YES is valid only for an output SAS data
file whose internal data representation stores the observation count as
a 32-bit integer. EXTENDOBSCOUNTER=YES is ignored for SAS
data files with a 64-bit integer. For a table that lists the operating
environments and the OUTREP= data representation values that are
appropriate with EXTENDOBSCOUNTER=YES, see “When
Extending the Observation Count Is Supported” in Chapter 26 of SAS
Language Reference: Concepts.
specifies that the maximum observation count in a newly created SAS data file is
determined by the long integer size for the operating environment. In operating
environments with a 32-bit integer, the maximum number is 231–1 or approximately
two billion observations (2,147,483,647). In operating environments with a 64-bit
integer, the maximum number is 263–1 or approximately 9.2 quintillion observations.
08-07-2014 10:31 AM
You just have to do one simple thing before creating any dataset in SAS higher versions (9.2,9.3,9.4)
You need to use
This Options will help you to create compatible datasets from higher versions to lower versions.
I too was facing the same problem and it worked out for me.
I am sure it will work out for you also.
Other than this for permanent solution you can update your sas config file
option EOC=NO in a SAS configuration file.