Thanks a lot Bruno! You made my day! - PG ... View more

Thanks Bruno !! ... View more

In SAS Display Manager you can use the SAS Explorer to list the members in a SAS catalog such as work.sasmacr and if you double click on a member in work.sasmacro it will show the the source code in a window. If you use EG only this is not possible. In fact the SAS server list doesn't even show SAS catalogs. There is an add-in you can get to display the contents of SAS catalogs but not to show the compiled macro source code.  ... View more

There should be a Rank task within EG. I believe it uses PROC RANK, and should probably suit your needs. ... View more

If you just want the data as a character string (as opposed to a numeric date value with a particular display format attached to it) then you can build it easily. select catx('_',year(MIS_DATE),month(MIS_DATE)) as DATA_MONTH or if you need 2013_01 instead of 2013_1 select catx('_',year(MIS_DATE),put(month(MIS_DATE),Z2.)) as DATA_MONTH ... View more

Hello You are no pain my freind The data is merged, but I can easily make an unmerged dataset. Since I am able to do this, I wanted to know if it was possible to use more datasets in en proc report, since it would have solved my problem. So, I have both merged and unmerged data. But the problem is that when I use Proc Report, I want to pick specfik dates. Performance_2010 has the performance for 2010 and I want to pick the performance at the date 31/12/2010. Performance_2011 has the performance for 2011, and i want to pick the date 31/12/2011. To do this I have to writ a "where statement". And it is here that my problem lies. I want to pick the newest date (&reportdate) in the variable performance, and the same time pick the date 31/12/2010 in performance_2010 and 31/12/2011 in performance_2011 and so on. So, the problem is not in the data, but how the "where statement" should be written. I was hoping that it was possible to use more datasets in proc report, and thus making an umerged dataset, and using that. But that is apparently not possible. ... View more

If you want to loop over months then INTNX is useful. %let start=JUN2012 ; %let nmonths=12; %do i=1 %to &nmonths;     %let month=%sysfunc(intnx(month,"01&start"d,&i-1),yymmn6.);     %put i=&i month=&month; %end; i=1 month=201206 i=2 month=201207 i=3 month=201208 i=4 month=201209 i=5 month=201210 i=6 month=201211 i=7 month=201212 i=8 month=201301 i=9 month=201302 i=10 month=201303 i=11 month=201304 i=12 month=201305 ... View more

Thanks Bruno, that solution works for me. When I run it using my original solution compared to this one, the times are roughly the same, which is good.  And the fact that the indexes are maintained is exactly what I was after. Thanks again. ... View more

Thanks Bruno.. It worked perfectly for me .. Just didn't had the time to comeback to the site and acknoldge it.. Thanks so much. Suvi ... View more

Hi Bruno Thank you very much, your code worked nicely and explanation is very helpful. Hi Hai.kuo, Mnay thanks for your link which is very helpful. Regards Mirisage ... View more

I got an email from Administrations stating I have not set a "status update" and they are asking that I do.  What does that mean ?  How do I go about doing it ? ... View more

You can also use INTNX: %let curday=%sysfunc(intnx(day,%sysfunc(date()), -1),date9.); %put NOTE: &=curday; Haikuo ... View more