I wish SAS would make this an option that the user can edit from within the program. I run SAS on a server and cannot make changes to the invocation options or configuration files. ... View more

I think I got it with this:   %MACRO Setss(Start, Stop); %DO ID_set = &START %TO &STOP; proc univariate data=post_&ID_set; where x lt &&XMin2Y_&ID_set; var x; histogram x; title '&XMin2Y_1'; run; %END; %MEND Setss; %Setss(1,3) ... View more

Hi @GeorgeSAS The code @art297 posted works for me as well. See below: NOTE: >>> GET /talks/quick-list HTTP/1.0 NOTE: >>> Host: www.ted.com:443 NOTE: >>> Accept: */* NOTE: >>> Accept-Language: en NOTE: >>> Accept-Charset: iso-8859-1,*,utf-8 NOTE: >>> User-Agent: SAS/URL NOTE: >>> NOTE: <<< HTTP/1.1 200 OK NOTE: <<< Age: 0 NOTE: <<< Cache-Control: max-age=0, public, s-maxage=30 NOTE: <<< Content-Security-Policy-Report-Only: script-src 'unsafe-inline' 'unsafe-eval' https:; style-src 'unsafe-inline' 'self' https:; default-src 'self' https: data: blob:; report-uri https://error-collector.ted.com/?context=csp-report NOTE: <<< Content-Type: text/html; charset=utf-8 NOTE: <<< Date: Sun, 07 May 2017 00:29:18 GMT NOTE: <<< ETag: W/"bc10c663abfefcaba0aa45f32b8efbe2" NOTE: <<< Server: nginx NOTE: <<< Set-Cookie: _nu=1494116958.827; Expires=Fri, 06 May 2022 00:29:18 GMT; Path=/ NOTE: <<< Set-Cookie: _abby=7OCod3AeLqPqydy; Expires=Fri, 06 May 2022 00:29:18 GMT; Path=/; Domain=.ted.com NOTE: <<< Status: 200 OK NOTE: <<< X-Content-Type-Options: nosniff 2 The SAS System 10:29 Sunday, May 7, 2017 NOTE: <<< X-Served-By: e11; o11 NOTE: <<< X-XSS-Protection: 1; mode=block NOTE: <<< Connection: Close NOTE: <<< NOTE: The infile SOURCE is: Filename=https://www.ted.com/talks/quick-list, Local Host Name=<user name>, Local Host IP addr=<ip address>, Service Hostname Name=www.ted.com, Service IP addr=<ip address>,Service Name=N/A, Service Portno=443,Lrecl=32767,Recfm=Variable NOTE: 1847 records were read from the infile SOURCE. ... View more

I can't test or research right now but you might be able to add something like the following to your compute block. call define(_row_,'style','style={cellheight=.1in}'); This won't solve the problem.  You will need to specify some other attributes perhaps eliminate the margins. ... View more

The %SYSFUNC is a macro function that allows you to execute a DATA step function. The PATHNAME function returns the physical location of a libref.  In the code by @ChrisNZ, the physical location of the WORK directory is inserted into the path for the ODS file=. If you know the path write it directly without the %SYSFUNC. ... View more

yes it is possible. If you would like to see lots of examples with sample code check out Robert Allisons work at http://robslink.com/SAS/#!   PROC REG also has quite a few Proc reg data=sashelp.class; model height=weight; run; plotting capabilities.  there is even a PLOT statement. ... View more

Assuming that your check will be against the observation count in a data set, here is a little macro that i use to return the number of observations in a data set. %macro obscnt(dsn); %local nobs dsnid rc; %let nobs=.; %* Open the data set of interest; %let dsnid = %sysfunc(open(&dsn)); %* If the open was successful get the; %* number of observations and CLOSE &dsn; %if &dsnid %then %do; %let nobs=%sysfunc(attrn(&dsnid,nlobs)); %let rc =%sysfunc(close(&dsnid)); %end; %else %do; %put WARNING: Unable to open &dsn; %put %sysfunc(sysmsg()); %end; %* Return the number of observations; &nobs %mend obscnt; in your program you might use it something like: %if %obscnt(mydata)>25 %then %do; ... View more

The sum function can handle blanks, but not non existing macro variables.  What happens if you insist on the macro variables existing? Declare them locally or globably, as appropriate is one method to do this. That's probably the quickest solution, IMO. ... View more