My apologies, not sure why the proc sql didn't work for me initially. I thought i was using an incorrect syntax.   Thanks! ... View more

data have; infile datalines dlm=","; input date mmddyy8. CustomerAccount InterestRate; format date ddmmyy10.; datalines; 1/1/2016,1,2 2/1/2016,1,2 3/1/2016,1,3 4/1/2016,1,3 1/1/2016,2,8 2/1/2016,2,8 3/1/2016,2,9 4/1/2016,2,9 ; run; data want; set have; by CustomerAccount; pre_rate=lag(InterestRate); flag=sign(dif(InterestRate)); if first.CustomerAccount then flag=0; if flag=1; run; ... View more

data want; set have; by id state; days=ifn(first.state,0,dif(date)); run; Art, CEO, AnalystFinder.com   ... View more

You can use next code to calculate start date: %LET REPDT = 01Jan017; data _null_; end_dt = input(&repdt,date9.); start_dt = intnx('month',end_dt,-6); call symput('enddt', strip(end_dt)); call symput('startdt', strip(start_dt)); run; proc sql; /* extract data */ create ... as select ... from dataset_name where date between &startdt and &enddt; quit; continu with calculations and reporting. ... View more