good eye ... View more

There's no perfect 1:1 mapping, look into https://communities.sas.com/t5/SAS-Programming/Removing-non-Unicode-characters-from-a-variable/m-p/343298/highlight/true#M78806   You can try making translate rules like the following: data have; infile datalines dsd; input char $; datalines; FÉB FÉBR ASà ASÍA Ljusröd Mörkröd abc def bd-fa ; run; data want; set have; new_char=translate(upcase(char), 'A', 'Ã'); run; ... View more

I could be guessing, but here's a way to re-sort in the way of your original post: data have; input id match_1 match_2 case; datalines; 1 . 100000022 0 2 1000024 100000022 1 3 1000024 . 0 4 . 100000011 0 5 100000027 100000011 1 6 100000027 . 0 ; run; data have2; set have; new_id=max((match_1 eq .)*(id+2), (match_1 ne .)*(id-1)); run; proc sort data=have2; by new_id; run; data want; set have2; id=new_id; if case then matchvar+1; drop new_id; run; ... View more

This logic works as expected (see data new step): data old; input (var1-var3) ($) @@; datalines; T T T T T F T F F T F T F T T F T F F F T F F F ; run; data expected; input (var1-var3) ($) newvar :$4. @@; datalines; T T T cat1 T T F cat3 T F F cat2 T F T cat? F T T cat? F T F cat? F F T cat? F F F cat4 ; run; data new; set old; if var1='T' and var2='T' and var3='T' then newvar='cat1'; else if var1='T' and var2='F' and var3='F' then newvar='cat2'; else if var1='T' and var2='T' and var3='F' then newvar='cat3'; else if var1='F' and var2='F' and var3='F' then newvar='cat4'; else newvar='cat?'; run; proc print data=old; proc print data=expected; proc print data=new; run; proc compare base=expected compare=new; run; ... View more

I think you're looking for the unique entries by time period. nodupkey as it's used below will give you the desired output. data have; input time_period :date9. member $ group $ money_issued; format time_period date9.; datalines; 01OCT2017 XX-1 XX 0 01JAN2018 XX-1 XX 7320 01APR2018 XX-1 XX 30240 01JUL2018 XX-1 XX 40600 01OCT2018 XX-1 XX 45360 01JAN2019 XX-1 XX 29302 01APR2019 XX-1 XX 0 01OCT2017 XX-2 XX 0 01JAN2018 XX-2 XX 7320 01APR2018 XX-2 XX 30240 ; run; data desired_output; input time_period :date9. group $ money_issued; format time_period date9.; datalines; 01OCT2017 XX 0 01JAN2018 XX 7320 01APR2018 XX 30240 01JUL2018 XX 40600 01OCT2018 XX 45360 01JAN2019 XX 29302 01APR2019 XX 0 ; run; proc sort data=have(drop=member) nodupkey out=want; by time_period; run; proc compare base=desired_output compare=want; run; ... View more