I took simplied version of your sample and tried to solve the problem. Hope this helps data aaa; input id c $ b; datalines; 1 vv 100 1 kk 90 2 cc 229 2 dd 100 ; proc sql; select a.*, case when a.id=c.id and a.b= c.b then 'y' else 'n' end as long_flag from (select * from aaa) a left join (select id, max(b) as b from aaa group by id)c on a.id =c.id and a.b =c.b; quit; ... View more

By using case statements but we careful in case statement if below query has missed any scenario. But you get idea by seeing this query.   proc sql; create table want as select date1, date2, date3, case when date1=date2 and date1 =date3 then date1 when date1 =date2 and date1<>date3 then date1 when date1 =date3 and date1 <>date2 then date1 when date2= date3 and date1<>date3 then date2 when date1<>date2 and date2<>date3 then . end as date_adj format=date9., case when date1=date2 and date1 =date3 then 1 when date1 =date2 and date1<>date3 then 2 when date1 =date3 and date1 <>date2 then 2 when date2= date3 and date1<>date3 then 2 when date1<>date2 and date2<>date3 then 2 end as date_count from have ; quit;         ... View more

Modified data just to keep one min and max. I think this should work.   data have ; input id $ sp_num $ type $ date_1 yymmdd8.; format date_1 date9. ; datalines; 101 a01 p 20160102 101 a01 b 20160103 101 a01 b 20160105 102 b02 b 20160104 102 b02 b 20160105 103 c03 p 20160106 103 c03 b 20160107 103 c03 p 20160108 104 d04 p 20160102 104 d04 b 20160104 ; run; /*picking up min and max records*/ proc sql; create table inter as select *, monotonic() as rnum from want a where date_1=(select max(date_1) as max_d from want b where a.id =b.id group by id) or date_1=(select min(date_1) as max_d from want b where a.id =b.id group by id) order by id, date_1; quit; /* picking up the rows which have change in type you can extent it to others if you want*/ proc sql; create table want as select id, sp_num, type, date_1 from inter a inner join inter b on a.id = b.id and a.type <> b.type where (a.rnum+1 =b.rnum or b.rnum +1 =a.rnum); quit; ... View more

what happend when you similar min dates for more than one observation for an id. what happend when you similar max dates for more than one observation for an id.   ... View more

did you try this, it worked for me   proc sql; create table want as select year, returns, exp(sum(log(returns))) as newcol from have group by year; quit; ... View more

if possible, can you show how your output should be ... View more

try this . Please be careful with format of your new col   proc sql; create table want as select year, returns, exp(sum(log(returns))) as newcol from have group by year; quit; ... View more

you are right @PaigeMiller. I did not read the question properly. ... View more

something like this   proc sql; create table want as select id, date, returns, Delisting_return, month, year, sum(returns) as totalperyear from have group by year; quit; ... View more

I did exactly same thing and it worked for me. below is the code   %let macroValue = 3; %macro test(); %global macroValue1; proc sql print; select name into :macroValue separated by ' ' from dictionary.columns where upcase(libname) = 'SASHELP' and upcase(memname) ='CARS'; quit; %mend test; %test %put &macrovalue;   output i get is  Make Model Type Origin DriveTrain MSRP Invoice EngineSize Cylinders Horsepower MPG_City MPG_Highway Weight Wheelbase   I am not sure whether below mentioned is working or not memname contains 'TEST';        ... View more