Hi,   I need to know how to code the difference in days between two dates within each group of observations. The constant observation that will be compared to other observations will be the 1st. I will need to code for the first observation and the second observation difference in days, the first observation and third observation in difference in days, the 1st and 3rd, and so on. For instance......   proc sort data=have out=need; by customer descending date; run;   Customer           Date                  DateDiff 1                       2018-08-13 1                       2018-06-24           ? Compared to 1st (ex.54) 1                       2017-08-14           ? Compared to 1st (ex.364) 2                       2017-08-23            2                       2016-04-25           ? Compared to 1st in group2 2                       2016-03-02           ? Compared to 1st in group2 ... View more

Hi Guys!   I'm in a little pickle here. Let me explain....   The overall project is to take information from the variable columns and give then a weight then score. However, there are so many variables to weigh and score that it would be really tedious to do each one individually. I am looking for a macro paired with do loops to process this data in short, efficient code. For example:   proc sort data=have  out=want;  by id year descending doc_num;  run;   data _null_;  set have(where=(year=&curryr. or year=&prevyr. and doc_num=&.)); by id;  if name then a_weight = 'L' and a_score='L';  if first.sale_dt = . and last.sale_dt = . then weight='M' and score='M';   else if first.sale_dt is not . and last.sale_dt = . then weight='M' and score='L';   else if first.sale_dt = . and last.sale_dt is not . then weight = 'M' and score='L';   else if first.sale_dt ^= last.sale_dt then weight='M' and score='M';   else if first.sale_dt = last.sale_dt then weight='M' and score='L'; run;   The other variables and weights will be different than above, but the expressions will stay the same..... For instance: if price is missing on both days then weight ='L' and score='L' and so on.....                         OR                       if product is missing on both days then weight='M' and score='L' and so on....   The final objective is to put the weight and score through a calculation (adding up all of the scores with a corresponding number) to get the total document score.     Suggestions?   ... View more

I am running into a problem with big data inner joining.  I created a hash object but not sure how to use all variables without typing all 200 variable names into the definedata() and call missing(). Should I be using the call missing()? please take a look at my code and give any suggestions....   data ltdmerg (drop=rc); if 0 then set bigdata.file; declare hash hh_pat(dataset:"bigdata.file"); rc=hh_pat.defineKey("id_cd"); rc=hh_pat.defineData(ALL:'Yes'); rc=hh_pat.defineDone(); do until(eof); set work.data end=eof; call missing (?????); rc=hh_pat.find(); if rc=0 then output; end; stop; run; ... View more

 Hi Community!   I am having a difficult time converting Date/Time differences into HH:MM. I want to know how many hours and minutes are between two dates. For instance:   EVENT_CAPTURED_DT_SENT        EVENT_CAPTURED_DT_OPEN 02Feb2018 17:31:15.00                     01Mar2018 3:40:41.00 I need the output to express the difference in time as.....354:15 (example of HH:MM)   I am currently using the HMS function, but only giving me the difference in time and not the difference between date/time. ... View more