FOCUS AREAS

Step 2

Migration

Best Practices Migration with PROC MIGRATE: Migrate Files

Special Topic: Finding SAS Data Libraries under Directory-Based Operating Environments

If you are responsible for the data migration of a large organization, you might need help finding all the SAS data libraries.

To find SAS data libraries on a machine, use operating environment commands or a tool like a PERL script to look for files with SAS extensions.

The rest of this topic lists the SAS file extensions to look for under directory-based operating environments, which include all platforms except the z/OS bound library method of file organization. The z/OS operating environment is included here if you're running under UNIX System Services (USS), which include the Hierarchical File System (HFS) and the z/OS UNIX File System (zFS). If you need the file extensions for Version 5, let us know.


Version 7 and Later

Beginning in Version 7, all operating environments use the same extensions for their SAS files.

File Extensions, Version 7 or Later
MemberBase Engine Extension Sequential Engine Extension
SAS data file .sas7bdat .sas7sdat
SAS catalog .sas7bcat .sas7scat
Stored compiled DATA step program .sas7bpgm .sas7spgm
Index file .sas7bndx .sas7sndx
View .sas7bvew .sas7svew
SAS/ACCESS access or view descriptor .sas7bacs .sas7sacs
MDDB file .sas7bmdb .sas7smdb
FDB file .sas7bfdb .sas7sfdb
Item store .sas7bitm .sas7sitm
Audit file .sas7baud .sas7saud
DMDB file .sas7bdmd .sas7sdmd
Extended attributes file .sas7bxat none

FAT File Extensions on PC1 Environments, Version 7 and 8
MemberBase Engine Extension Sequential Engine Extension
SAS data file .sd7 .qd7
SAS catalog .sc7 .qc7
Stored compiled DATA step program .ss7 .qs7
Index file .si7 .qi7
View .sv7 .qv7
SAS/ACCESS access or view descriptor .sa7 .qa7
MDDB file .sm7 .qm7
FDB file .sf7 .qf7
Item store .sr7 .qr7
Audit file .st7 .qt7
DMDB file .s7m .q7m

1 See a special topic for information about the SHORTFILEEXT option and the FAT (file allocation table) file system for Windows and OS/2.


Version 6

Prior to Version 7, SAS file extensions depend on the operating environment.

UNIX2 and Macintosh3 File Extensions, Version 6
MemberBase Engine Extension Sequential Engine Extension
SAS data file3 .ssd0nn .sdq0nn
SAS catalog3 .sct0nn .scq0nn
Stored compiled DATA step program3 .ssp0nn .ssq0nn
Index file3 .snx0nn .siq0nn
View .ssv0nn .svq0nn
SAS/ACCESS access or view descriptor.ssa0nn .saq0nn
MDDB file .ssm0nn .smq0nn
FDB file .sfd0nn .sfq0nn
Item store .sit0nn .srq0nn
Audit file .sst0nn .stq0nn
DMDB file .snm0nn .sqn0nn

2 nn indicates the operating environment group as in the following table.
3 For these member types, nn=01 indicates the Macintosh operating environment as well.

Environment Indicators
Indicator nn Environment Group
01 HP-UX
Sun
Solaris
AIX
MIPS ABI
Macintosh (see note 3 above)
02 ULTRIX
INTEL-ABI
04 COMPAQ Digital UNIX

Windows and OS/2 File Extensions, Version 6
MemberBase Engine Extension Sequential Engine Extension
SAS data file .sd2 .sdq
SAS catalog .sc2 .scq
Stored compiled DATA step program .ss2 .ssq
Index file .si2 .siq
View .sv2 .svq
SAS/ACCESS access or view descriptor .sa2 .saq
MDDB file .sm2 n/a
FDB file .sf2 n/a
Item store n/a n/a
Audit file n/a n/a
DMDB file .sdm n/a

OpenVMS File Extensions, Version 6
MemberBase Engine Extension Sequential Engine Extension
SAS data file .SASEB$DATA .SASV6SEQ$DATA
SAS catalog .SASEB$CATALOG .SASV6SEQ$CATALOG
Stored compiled DATA step program .SASEB$PROGRAM .SASV6SEQ$PROGRAM
Index file .SASEB$INDEX .SASV6SEQ$INDEX
View .SASEB$VIEW .SASV6SEQ$VIEW
SAS/ACCESS access or view descriptor .SASEB$ACCESS .SASV6SEQ$ACCESS
MDDB file .SASEB$MDDB .SASV6SEQ$MDDB
FDB file .SASEB$FDB .SASV6SEQ$FDB
Item store .SASEB$ITEMSTOR .SASV6SEQ$ITEMSTOR
Audit file .SASEB$AUDIT .SASV6SEQ$AUDIT
DMDB file .SASEB$DMDB .SASV6SEQ$DMDB

Return to Step 2.