reading raw data from external file

[CathyVI]

 Hi,

I am working on a medical code (RxNorm) data and I am trying to read a specific data into sas with no way through. I have created  a fictitious data which is a very similar to the real data.

Sample raw data

{"userInput":{"relaSource":"MEDRT","relas":"may_treat","rxcui":"128793"},"rxclassDrugInfoList":{"rxclassDrugInfo":[{"minConcept":{"rxcui":"142439","name":"Hydrocodone Bitartrate","tty":"PIN"},

"rxclassMinConceptItem"{"classId":"D003371","className":"Cough","classType":"DISEASE"},"rela":"may_treat","relaSource":"MEDRT"},{"minConcept":{"rxcui":"142439","name":"Hydrocodone Bitartrate","tty":"PIN"},

"rxclassMinConceptItem":{"classId":"D008173","className":"Lung Diseases, Obstructive","classType":"DISEASE"},"rela":"may_treat","relaSource":"MEDRT"},{"minConcept":{"rxcui":"142439","name":"Hydrocodone Bitartrate","tty":"PIN"},

Thanks.

[Amir]

Please show what you would like the output data to look like and what data type and length each column should have.

Thanks,

Amir.

[SuryaKiran]

Hello,

Is this an xml file? Does it have a specific pattern? Try using _infile_ to read this kind of unstructured data. Please provide more information on how your data pattern aligns & how you need the output. 

Thanks,

Kiran

[andreas_lds]

Looks like a json-file, have your tried reading it by using libname jlib json "path-to-file"?