How did you reslove your issue? I have same problem. ... View more

Using service account/user account, the send_email runs fine when it is executed separately.  But when the send_email is called from another macro, it fails to resolve the macro variables in case of service account. No problems with user account though. ... View more

I have contacted SAS tech support and they have pointed me to this SAS notes. This doesnt help. Please advise. Usage Note 15692: URL filename engine only supports BASIC authentication on web server    When you attempt to read web server data using the URL filename engine, the following error message might appear    ERROR: Unauthorized to retrieve URL and with the DEBUG option    NOTE: <<< HTTP/1.1 401 Unauthorized even when supplying valid credentials with the USER and PASS options. Using the DEBUG option on the filename might show the cause to be the web server's use of an authentication method other than BASIC.  Notice the DEBUG line below:    NOTE: <<< WWW-Authenticate: NTLM The URL engine will not properly authenticate to a web server unless it uses the BASIC authentication protocol. ... View more

Thank you all, that helps! ... View more

proc sort data=have; by accname; run; data want; set have; by accname; retain order 0; if first.accname then order=order+1; run; ... View more