Wait a minute I may have caught on.    Right click ob job --> Stored Process --> New (9.3)...   If that is grayed out your job may simply still be open. Another reason could be that you are connected to a server that is capable of executing stored processes. If that is the case you should talk to your administrator(s).   But the purpose of the menu choice is to deploy that job as a stored process. Not to insert a STP into a job. The generated source code of the job will become the source code of the stp.    Hope this helps, - Jan. ... View more

Distinct counts can be easily obtained with SQL. You could code a CREATE TABLE and use that table in PROC REPORT for presentation purposes.   data h; input farm $ year bulls $; cards; A 2012 x A 2012 p A 2013 y B 2013 x B 2014 k B 2015 n ; proc sql; select farm, year, count(distinct bulls) as nbr_bulls from h group by farm, year; quit; ... View more

How about this then: proc sort data=have; by id b; run; data want; set have; by id b; c = 0; if not first.b and b=5 then c=1; run; - Jan     ... View more

Easiest way out would be to add   where N between 100 and 300; Hope this helps, - Jan.     ... View more