Depending on the SAS version you use, these options can also be set using the OPTIONS statements.   options emailhost="emailhost.a.b.c" emailsys=smtp ; Give it a try. ... View more

Before using Proc IMPORT you should set the SAS System Option VALIDVARNAME=V7 so that non standard characters are translated to an underscore. This way you will have valid names, but be aware that the names might be different to what you have when using VALIDVARNAME=ANY.   SAS Enterprise Guide will set VALIDVARNAME=ANY by default. Check your settings under Tools -> Options -> Data General   But I recommend to add the setting to your code like this: options validvarname=v7 ;     ... View more

As suggested in the error message, use the DEBUG option like so: filename foo url 'http://support.sas.com/techsup/service_intro.html' debug ; This will return the communication between SAS and the web server, this will help you identify the problem. For the URL it looks like this:   NOTE: >>> GET /techsup/service_intro.html HTTP/1.0 NOTE: >>> Host: support.sas.com NOTE: >>> Accept: */* NOTE: >>> Accept-Language: en NOTE: >>> Accept-Charset: iso-8859-1,*,utf-8 NOTE: >>> User-Agent: SAS/URL NOTE: >>> NOTE: <<< HTTP/1.1 301 Moved Permanently NOTE: <<< Date: Tue, 13 Jun 2017 07:36:15 GMT NOTE: <<< Server: Apache NOTE: <<< Location: https://support.sas.com/techsup/service_intro.html NOTE: <<< Content-Length: 258 NOTE: <<< Connection: close NOTE: <<< Content-Type: text/html; charset=iso-8859-1 NOTE: <<< Set-Cookie: BIGipServer~WEB~www.sas.com-pool=1074113941.20480.0000; path=/; Httponly NOTE: <<< NOTE: >>> GET /techsup/service_intro.html HTTP/1.0 NOTE: >>> Host: support.sas.com NOTE: >>> Accept: */* NOTE: >>> Accept-Language: en 2 The SAS System 09:36 Tuesday, June 13, 2017 NOTE: >>> Accept-Charset: iso-8859-1,*,utf-8 NOTE: >>> Cookie: BIGipServer~WEB~www.sas.com-pool=1074113941.20480.0000 NOTE: >>> User-Agent: SAS/URL NOTE: >>> NOTE: <<< HTTP/1.1 404 Not Found NOTE: <<< Date: Tue, 13 Jun 2017 07:36:16 GMT NOTE: <<< Server: Apache NOTE: <<< Expires: Thu, 01 Jan 1970 00:00:00 GMT NOTE: <<< X-Powered-By: Jetty(9.2.9.v20150224) NOTE: <<< Content-Type: text/html; charset=UTF-8 NOTE: <<< Set-Cookie: renderid=rend03; path=/; NOTE: <<< Set-Cookie: JSESSIONID=lqmlrqwb58pdwzzq8yvyei0w;Path=/ NOTE: <<< Connection: close NOTE: <<< ERROR: Invalid reply received from the HTTP server. Use the debug option for more info. ... View more

Check the list of functions, specifically FINDC function   There are also functions for regular expressions, they start with PRX... ... View more

Hi   In the Summary Table wizard page 2, bottom right, this is where you can specify a format like TIME8.   If you need to have different formats depending on the column, you have to use just the Summary Tables. ... View more

As @Kurt_Bremser metioned there is a timing issue.   I recommend this approach, instaed of using CALL EXECUTE, write your macro calls to a file and then after the step generating the calls use the %INCLUDE to run the code, see also code sample below.   %macro someTest(nobs); %put NOTE: running &sysmacroname as %sysfunc(time(), time12.3) &=nobs; proc print data=sashelp.class(obs=&nobs); run; %mend; filename xpgm temp; data _null_; do i = 1 to 2; macroCall = cats('%someTest(', i, ')'); putlog "NOTE: " macroCall=; file xpgm; put macroCall; end; run; %include xpgm / source2; filename xpgm clear; ... View more

Hi   Just use the query builder in SAS Enterprise Guide and add a computed column like below, then you can add other columns and use summarization functions on it.     The expression for the new column would be SUBSTR(yourColumn, start, length) ... View more