Date:         Tue, 20 Jun 2000 18:17:46 GMT
Reply-To:     "Bruce F. Gilsen" <m1bfg00@NEWFED.FRB.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Bruce F. Gilsen" <m1bfg00@NEWFED.FRB.GOV>
Organization: Federal Reserve Board, Wash, DC
Subject:      Re: reading in V6.07 or earlier datasets with V8

In article <394E1867.8CADB1A6@phoebus.phor.com>, melissa@PHOR.COM (melissa) writes:
> To all of those using SAS V8 I have a question:
>
> What is the best way that you've found to read in datasets that were
> created in SAS V6.07 or earlier into V8?  Currently my company has both
> V6.12 and V8 available to us, but sometimes we have to access clientele
> datasets that were created in V6.07 or earlier.
>
> Both Proc Copy and Proc Datasets have been proposed as solutions to my
> dilemma, but I wasn't given clear examples of how to use them to
> accomplish this and I have been unable to figure it out thus far.
> Besides figuring out the proper code to use, a big source of confusion
> for me has been if I run the code in V6.12 or V8. If anyone could offer
> any insight I'd appreciate it very much.
>
> Thank you in advance for your help,
> Melissa Gaise

Melissa:

Here is what I posted on our intranet web site at the Federal Reserve
Board.  I hope it helps (if not, let me know, so that I can revise it).
The format isn't pretty because I dragged my mouse over the web page
but the content is the same.

Bruce Gilsen bruce.gilsen@frb.gov
========


1.4. UNIX SAS V607 data sets cannot be read

An older type of UNIX SAS data set, a "V607" data set, cannot be read in
Version 8. These data sets would probably have been created one of the
following ways.

  SAS data sets created in Release 6.07 and not updated since then.
  (Release 6.07 has not been the production release of SAS software
  at the Board since May 21, 1994).

  SAS data sets created in Release 6.09, 6.11, or 6.12 using the V607
  engine, most likely because the V607 engine was included in a LIBNAME
  statement such as the following.

     libname blah3 v607 '/my/directory/path' ;

If you try to read a V607 data set, an ERROR message similar to the
following is  generated.  The message refers to the 6.06 file format
because Release 6.07 used the 6.06 file format and Releases 6.09, 6.11,
and 6.12 use the 6.07 file format. Except for clarifying this error,
the file format information is not of interest.

     ERROR: File BLAH3.ONE.DATA is a 6.06 file format and not supported
     by this release.

To determine if a UNIX SAS data set is a V607 data set, execute PROC
CONTENTS for the data set in Release 6.12. The file format is 606 for
a V607 data set or 607 for a V612 data set.  The file format is printed
in the Output window (interactively under Xwindows) or LST file (for
non-interactive mode), but not in the PROC CONTENTS OUT= data set.
(Note. Look at the file format, not the engine.)

To make V607 data sets usable in Version 8, you can invoke Release 6.12,
and use PROC COPY to copy the data sets to a new directory, as in the
following examples.

Example 1. Copy the V607 data set SASDATA1 in the directory
'/my/directory/path1' to the V612 data set SASDATA1 (which is readable
in Version 8) in the directory '/my/directory/path2'.

     libname blah4 '/my/directory/path1' ;
     libname blah5 '/my/directory/path2' ;
     proc copy in=blah4 out=blah5 memtype=data;
       select sasdata1;
     run;

Example 2. Copy all of the V607 and V612 data sets in the directory
'/my/directory/path1' to V612 data sets (which are readable in Version 8)
in the directory '/my/directory/path2'.

     libname blah4 '/my/directory/path1' ;
     libname blah5 '/my/directory/path2' ;
     proc copy in=blah4 out=blah5 memtype=data;
     run;