SELECT t1.Name, t1.ID, count(t1.description) AS Number FROM WORK.TOTAL t1 where t1.description eq 'PROT' GROUP BY t1.ID ... View more

@89974114 wrote: Hi all,   I've been using a macro library so that I can use macros without compiling them first. The problem is that when I change the macro and save it, then refresh my filename for the macro lib, this is not enough to update and use the new macro?   Anyone have any ideas why it is still using and compiling the old macro before it was saved? When you change a macro and save it, SAS doesn't use the saved copy if you have previously used the macro in that session. It uses the version of the macro before the changes that is still in SAS's memory.   To make sure the changed macro is used, you need to submit the macro via the SAS Editor.   http://documentation.sas.com/?cdcId=pgmmvacdc&cdcVersion=9.4&docsetId=mcrolref&docsetTarget=n1o5fkxq0gqdpcn1xs3ksdks69tf.htm&locale=en   ... View more

http://www.theanalysisfactor.com/wacky-hessian-matrix/ ... View more

You need to use your date variable to determine the flags, but you haven't done that.   For example if the variable that contains the date in data set x is named DATE, then If '25jan2002'd<date<'24feb2003'd then flag=1;   ... View more