Hi.  I'm trying to configure the email options to send email through sendgrid.  It uses and API key.  Below are the options I have set, but I can only get SAS to respond with "ERROR: Login Failure" and "ERROR: Email server did not respond" What do I need to tweak in the settings to get it to connect? options emailsys=SMTP emailhost=("smtp.sendgrid.net" STARTTLS) emailport=25 emailid="YXBpa2V5 <notices@bcservicescommercialcollections.com>" EMAILAUTHPROTOCOL=login EMAILPW='U0cuOHl0RlZVRHJRWXU2QTVSeUczelppUS4xFaRlZ2dXBpd3dZZG5J'; ... View more

Hello.  I pulling data from a cache database.  Upon execution of the query the field I need is being truncated to 80 characters.  I have tried setting the length, informat, and format on the pull but no success.  Code is below.  I would appreciate any suggestions on how to have it read in the full value.  I have tried the pull with other SQL tools and can pull the full value with no setting or options added.     libname k odbc dsn=Kaiser1 schema=SqLUSeR readbuff=10000;   proc sql; create table calls1a as select t1.Name_Of_VTrak_File informat $2000. format $2000. length=2000 as Name_Of_VTrak_Filez from k.call_logging_audit(dbkey=Date_Call_Began) t1 where Date_Call_Began = &start. and Recorded_Voicetrak=1; quit; ... View more