A business partner requires a pipe-delimited (|) record format where missing values are represented as a zero length field or two consecutive pipe characters (||).  We have tried formats, compress() function, and system option MISSING='' to force length zero for missing values in a PUT statement but the record always returns a single blank space between two pipe characters (| |).  Is there a way to remove the single blank space for output without having to remove blank spaces after the file is created with a utility program (e.g. PowerShell)?  We are trying to automate this process if possible. ... 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

I am developing a gauge report that needs to include the actual value as well as the formatted category value of the measure.  I would like to have the actual value presented in the label below the measure label and the formatted value below the gauge.  I have tried to embed  ^[newline] escape characters in the label option, but that doesn't seem to work.   code: ods escapechar="^"; proc gkpi mode=basic; speedometer actual=&ComCases. bounds=(0 1 5 15 25 35) / type=half colors=(cx0000ff cx008000 cxFFFF00 cxFFA500 cxFF0000) lfont=(f="Albany AMT" height=1cm) label="COVID in the Community ^{newline 2} &ComCases." name="community" format="ComLev." afont=(height=.5cm); run; ... View more

Out IT department is evaluating Enterprise Schedulers. The short list of vendors that I have been asked to evaluate is: Tidal; JAMS; and Stonebranch.  We are in the process of implementing a SAS Office Analytics Server on Windows 64 bit server so I have no way to test the scheduler integration.  Does anyone have any experience with these enterprise schedulers? and if so, what has been your experience?  I noticed from an Internet search that JAMS has a SAS adapter option, but SAS is not specifically addressed in the other vendors online documentation.   Any recommendations would be appreciated. ... View more