It's part of an SQL select and delivers a count of all records where column reg_id is '03' and the date stored in column report_date falls into a range calculated from the macro variable vision_date. How intnx() works is found in the link provided by @Rick_SAS. ... View more

Thank you so much ... now am clear... Am a fresher just started to learn SAS from google. Thanks again for your link.. very helpful. ... View more

Thanks a lot KurtBremser.... Your code was easy to understand and it is very useful for writing pseudo  code. Thanks again. 🙂 ... View more

Thanks Satish... it works now...  ... View more