thehyve/sas-convert

Simple SAS7BDAT to CSV conversion tool based on the Parso library.

sas-convert

Simple SAS7BDAT to CSV conversion tool based on the Parso library and opencsv.

Download

The latest version can be downloaded here: sas-convert-0.6.zip.

# Download sas-convert
curl -L https://github.com/thehyve/sas-convert/releases/download/0.6/sas-convert-0.6.zip -o sas-convert-0.6.zip
unzip sas-convert-0.6.zip

Usage

Usage:

./sas-convert/sas-convert <file.sas7bdat> [file.csv]

By default, the first three lines of output will describe the columns: labels, names, and formats, respecitively. To only output one line of header information containing just column names, use the --only-column-names or -o option:

./sas-convert/sas-convert -o <file.sas7bdat> [file.csv]

By default, if you don't pass the second argument, the output is sent to stdout. If instead you'd like to save it to an automatically named file based on the name of the input file, the --auto-create-csv or -a option will save this output to my-filename.csv:

./sas-convert/sas-convert -a my-filename.sas7bdat

Build and run from source

mvn package
./sas-convert <file.sas7bdat> [file.csv]

License

Copyright © 2015–2018   The Hyve.

sas-convert is licensed under the MIT License. See the file LICENSE.

sas-convert's Issues

Cant run the app

I am using cygwin64 to run the app.
after executing the following CLI getting the error. the file is on the same directory as the sas-convert.
$ ./sas-convert -a skinproduct_vfdemo.sas7bdat
./sas-convert: line 20: C:\Program: command not found

Facing count difference in read and write

I'm getting count difference from the source to target CSV. Please check below details:

./sas-convert/sas-convert xpnt_ptrk_dtl_wk_cho.sas7bdat xpnt_ptrk_dtl_wk_cho.csv
2017-04-11 23:58:03,321 [INFO] Reading file XPNT_PTRK_DTL_WK_CHO
2017-04-11 23:58:03,324 [INFO] 410452665 rows.
2017-04-11 23:58:03,324 [INFO] Writing data...
2017-04-12 00:42:02,643 [INFO] Done writing data.
2017-04-12 00:42:02,643 [INFO] 356176390 rows written.
2017-04-12 00:42:02,644 [INFO] Converting took 2639 seconds.

It read 410452665 rows from the header information and Writed 356176390 records to CSV. Please help me to identify the issue or suggest is this fine.