topic Re: Converting Json file to read into SAS in SAS Enterprise Guide

Converting Json file to read into SAS

Sean_OConnor — Tue, 20 Nov 2018 09:59:15 GMT

Folks,

I have a Json file which I need to create a SAS dataset with.

To begin I've used R to separate the Json file into four different datasets and I have exported them out into a .sav file.

I am then reading the .sav file into SAS using the proc import command.

However, after the proc import command is run all the variables are being read in as numeric. For example a variable called.

additionalProp1 has a value called 'string'. In the SAS dataset this is being read as numeric.

Does anyone know why SAS is reading all variables in as numeric? Is it something to do with the structure of the .sav file?

Any information would be great.

Re: Converting Json file to read into SAS

RW9 — Tue, 20 Nov 2018 10:14:30 GMT

What is a .sav file? Something for SPSS? Why not just export to CSV and read that into SAS?

If you JSON file isn't too complicated, you should be able to read it in via datastep - never use proc import for anything other than playing around as it is a guessing procedure -, and you could probably output all four datasets from one datastep. The JSON file is just a plain text file that can be read line by line, so some conditional statements to control which data goes where should be enough.

Personally I would avoid the whole R step and just read the JSON file into SAS directly.

Re: Converting Json file to read into SAS

BillM_SAS — Tue, 20 Nov 2018 14:54:42 GMT

If you have SAS 9.4 maintenance 4 (or better), you have access to the JSON LIBNAME statement for reading JSON data into SAS data sets.