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
... View more