Yes, data _null_ has pointed to the right dircection. You need manually acount for the holidays, and set up a dataset for these purpose. 'weekday' can only take care of Mon-Fri, regardless holidays. Regards, Haikuo ... View more

Try the following code, it uses the combination of intck() and intnx(), plus 'weekday' as interval unit: data have; infile cards; input date anydtdte21.; format date date9.; cards; 4-Jan-2010 5-Jan-2010 6-Jan-2010 7-Jan-2010 8-Jan-2010 11-Jan-2010 12-Jan-2010 13-Jan-2010 14-Jan-2010 15-Jan-2010 3-Jan-2011 4-Jan-2011 5-Jan-2011 6-Jan-2011 7-Jan-2011 10-Jan-2011 11-Jan-2011 12-Jan-2011 13-Jan-2011 14-Jan-2011 17-Jan-2011 ; data want; set have; weekdays=intck('weekday', date,intnx('year',date,-1,'sameday')); run; proc print;run; Regards, Haikuo ... View more

Assume they are both sorted, then we can have: data a1; merge a1(in=a) b1(in=b); by date_file; if a then output; if a and b then put "Found=" date_file; else if b and not a then output; run; Regards, Haikuo ... View more

I don't have answer for your specific question, which requires more information on your data set. Generally speaking, you don't need to create a data set variable from another data set variable using macro variable as a middle man. What 's wrong with just using assignment statement (or plus whatever operators needed) to do the job (new=old)?  In theory, you sure can use call symput to first retrieve values into macro variables and then using symget to put the value back into your data set variables, well, for your scenario, doing that is like traveling from DC to NY via north pole. just my 2 cents, Haikuo ... View more

Try this working version of your code, and please note the changes being made: data have; infile cards; input Type $  _freq_  _freq_p; cards; Anc  20        20 PCP    0        30 Spc    5966    5967 ; proc report data=have headline headskip split='*' nowd ;       column type _freq_ _freq_p change;       define change/computed 'CHANGE %' width=20 format=percent8.2 spacing=1; compute change;          if _c2_=0 and _c3_ > 0 then change=1;          else if _c2_=0 and _c3_ < 0 then change=-1;           else if _c2_=0 and _c3_ = 0 then change=0;           else  change=(_c3_ -_c2_)/_c2_; endcomp; run; Regards, Haikuo ... View more

For Q1, SQL plus intnx() mentioned by mojerry will make one of the solutions. data have; infile cards; input ChildID $10.     ACT $     ACTDate :mmddyy8.     AgencySpellBegin : mmddyy10.        AgencySpellEnd : mmddyy10.; format ACTDate     date9.        AgencySpellBegin date9.        AgencySpellEnd date9.; cards; Childid1     M999     11/30/11     9/12/01     12/12/2414 Childid1     M956     11/12/11     9/12/01     12/12/2414 Childid2     M990     7/12/11     7/12/02     2/12/2414 Childid3     M999     1/1/12     6/13/04     2/12/2414 Childid3     M900     11/11/11      6/13/04     2/12/2414 Childid3     M956     10/12/11     6/13/04     2/12/2414 Childid4     M956     1/1/11     8/9/04     1/12/12 Childid5     M450     9/12/11     7/12/05     2/12/2414 Childid6     M956     8/12/11     7/12/03     1/12/11 Childid7     M956     1/12/12     1/12/09     2/12/2414 ; /*Q1 , awols and returns*/ proc sql; create table awol as select distinct childid from have where  act='M956' and actdate>=intnx('month',today(),-7,'sameday') ; create table return as select distinct childid from have where actdate>=intnx('month',today(),-7,'sameday') group by childid having sum(act='M956')>0 and sum(act='M999')>0 ; quit; Please note, if you want to define your month from the first day of every month, you need to remove 'sameday' option from intnx(). Q2 seems to be straighforward question, however, results could vary depend on what you want. Please refer a recent discussion on SAS-L. http://www.listserv.uga.edu/cgi-bin/wa?A2=ind1201B&L=sas-l&P=R13704 Regards, Haikuo ... View more

What is your platform? Are you using SAS?  I am running SAS 9.2 on winxp sp3 32bit. Your code does not work on my machine, and it seems to me it does not have valid syntax. Please try again or provide your full running code. ... View more

Proc SQL actually does provide a native approach for this problem, however, I got lost in your code and I am not sure how it works. it seems to me it would need more work like this: data have; infile cards; input id $ InviteDate :ddmmyy10.; format invitedate date9.; cards; 1 01/01/2010 1 12/01/2010 1 15/05/2010 2 01/01/2010 2 15/05/2010 2 19/06/2010 2 30/07/2010 ; proc sql; create table want as select id, put(invitedate, monyy5.) as my, count(*) as ct from have group by id, calculated my ;quit; proc print;run; Regards, Haikuo ... View more