sas7bdat_converter 0.3.6

Convert sas7bdat files into other formats

sas7bdat_converter: Convert sas7bdat files into other formats

Converts proprietary sas7bdat files from SAS into formats such as csv and XML useable by other programs. Currently supported conversiaions are csv, Excel (xlsx format), json, Pandas DataFrame, and XML.

Conversions can be done on either a single file, an entire directory, or a batch of specified files.

Note:

Version 0.3.0 added breaking changes from previous versions. The api has been changed from a class based aproach to a function based approach allowing the import of only what is needed. If you are using the previous class based approach and don't want to update your code stick with a version prior to 0.3.0.

Install

pip install sas7bdat_converter

Usage

• batch_to_csv(file_dicts) - Convert multiple sas7bdat files into csv files at once.

  • file_dicts = A list containing a dictionary for each file to convert. The dictionary is required to contain 'sas7bdat_file' containing the path and name for the sas7bdat file, and 'export_file' containing the path and name for the csv files. The csv file extension should be .csv.

  Example

  from sas7bdat_converter.converter import batch_to_csv
  
  file_dicts = [{'sas7bdat_file': '/path/to/sas7bdat/files/example_1.sas7bdat', 'export_file': '/path/to/new/files/example_1.csv'},
                {'sas7bdat_file': '/path/to/sas7bdat/files/example_2.sas7bdat', 'export_file': '/path/to/new/files/example_2.csv'},]
  batch_to_csv(file_dicts)
  

  Note: Example uses Mac/Linux type file paths. For Windows use paths like c:\path\to\sas7bdat\files\example_1.sas7bdat.

• batch_to_excel(file_dicts) - Convert multiple sas7bdat files into Excel files at once.

  • file_dicts = A list containing a dictionary for each file to convert. The dictionary is required to contain 'sas7bdat_file' containing the path and name for the sas7bdat file, and 'export_file' containing the path and name for the excel files. The Excel file extension should be .xlsx.

  Example

  from sas7bdat_converter.converter import batch_to_excel
  
  file_dicts = [{'sas7bdat_file': '/path/to/sas7bdat/files/example_1.sas7bdat', 'export_file': '/path/to/new/files/example_1.xlsx'},
                {'sas7bdat_file': '/path/to/sas7bdat/files/example_2.sas7bdat', 'export_file': '/path/to/new/files/example_2.xlsx'},]
  batch_to_excel(file_dicts)
  

  Note: Example uses Mac/Linux type file paths. For Windows use paths like c:\path\to\sas7bdat\files\example_1.sas7bdat.

• batch_to_json(file_dicts) - Convert multiple sas7bdat files into json files at once.

  • file_dicts = A list containing a dictionary for each file to convert. The dictionary is required to contain 'sas7bdat_file' containing the path and name for the sas7bdat file, and 'export_file' containing the path and name for the json files. The json file extension should be .json.

  Example

  from sas7bdat_converter.converter import batch_to_json
  
  file_dicts = [{'sas7bdat_file': '/path/to/sas7bdat/files/example_1.sas7bdat', 'export_file': '/path/to/new/files/example_1.json'
                {'sas7bdat_file': '/path/to/sas7bdat/files/example_2.sas7bdat', 'export_file': '/path/to/new/files/example_2.json']
  batch_to_json(file_dicts)
  

  Note: Example uses Mac/Linux type file paths. For Windows use paths like c:\path\to\sas7bdat\files\example_1.sas7bdat.

• batch_to_xml(file_dicts) - Convert multiple sas7bdat files into XML files at once.

  • file_dicts = A list containing a dictionary for each file to convert. The dictionary is required to contain 'sas7bdat_file' containing the path and name for the sas7bdat file, and 'export_file' containing the path and name for the xml files. The XML file extension should be .xml.

  Example

  from sas7bdat_converter.converter import batch_to_xml
  
  file_dicts = [{'sas7bdat_file': '/path/to/sas7bdat/files/example_1.sas7bdat', 'export_file': '/path/to/new/files/example_1.xml'},
                {'sas7bdat_file': '/path/to/sas7bdat/files/example_2.sas7bdat', 'export_file': '/path/to/new/files/example_2.xml'},]
  batch_to_xml(file_dicts)
  

  Note: Example uses Mac/Linux type file paths. For Windows use paths like c:\path\to\sas7bdat\files\example_1.sas7bdat.

• dir_to_csv(dir_path, export_path=None) - Convert all sas7bdat files in a directory into csv files at once.

  • dir_path = The dictionary that contains the sas7bdat file to convert.
  • export_path = Optional path for the converted files. If no path is supplied the new files will be put into the dir_path directory with the sas7bdat files.

  Example

  from sas7bdat_converter.converter import dir_to_csv
  
  # Option 1: put the converted files in the same directory as the sas7bdat files
  dir_to_csv('/path/to/sas7bdat/files')
  
  # Option 2: put the converted fiels in a diffferent directory
  dir_to_csv('/path/to/sas7bdat/files', 'path/for/new/files')
  

  Note: Example uses Mac/Linux type file paths. For Windows use paths like c:\path\to\sas7bdat\files.

• dir_to_excel(dir_path, export_path=None) - Convert all sas7bdat files in a directory into Excel files at once.

  • dir_path = The dictionary that contains the sas7bdat file to convert.
  • export_path = Optional path for the converted files. If no path is supplied the new files will be put into the dir_path directory with the sas7bdat files.

  Example

  from sas7bdat_converter.converter import dir_to_excel
  
  # Option 1: put the converted files in the same directory as the sas7bdat files
  dir_to_excel('/path/to/sas7bdat/files')
  
  # Option 2: put the converted fiels in a diffferent directory
  dir_to_excel('/path/to/sas7bdat/files', 'path/for/new/files')
  

  Note: Example uses Mac/Linux type file paths. For Windows use paths like c:\path\to\sas7bdat\files.

• dir_to_json(dir_path, export_path=None) - Convert all sas7bdat files in a directory into json files at once.

  • dir_path = The dictionary that contains the sas7bdat file to convert.
  • export_path = Optional path for the converted files. If no path is supplied the new files will be put into the dir_path directory with the sas7bdat files.

  Example

  from sas7bdat_converter.converter import dir_to_json
  
  # Option 1: put the converted files in the same directory as the sas7bdat files
  dir_to_json('/path/to/sas7bdat/files')
  
  # Option 2: put the converted fiels in a diffferent directory
  dir_to_json('/path/to/sas7bdat/files', 'path/for/new/files')
  

  Note: Example uses Mac/Linux type file paths. For Windows use paths like c:\path\to\sas7bdat\files.

• dir_to_xml(dir_path, export_path=None) - Convert all sas7bdat files in a directory into XML files at once.

  • dir_path = The dictionary that contains the sas7bdat file to convert.
  • export_path = Optional path for the converted files. If no path is supplied the new files will be put into the dir_path directory with the sas7bdat files.

  Example

  from sas7bdat_converter.converter import dir_to_xml
  
  # Option 1: put the converted files in the same directory as the sas7bdat files
  dir_to_xml('/path/to/sas7bdat/files')
  
  # Option 2: put the converted fiels in a diffferent directory
  dir_to_xml('/path/to/sas7bdat/files', 'path/for/new/files')
  

  Note: Example uses Mac/Linux type file paths. For Windows use paths like c:\path\to\sas7bdat\files.

• to_csv(sas7bdat_file, export_file) - convert a sas7bdat file into a csv file.

  • sas7bdat_file = the path and name for sas7bdat file to convert.
  • export_file = the path and name for the csv file. The csv file extension should be .csv.

  Example

  from sas7bdat_converter.converter import to_csv
  
  to_csv('/path/to/sas7bdat/file/example.sas7bdat', 'path/to/new/file/example.csv')
  

  Note: Example uses Mac/Linux type file paths. For Windows use paths like c:\path\to\sas7bdat\files\example.sas7bdat.

• to_dataframe(sas7bdat_file) - Convert a sas7bdat file into a Pandas DataFrame.

  • sas7bdat_file = The path and name for sas7bdat file to convert.

  Example

  from sas7bdat_converter.converter import to_dataframe
  
  to_dataframe('/path/to/sas7bdat/file/example.sas7bdat')
  

  Note: Example uses Mac/Linux type file paths. For Windows use paths like c:\path\to\sas7bdat\files\example_1.sas7bdat.

• to_excel(sas7bdat_file, export_file) - convert a sas7bdat file into a Excel file.

  • sas7bdat_file = the path and name for sas7bdat file to convert.
  • export_file = the path and name for the Excel file. The Excel file extension should be .xlsx.

  Example

  from sas7bdat_converter.converter import to_excel
  
  to_excel('/path/to/sas7bdat/file/example.sas7bdat', 'path/to/new/file/example.xlsx')
  

  Note: Example uses Mac/Linux type file paths. For Windows use paths like c:\path\to\sas7bdat\files\example.sas7bdat.

• to_json(sas7bdat_file, export_file) - convert a sas7bdat file into a json file.

  • sas7bdat_file = the path and name for sas7bdat file to convert.
  • export_file = the path and name for the json file. the json file extension should be .json.

  Example

  from sas7bdat_converter.converter import to_json
  
  to_json('/path/to/sas7bdat/file/example.sas7bdat', 'path/to/new/file/example.json')
  

  Note: Example uses Mac/Linux type file paths. For Windows use paths like c:\path\to\sas7bdat\files\example.sas7bdat.

• to_xml(sas7bdat_file, export_file, root_node='root', first_node='item') - convert a sas7bdat file into a XML file.

  • sas7bdat_file = the path and name for sas7bdat file to convert.
  • export_file = the path and name for the XML file. The XML file extension should be .xlm.
  • root_node = The name to uses for the top level node. If no name is supplied "root" will be used.
  • first_node = The name to use for the first node under root. If no name is supplied "item" will be used.

  Example

  from sas7bdat_converter.converter import to_xml
  
  to_xml('/path/to/sas7bdat/file/example.sas7bdat', 'path/to/new/file/example.xml')
  

  Note: Example uses Mac/Linux type file paths. For Windows use paths like c:\path\to\sas7bdat\files\example.sas7bdat.