I am attempting to create a SAS PROC HTTP query of the Census geocoding API for batch geocoding.  I have been able to get the test API for a single address, but not the batch file processing example.   * Geocode Single Address; proc http url='https://geocoding.geo.census.gov/geocoder/geographies/address?street=1600+Pennsylvania+Ave&city=Washington&state=DC&benchmark=Public_AR_Current&vintage=Current_Current&layers=10&format=json' in=address out=geocode; run; filename address '//queens.org/FILESHARES/csfs10/CORE01/Core/Geocode/PatientAddresses.csv'; filename geocode '//queens.org/FILESHARES/csfs10/CORE01/Core/Geocode/PatientGeocode.json'; * Batch geocode up to 10,000 addresses in CSV file format; proc http url='https://geocoding.geo.census.gov/geocoder/geographies/addressbatch' in=address out=geocode; run; ... View more

Using PROC ODSTEXT to generate the body of an email, extra spaces are being inserted into the text after 136 or more characters. The code renders correctly in SAS Studio but not in the generated email.  The email has a space embedded in the email address in the text, making it inactive as a link.   ods listing; ods MSOFFICE2k body=outbox style=sasweb; title; footnote; * Enter the body of your email with a 'p' statement within the PROC ODSTEXT procedure block; proc odstext; p 'Aloha,' /style={fontsize=12pt}; p "^{newline}"; p "Here is your updated list of roles that currently contain staff out due to Covid. Please use this data to validate staffing on your unit."/ style={fontsize=12pt}; p "^{newline}"; list /style={fontsize=12pt}; item "If you see incorrect information (i.e. someone is back and the report says they are still out) please email SomeEmailAddress@MyCompany.com"/ style={liststyletype="disc"}; item "This data is also being sent to your directors/VP and if you have a pertinent issue with staffing please reach out to them for assistance."/ style={liststyletype="disc"}; item "If you have an employee on this list that is no longer reporting to you, please disregard. There may be a lag in PeopleSoft for transfers."/ style={liststyletype="disc"}; end; p "^{newline}"; p "Attached report prepared for: &Name" /style={fontsize=12pt}; p "^{newline}"; p "Mahalo," /style={fontsize=12pt}; p "^{newline}"; p "ITIM-Support@queens.org" /style={fontsize=12pt}; * p "www.queens.org" /style={fontsize=12pt}; run; ods listing close; ods _all_ close; ... View more

I am trying to write a PROC HTTP program to validate Zip+4 for mailing addresses using PROC HTTP and the USPS API webtools.  I have a successful HTTP URL that I need to replicate with PROC HTTP.  The program creates an XML library to format the addresses for validation but I am getting an XML syntax error when run the PROC HTTP.  The URL I am trying to reproduce returns an XML response record without error.   http://production.shippingapis.com/ShippingAPI.dll?API=Verify &XML=<AddressValidateRequest USERID="165THEQU4205"><Address ID="0"><Address1></Address1> <Address2>6406 Ivy Lane</Address2><City>Greenbelt</City><State>MD</State> <Zip5></Zip5><Zip4></Zip4></Address></AddressValidateRequest>   test program that returns an XML Error Response Message: <?xml version="1.0" encoding="UTF-8"?> <Error><Number>80040B19</Number><Description>XML Syntax Error: Please check the XML request to see if it can be parsed.</Description><Source>USPSCOM::DoAuth</Source></Error>   SAS code: libname test xml "/sasuser.v94/AddressValidateRequest.xml"; filename in "/sasuser.v94/AddressValidateRequest.xml"; filename out "/sasuser.v94/AddressValidateResponse.xml"; data test.Address; Revision=1; ID=1; Address1=''; Address2='6406 Ivy Lane'; City='Greenbelt'; State='MD'; run; * Pass information to USPS API webtool for processing; proc http url="https://stg-secure.shippingapis.com/ShippingAPI.dll?API=AddressValidateRequest" webusername="165THEQU4205" webpassword="120RW00US168" method="POST" in=in out=out; run; ... View more