Have exhausted a day trying to extract data that a FCC API returns as xml. The data pull works correctly but I find it impossible to get the data into SAS. I have tried using XML libref as well as trying to read as text. If I read as text and use formats, it will only return first 8 characters when I use proc print. Any hints would be greatly appreciated. Here is the code: FILENAME ex "f:/prf/Example.xml"; proc http url='https://geo.fcc.gov/api/census/block/find?latitude=35&longitude=-100&format=xml' /* The base URL */ method="GET" /* HTTP method used for request */ out=ex; run; data fips; infile ex; length one $ 212;informat one $212.;format one $212.; input one $; put _infile_; run; proc contents; proc print; run; Which returns The SAS System Obs one1 <Response
... View more