topic Re: reading sas dataset created in older version in SAS Programming

reading sas dataset created in older version

havmaage — Thu, 07 Jan 2021 10:31:54 GMT

Hi,

Im trying to read a dataset "application_data" created in sas 9.2 from my sas 9.4 env,

when running this

libname old "s:\work";

    data read_old;

          set old.application_data;

    run;

I gives me the error

ERROR: File OLD.APPLICATION_DATA DATA not compatible with this SAS Version

I am able to read the dataset in SASEG 7.1

by open the dataset from the file menu

But i need to do this in code because im running in batch mode.

I have been looking at cport cimport but that did not solve my issue,

Any ideas

Re: reading sas dataset created in older version

Kurt_Bremser — Thu, 07 Jan 2021 11:43:18 GMT

According to this: https://support.sas.com/kb/49/496.html , this message indicates that you are trying to read a dataset created with a newer SAS version in the older 9.2. Please check your involved SAS versions.

Re: reading sas dataset created in older version

Ksharp — Thu, 07 Jan 2021 12:08:47 GMT

Try:

libname old v6 "s:\work";

Re: reading sas dataset created in older version

ballardw — Thu, 07 Jan 2021 16:40:55 GMT

@havmaage wrote:

Hi,

Im trying to read a dataset "application_data" created in sas 9.2 from my sas 9.4 env,

when running this
libname old "s:\work";

    data read_old;

          set old.application_data;

    run;
I gives me the error

ERROR: File OLD.APPLICATION_DATA DATA not compatible with this SAS Version

I am able to read the dataset in SASEG 7.1

by open the dataset from the file menu

But i need to do this in code because im running in batch mode.

I have been looking at cport cimport but that did not solve my issue,

Any ideas

Do you have access to the 9.3 or later version of SAS that likely created the Old.application_data set?

If so you might get around this by creating a different data set using the option EXTENDOBSCOUNTER data set option. There is header information in later versions of SAS data sets that are not compatible with 32 bit systems likely used by SAS 9.2.

Run this in the 9.4 SAS system and use the old.app_data_noextobs.

data old.app_data_noextobs (extendobscounter=no);
   set old.application_data;
run;

If you have many data sets to use might consider creating a new library and use the LIBNAME option extendobs=no. Then copy the data sets from OLD to that library using Proc Copy or Proc Datasets. The new library will not have the extended observation count range that is likely to be the issue. Again, the Libname would have to run on SAS 9.3 or later to use the option when files are created there.