Alternatively you can use the format to order   proc freq data=four order=formatted; table lre_placement / nocum; format lre_placement xformat.; run; ... View more

Please try the below code   proc freq data=four order=internal; table lre_placement / nocum; run; ... View more

Please try the below untested code   proc sort data=tableA; by key_id; run; proc sort data=tableB; by key_id; run; data all; merge tableA(in=a) tableB(in=b); by key_id; if b and not a; run; ... View more

Please try the below code   data have; input year firm_id city_id operate action; cards; 2008 28013 1003 1 1 2008 28013 1004 1 1 2008 28013 1007 1 0 2008 28013 1009 1 1 2008 28013 1010 0 1 2008 28013 1013 1 0 2008 28013 1053 1 1 2008 28013 1074 1 0 2008 28013 1075 1 1 ; run; data list; input city_id city_id_adj use; cards; 1003 1009 1 1003 1010 1 1003 1085 1 1004 1007 0 1004 1009 0 1004 1099 0 1004 1100 0 1007 1004 0 1007 1823 1 1009 1003 1 1009 1004 0 1009 1010 0 1010 1003 1 1010 1009 0 1013 1053 1 1013 1074 1 1053 1013 1 1074 1013 1 1075 1743 1 1075 1744 1 ; run; proc sort data=have; by city_id; run; proc sort data=list; by city_id; run; proc sort data=have out=operate; by city_id; where operate=0; run; proc sort data=have out=action; by city_id; where action=1; run; data want; merge have(in=a) list(in=b) ; by city_id; if a and b; if operate=0 then action_adj=3; run; proc sort data=want; by city_id_adj; run; data want2; merge want(in=a) operate(in=v keep=city_id operate rename=(city_id=city_id_adj operate=operate2)) action(keep=city_id action rename=(city_id=city_id_adj action=action2)); by city_id_adj; if a ; if use=1 and operate=1 and operate2=0 then action_adj=2; if use=1 and action2=1 and operate2^=0 then action_adj=1; if action_adj=. then action_adj=0; run; proc sort data=want2; by city_id action_adj; run; data want3; set want2; by city_id action_adj; if last.city_id; run; ... View more

Please try the below code, a dynamic approach   data have; input ID May June July August September October Month$ _31_May_19 _30_Jun_19 _31_Jul_19 _31_Aug_19 _30_Sep_19 _31_Oct_19; cards; 12345 3 2 2 2 2 2 May 0.57 0.63 0.89 2.32 1.63 0.4 12346 2 2 1 1 1 1 May 0.99 0.42 0.9 0.02 0.93 0.25 12347 1 1 1 1 1 1 xxx 0.64 0.93 0.95 0.21 0.75 0.52 12348 3 3 3 1 2 2 May 0.97 0.41 0.28 0.23 0.74 0.1 12349 1 2 2 2 3 2 September 0.83 0.23 0.76 0.56 0.97 0.43 12350 1 2 2 2 2 2 xxx 0.03 0.81 0.65 0.52 0.86 0.25 12351 2 2 2 1 1 1 May 0.73 0.29 0.18 0.60 0.35 0.58 12352 3 3 3 2 2 2 May 0.99 0.43 0.72 0.13 0.37 0.84 12353 3 2 2 2 2 2 May 0.67 0.20 0.36 0.11 0.86 0.51 12354 2 3 3 3 3 3 xxx 0.70 0.84 0.76 0.19 0.46 0.89 ; data want; set have; array dates(*) _31_May_19 _30_Jun_19 _31_Jul_19 _31_Aug_19 _30_Sep_19 _31_Oct_19; do i = 1 to dim(dates); if lowcase(substr(month,1,3))=lowcase(compress(vname(dates(i)),,'ka')) then cost=dates(i); actual=cost-dates(i); end; run;   ... View more

Please try the below code   data have; input DATE Account Payment; cards; 08312019 111 100 09302019 111 50 08312019 222 150 09302019 222 150 08312019 333 150 09302019 333 200 08312019 444 300 09302019 444 150 08312019 555 75 09302019 555 75 08312019 666 20 09302019 666 20 08312019 777 300 09302019 777 100 08312019 888 50 09302019 888 75 08312019 999 200 09302019 999 150 08312019 000 75 09302019 000 75 ; proc sort data=have; by account payment date; run; data want; set have; by account payment date; if last.payment; run; ... View more

you can do it proc sql as well like below   proc sql, create table want as select category,subcategory, case when productname='' then catx(' ',category,subcategory), else productname end as productname from have; quit; ... View more

you can try something like below   data have; input ID$ Vist$ Start_Date$10.; cards; B1110001 Baseline 4/18/2016 B1110001 Visit 4/19/2016 B1110003 Baseline 4/18/2016 B1110003 Visit1 4/20/2016 B1110004 Baseline 4/18/2016 B1110004 VISIT1 4/19/2016 B1110004 VISIT2 4/21/2016 ; data want; length start end $10.; set have; retain start; by id; if first.id then start=Start_Date; if last.id then end=Start_Date; if last.id; drop Start_Date; run; ... View more