BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
geneshackman
Pyrite | Level 9

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.

thanks

gene

1 ACCEPTED SOLUTION

Accepted Solutions
Ksharp
Super User

See this topic for more information about data set compatibility from SAS 9 to earlier releases. In general, compatibility requires no extra steps, it's usually preferred to regressing. Use the Compatibility Calculator to determine whether you have adequate compatibility. Remember that a SAS 9 file has the the same file extension (for example, SAS7BDAT) and virtually the same file format as a SAS 7 or 8 file.

 

For regressing all of the way back to version 6 (may lose some features), you can use the V6 engine.

 

This maybe give you low version sas dataset . also try to V7 V8 engine .

 

 

libname x v6 'c:\temp';
data x.class;
 set sashelp.class;
run;

 

 

Xia Keshan

View solution in original post

13 REPLIES 13
RW9
Diamond | Level 26 RW9
Diamond | Level 26

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.

geneshackman
Pyrite | Level 9

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?

RW9
Diamond | Level 26 RW9
Diamond | Level 26

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? 

geneshackman
Pyrite | Level 9

Good questions. I saved the file to a network drive. I'll find out about any error messages, how she accesses it, etc.

ballardw
Super User

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?


DaveR_SAS
SAS Employee

The following topic is a general reference about this issue: Using a SAS 9 File in a Previous Release

geneshackman
Pyrite | Level 9

Thanks. That looks great!

TomKari
Onyx | Level 15

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.

Tom

geneshackman
Pyrite | Level 9

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!

Gene

TomKari
Onyx | Level 15

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!

Patrick
Opal | Level 21

I believe the answer provides is what you're looking for. You need to create the SAS file using option "ExtendObsCounter=no"

http://support.sas.com/documentation/cdl/en/lrcon/67401/HTML/default/viewer.htm#p1ldhc0p7imdegn1hie6...

Syntax

EXTENDOBSCOUNTER=YES | NO

Syntax Description

YES

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

default.

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.

NO

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.

Ksharp
Super User

See this topic for more information about data set compatibility from SAS 9 to earlier releases. In general, compatibility requires no extra steps, it's usually preferred to regressing. Use the Compatibility Calculator to determine whether you have adequate compatibility. Remember that a SAS 9 file has the the same file extension (for example, SAS7BDAT) and virtually the same file format as a SAS 7 or 8 file.

 

For regressing all of the way back to version 6 (may lose some features), you can use the V6 engine.

 

This maybe give you low version sas dataset . also try to V7 V8 engine .

 

 

libname x v6 'c:\temp';
data x.class;
 set sashelp.class;
run;

 

 

Xia Keshan

nkhamgal
Calcite | Level 5

Hi Geneshackman,


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

options ExtendObsCounter=no;

or    

option EOC=NO

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.

Regards,

Nilesh Khamgal

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 13 replies
  • 10937 views
  • 6 likes
  • 8 in conversation