Repository files navigation

Read SAS files in JavaScript. Because you always wanted to do that, right?

Ported fromthe sas7bdat Python package. All functionality should be the same, except sas7bdat-js supports fewer compression methods.

npm install sas7bdat

First load the module:

const SAS7BDAT = require('sas7bdat');

SAS7BDAT.createReadStream returns a stream that emits individual rows, one at a time:

const stream = SAS7BDAT.createReadStream('test.sas7bdat');stream.on('data', row => console.log(row));stream.on('end', () => console.log('Done!'));stream.on('error', err => console.log(err));

SAS7BDAT.parse returns a promise that resolves to an array containing all the rows:

SAS7BDAT.parse('test.sas7bdat')    .then(rows => console.log(rows))    .catch(err => console.log(err));

SAS7BDAT.toCsv converts a sas7bdat file to CSV format:

SAS7BDAT.toCsv('test.sas7bdat', 'test.csv', {        sasOptions: {            // See below, same as second argument to other SAS7BDAT functions        }        csvOptions: {            // These are passed to http://csv.adaltas.com/stringify/            quotedEmpty: false,            quotedString: true        }    })    .then(rows => console.log('Done!'))    .catch(err => console.log(err));

Pass anoptions object as the second parameter toSAS7BDAT.createReadStream orSAS7BDAT.parse:

const options = {};const stream = SAS7BDAT.createReadStream('test.sas7bdat', options);

A string equal to'array' (default) or'object' which controls whether rows come back as arrays:

['Col1', 'Col2', 'Col3'][1, 'a', 'whatever'][2, 'b', 'whatever']...

or objects:

{Col1: 1, Col2: 'a', Col3: 'whatever'}{Col1: 2, Col2: 'b', Col3: 'whatever'}...

This lets you customize the output format of date/time variables. For example, the default is:

options.dateFormatter = (d, outputFormat) => {    if (outputFormat === 'date') {        return d.toISOString().slice(0, 10);    }    if (outputFormat === 'time') {        return d.toISOString().slice(11, 23);    }    return d.toISOString();}

The two arguments to the callback function ared (a JavaScript Date object) andoutputFormat (a string containing 'date', 'time', or 'datetime').

By default, the first row emitted contains column names, like:

['Col1', 'Col2', 'Col3'][1, 'a', 'whatever'][2, 'b', 'whatever']...

Whenoptions.skipHeader istrue, the row containing column names will be skipped:

[1, 'a', 'whatever'][2, 'b', 'whatever']...

Ifoptions.rowFormat is'object', thenoptions.skipHeader has no effect.

Date/time/datetime columns are identified by a string attatched to them, like"YYMMDD" means a date column and"DATETIME" means a datetime column. The default identifiers used here are:

• date:['YYMMDD', 'MMDDYY', 'DDMMYY', 'DATE', 'JULIAN', 'MONYY', 'WEEKDATE']
• time:['TIME']
• datetime:['DATETIME']

Some files might have some other strings used to identify these columns, in which case you can useoptions.extraDateFormatStrings,options.extraTimeFormatStrings, andoptions.extraDatetimeFormatStrings as needed. For example:

// Add another date format stringoptions.extraDateFormatStrings = 'whatever';

// Add more than one time format string by using an arrayoptions.extraTimeFormatStrings = ['foo', 'bar'];

A string containing the character encoding of strings in the file, default is'utf8'. Other available options arewhatever is supported by Node.js, currently:

• 'ascii' - for 7-bit ASCII data only. This encoding method is very fast and will strip the high bit if set.
• 'utf8' - Multibyte encoded Unicode characters. Many web pages and other document formats use UTF-8.
• 'utf16le' - 2 or 4 bytes, little-endian encoded Unicode characters. Surrogate pairs (U+10000 to U+10FFFF) are supported.
• 'ucs2' - Alias of'utf16le'.
• 'base64' - Base64 string encoding. When creating a buffer from a string, this encoding will also correctly accept "URL * `Filename Safe Alphabet" as specified inRFC 4648, Section 5.
• 'binary' - A way of encoding the buffer into a one-byte (latin-1) encoded string. The string'latin-1' is not supported. Instead, pass'binary' to use'latin-1' encoding.
• 'hex' - Encode each byte as two hexadecimal characters.

Boolean, defaulttrue. I'm not totally sure what this does, it came along with the port from Python. If it's needed, it'll hopefully produce an error message telling you that.

A string containing one of the following options:

• 'critical' - Log important error messages to the console.
• 'error' - Everything above, plus messages about less important errors.
• 'warning' - Everything above, plus messages about even less important warnings.
• 'info' - Everything above, plus messages about normal behavior.
• 'debug' - Everything above, plus more verbose debugging information.

The default value is'warning' which will usually result in no logged messages. This is meant to by like Python'slogging module.

npm test

• Python:https://bitbucket.org/jaredhobbs/sas7bdat (sas7bdat-js is just a port of this)
• R:https://github.com/BioStatMatt/sas7bdat
• R:https://github.com/hadley/haven