ITCWeb Mobile

Data Conversions

File Extension	From Platform	From Type and Version	Target Platform	Target Type and Version
* SC2	Win9x	SAS 6.08	Unix	SAS 8.x
* SSD	Win9x	SAS 6.03, 6.04	Win9x, Win2K	SAS 8.x (sas7bdat)
SD2	Win9x	SAS 6.10, 6.11, 6.12	Unix	SAS 8.x (sas7bdat)
SSD01	Unix	SAS 6.09, 6.11, 6.12	Unix	SAS 8.x (sas7bdat)

* For help in bringing these files up-to-date, contact Research Computing Support by email res-consult@Virginia.EDU or by phone at (434)243-8800.

SC2

Research Computing Support staff must first transfer the file to a place where a Windows Version 6.12 session can read it.

The following example uses the C16PORT procedure in Release 6.12 to create a transport file from the INLIB.CAT catalog. Then a Release 6.12 catalog (OUTLIB.CAT) is created using the CIMPORT procedure. This example is from the SAS online docs:

LIBNAME inlib 'c:\cat608';
LIBNAME outlib 'c:\cat612';
PROC C16PORT file='transprt' c=inlib.cat;
RUN;
PROC CIMPORT infile='transprt' c=outlib.cat;
RUN;

The Release 6.12 SAS catalog can now be read by Version 8.x.

SSD

The V604 engine enables you to read from and write to Release 6.03 and Release 6.04 SAS data sets directly from a Version 8.x SAS session.

The layout of 6.03 and 6.04 datasets are the same. You can submit the following statements from a Version 8 SAS session:

LIBNAME tempin v604 "C:\temp\V6" ;
PROC PRINT DATA = tempin.dataname ;
RUN;

While it may be useful to access these older SAS datasets, they will need to be converted to Version 8.x datasets in order to take full advantage of Version 8 SAS features. Contact Research Computing Support for help with these conversions requiring earlier SAS versions.

/* Run this program in SAS 6.12    */

   LIBNAME tempin v604 "c:\temp\v6 " ;
   LIBNAME tempout "c:\temp\new6" ;
   PROC COPY in = tempin out = tempout ;
   RUN ;

The resulting SD2 datasets may in turn be converted to SAS 8.x datasets.

Alternatively, you can use the DATA step to do the conversion, as in the following example. This technique works well if you want to convert only one or two data sets in a particular SAS data library.

libname v604data v604 'c:\mydata';
libname windata V8 'd:\newdata';
data windata.eggplant;
   set v604data.eggplant;
run;

SD2

You can modify this program to convert SD2 datasets to saseb7dat datasets while using SAS 8.x:

TITLE 'Converting SAS dataset from Version 6 to 8' ;

LIBNAME in6  V6 'c:/your/directory/path'  ;

LIBNAME out8 V8 'c:/your/directory/path'  ;

DATA out8.dataname ; /* "dataname" is the name of your SAS dataset */

  SET in6.dataname  ;


/* UPPERCASE indicates SAS keywords and commands              */
/* lowercase indicates names and information you supply       */
/*                                                            */
/* Where "c:/your/directory/path" is the full directory path  */
/*   to where your current SAS version 6 dataset reside and   */
/*   the directory (hopefully a different one) where the      */
/*   version 8 datasets will reside.                          */
/*  You can have both version datasets in one directory, but  */
/*  we don't recommend it.  If you do so, you must always     */
/*  explicitly declare what SAS engine you're using on your   */
/*  LIBNAME statement                                         */

SSD01

This table identifies the supported file types that are created on the UNIX host by member and SAS release:

UNIX Filename Extensions by Member and SAS Release

Member Type	Version 6 Extension	Version 8 Extension
PROGRAM (DATA step)	.sspnn	.sas7bpgm
DATA	.ssdnn	.sas7bdat
INDEX	.snxnn	.sas7bndx
CATALOG	.sctnn	.sas7bcat
MDDB	.ssmnn	.sas7bmdb
DMDB	.snmnn	.sas7bdmd
PROC SQL view	.snvnn	.sas7bvew

Data sets are interchangeable among Sun, Solaris, AIX and MIPS hosts. Catalogs are interchangeable among Sun, Solaris, and MIPS. However, to use a catalog betwee AIX and the other UNIX hosts requires a transport file. See the SAS Online Documentation for more information on other Unix operating systems.

UNIX Host Filename Extensions

SAS Filename Extension nn	UNIX Host Group	Supported by SAS Release
		6.09	6.10	6.11	6.12
01	Sun	---	n/a	---	---
	Solaris	---	n/a	---	---
	AIX	---	n/a	---	---
	MIPS ABI	n/a	---	---	n/a
02	ULTRIX	---	n/a	n/a	n/a
	INTEL-ABI	---	n/a	---	---

Return to SAS Help