Thanks Olivia - one thing I mean to do with this Task is amend it to allow the optional use of BY groups so you could push multiple series through it in one run. I haven't had time to get to it yet but hopefully I will at some point! ... View more

Many thanks for this - Custom Task Tuesday is a great series!  ... View more

That's a good point about word order - you could probably do something with capture groups if they could appear in any order. ... View more

Try this   data in; length str $64; input str &; cards; did the subject complete the entire course of study did the subject complete the treatment period did subject complete full study protocol did subject complete hospital visit did subject complete application form ; run; data out; set in; if prxmatch("/\bsubject\b.*\bcomplete\b.*(\bstudy\b|\btreatment\b|\bprotocol\b)/",str) then output; run; The \b characters force the regex to match only on word boundaries and \b.* means their can be multiple words between the matching ones. ... View more

Combining the API call to download the data with an analysis step is a simple but very effective idea. One problem I have with the Custom Task combobox though is the need to hard code all the options. If only we could specify a data source to load the elements from then it would make for a much more effective tool. ... View more

Nice illustration of Proc SQL subqueries.   I think I can explain the strangely high budget figures - the costs in the file you've used are not all in US $ - for example if you check the IMDB site itself the cost of The Host is given in South Korean Won and Princess Mononoke is given in Japanese Yen http://www.imdb.com/title/tt0468492/?ref_=fn_al_tt_2 and http://www.imdb.com/title/tt0119698/?ref_=nv_sr_1 ... View more

Take a look at my paper from SAS Global Forum 2014 where I do essentially what I think you want http://support.sas.com/resources/papers/proceedings14/1598-2014.pdf   Chris ... View more

Jordan   Assuming your date column is numeric with a date format this is straightforward. Below is an example of deleting all rows from a copy of SASHELP.AIR where the year is earlier than 1955. You should simply follow the same method for your problem.   Chris   data air; set sashelp.air; run; proc sql; delete from air where year(date) < 1955; quit; ... View more

Your problem is with the line   if PHIWIN = 1 then winstreak =+1;   What you're doing here is setting the value of winstreak to 1 instead of incrementing it. if you make it   if PHIWIN = 1 then winstreak+1;   I think you'll find you get the correct answer. ... View more

The easiest way to change the year portion of a date is with by using the intnx function intnx function reference   You can use negative values for the increment as well as positive ones. ... View more

Are you trying to call SAS via the VBA shell function or are you using the SAS Integrated Object Model (IOM)? I'd strongly recommend using IOM if you're using the shell function as I suspect the problem you're encountering may be due to startup time for the background SAS session that needs to be opened. ... View more

As Linus suggests EXCEPT is the solution here e.g.   data tablea; infile datalines dlm=","; input imb_code rule_number; datalines; 1,9 2,8 3,7 4,6 5,5 ; run; data tableb; infile datalines dlm=","; input imb_code rule_number; datalines; 1,9 4,6 ; run; proc sql; create table tablec as select * from tablea except select * from tableb ; quit; ... View more