Parsing JSON data

[ChrisNZ]

Replace

	INFILE	In_Data		LENGTH			=	_JSON_Length
						RECFM			=	V
						END				=	_End_of_Data
						;

	INPUT	@1	_JSON_Data	$VARYING32767.	_JSON_Length;

with

  set TABLENAME;
  _JSON_Data=JDATA;

[NerdAct77]

Your codes are very helpful! Thanks

I have an issue that my JSON is in a data table with in SAS so how can I still use yours?

Also, my json is having this:

" {"Root":{"ClientDetailsArray":[

{"idno":"111111","genderCode":"0","Dob":"1988-08-05},

{"idno":"111111","genderCode":"0","Dob":"1982-03-04"},

{"idno":"1111111","genderCode":"0","Dob":"1982-05-27"}]}} "

I want the results to be this: because it is the same client but these are the dob of his family members:

idno	genderCode	dob1	dob2	dob3
111111	0	05-08-1988	04-03-1982	27-05-1982