topic reading raw data from external file in SAS Programming

reading raw data from external file

CathyVI — Mon, 25 Nov 2019 14:46:22 GMT

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.

Re: reading raw data from external file

Amir — Mon, 25 Nov 2019 14:57:41 GMT

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

Thanks,

Amir.

Re: reading raw data from external file

SuryaKiran — Mon, 25 Nov 2019 15:39:56 GMT

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

Re: reading raw data from external file

andreas_lds — Mon, 25 Nov 2019 15:41:16 GMT

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