Desktop User Guides > Professional > Data management scripting > Transferring data using a DMS file > Writing data > Transferring data to SAS
Transferring data to SAS
You can transfer data to a SAS data file in the SAS version 7 for Windows, standard-extension format. These types of files have a .sas7bdat extension. The SAS DSC also writes a SAS program (.sas) file immediately after writing the SAS data file. For more information, see SAS DSC.
Writing to a new file
If the SAS data file you specify in the OutputDataSource section does not exist, the SAS DSC will create a new file.
Writing to an existing file
The SAS DSC cannot append data to an existing SAS data (.sas7bdat) file. The transfer fails if a file exists with the same name and location as the SAS data file to be written.
The SAS DSC always overwrites an existing SAS program (.sas) file that has the same name as the SAS program file to be written.
Exporting to a SAS file
In the connection string in the OutputDataSource section, specify mrSasDsc for the Data Source connection property. Then specify the name and location of the SAS data file, which normally has a .sas7bdat extension, for the Location connection property, as shown in the following example.
OutputDataSource(Output, "The output data source")
  ConnectionString = "Provider=mrOleDB.Provider.2; _
    Data Source = mrSasDsc; _
    Location = <Name and location of .sas7bdat file>"
End OutputDataSource
The SAS DSC writes the SAS program (.sas) file to the same location as the SAS data (.sas7bdat) file.
This example OutputDataSource section is taken from the RDBToSAS.dms sample file, which is installed with the UNICOM Intelligence Developer Documentation Library. For more information, see Sample DMS files.
  ConnectionString="Provider=mrOleDB.Provider.2; _
    Data Source=mrSasDsc; _
    Location=C:\Program Files\IBM\SPSS\DataCollection\7\DDL\Output\RDBToSAS.sas7bdat"
End OutputDataSource
Writing data