FOCUS AREAS
Step 2
|
Migration
Execution: 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.
| Member | Base 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 |
| Member | Base 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.
| Member | Base 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.
| 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 |
| Member | Base 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 |
| Member | Base 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.