Hi there I was wondering if someone could help me, I have been using SAS for a good few years but are coming out of my comfort zone on this one. I want to process data from a JSON file that I get from a API call using a filename statement as per the example below. It seems to work until I try and read in the "comment" field, which I have commented out below. Basically this field only exists for some records which I think is causing the problem as when uncommented, it appears that only records where this is populated come through. I dont have proc dc2 and I have dabbled with groovey but I dont think I have the extra jar packages and if possible would prefer to go though this approach as, to my shame, have little knowledge of Javascipt. My code example below filename api url "https://api.mydata.com/api/responses.json"
DATA example;
INFILE api LRECL = 1000000 SCANOVER encoding="utf-8" truncover dsd dlm="}},{";
INPUT
@'"id":' Response_ID : best32.
@'"time":' Date: $23.
@'"ip_address":' ip_address: $16.
@'"identity":' identity: $32.
@'"page":' page: $150.
@'"user_agent":' user_agent: $150.
@'"answer":' Main: $100.
/* @'"comment":' comment: $100.*/
@'"SessionID":' session_id: best32.
@'"Language":' Language: $5.
@'"Locale":' Locale: $2.
@'"Channel":' Channel: $20.
@@;
run; Example of the data I am reading in {
"id": 89702492,
"time": "2016-10-06 14:26:25 UTC",
"anon_visitor_id": "xxxxxxxxxxxxxxxxxxxxxx",
"ip_address": "111.111.111.111",
"identity": "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
"page": "https://secure.hello.com",
"referrer": null,
"user_agent": "Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit",
"nudge_id": 111111,
"nudge_name": "ATTRIBUTION - Hello",
"answered_questions":
{
312102:
{
"question_id": 312102,
"question_title": "what is the time ",
"question_type": "radio",
"answer": "Other please say",
"selected_option_id": 890309,
"comment": "I dont know"
}
}
,
"properties":
{
"SessionID": "4444444444",
"Language": "fr",
"Locale": "Be",
"Channel": "Affiliate"
}
}
, Thanks so much for your help Higgy
... View more