@saitejaguduru97 , if you mean a Data Step instead of a Proc SQL Step, here is one.   data have; input PatId $ Diagnosis $ Date :anydtdte.; format Date date9.; datalines; 1001 RA 1-Jan-22 1001 Diabetes 12-Jan-22 1001 Diabetes 1-Mar-22 1002 IBD 4-Jan-22 1002 Diabetes 14-Jan-22 ; data want(drop = c); set have; by PatId Date groupformat; where Diagnosis = 'Diabetes'; if first.Date then c = 0; c + 1; if last.Date & c >= 2; format date year.; run; ... View more

The hash object is a great tool for a lot of things. But it is not a replacement for Proc Sort and should not be used for a plain sort operation.   If your only goal is to decrease run-time of your sort, there are options you can try to tweak and see if it improves your result.   For example.    Use the Details Option to get a detailed description of I/O operations of your Proc Sort Step.   If the step above has a lot of I/O steps, increase the Sortsize Option.   Perhaps use the Tagsort Option.     For a detailed list of Proc Sort Options, consult the Proc Sort Documentation.        ... View more

This happens because SAS imports Closing_date as a plain number, not a SAS Date.    You can do this to convert to a SAS Date   data have; date = 20081231; newdate = input(put(date, 8.), yymmdd8.); year = year(newdate); format newdate date9.; run; ... View more

Try this   data have; infile datalines dsd dlm=","; input color $; datalines; blue red red blue green red orange red blue violet red orange yellow ; proc format; value $ col "red" = "red" "orange" = "orange" "yellow" = "yellow" "green" = "green" "blue" = "blue" "indigo" = "indigo" "violet" = "violet" ; run; proc summary data = have nway completetypes; class color / preloadfmt order = formated missing; format color $col.; output out = want(drop = _TYPE_ rename = _FREQ_ = count); run; ... View more