XPT to ORC
Convert SAS Transport File (.xpt) to Optimized Row Columnar (.orc).
Source SAS Transport File: XPT (SAS Transport) is SAS's cross-version, cross-platform transfer format, designed for exchange rather than efficient storage, and still mandated for FDA clinical trial submissions under CDISC. R's haven and Python's pyreadstat read it. Convert to CSV or Parquet to pull the data into modern analysis stacks.
Target Optimized Row Columnar: ORC (Optimized Row Columnar) is the Apache Hive warehouse format with predicate pushdown, lightweight compression, ACID transactions, and vectorized execution - the default table storage for serious Hive deployments. Convert to Parquet to cross into the broader Spark and Presto ecosystem, to CSV or JSON for small-scale inspection, or to Feather for fast Python reads.