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.
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.
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.
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
SAS Data
SAS datasets.
- Extensions
- .sas7bdat
- MIME type
- application
/x -sas -data - Kind
- Text and data
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.
$ cv convert report.sas7bdat report.json$ cv convert report.sas7bdat report.jsonQuestions.What people ask about SAS7BDAT to JSON.
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.