Convert SAS7BDAT to JSON

Turn SAS7BDAT files into JSON. An array with one object per case keyed by variable name, with numbers written as decimals such as 34.0 and empty values as null.

Converted in an isolated sandbox on our serversDeleted after 24 hours

Drop SAS7BDAT files on the dialor turn it to pick what to do

SAS datasets as plain JSON.Each case becomes one object, keyed by variable name.

  1. What you get

    One JSON file that holds an array. Each case in the SAS dataset is one object in that array, and each variable name is a key.

    Numbers are written as decimals, such as 34.0. Empty values are written as null.

  2. What it leaves behind

    Value labels, variable labels and missing-value definitions are dropped. Coded answers stay numbers, so a column that stores 1 for yes and 2 for no keeps 1 and 2 in the JSON.

    Keep your codebook next to the file if you need to read those codes later.

  3. When it fails

    A file that cannot be parsed stops the conversion with input_corrupted. This means the SAS7BDAT file is damaged or is not readable as a SAS dataset.

    To work with the result, you can merge JSON files after converting.

SAS7BDAT and JSON.What each format is.

The formats

From · SAS7BDAT

SAS Data

SAS datasets.

Extensions
.sas7bdat
MIME type
application/x-sas-data
Kind
Text and data
To · JSON

JSON

JSON, the data format of every API.

Extensions
.json
MIME type
application/json
Kind
Text and data

In your code.The same SAS7BDAT to JSON conversion through the API, for your app or your agent.

terminal
$ cv convert report.sas7bdat report.json
$ cv convert report.sas7bdat report.json

Questions.What people ask about SAS7BDAT to JSON.

01OF 04

It is an array with one object per case. Each object uses the variable names as keys.

Numbers are written as decimals. A whole number such as 34 comes out as 34.0.

No. Value labels, variable labels and missing-value definitions are dropped. Coded answers stay as numbers.

They are written as null.

More conversions.Other ways in and out of SAS7BDAT and JSON.