Hi I have asked the forum this question last week, and got a solution that mostly works. the question was:   The solution that works almost  and was posted on here is: The appraoch does in principle resolve my issue however, it delets all REFER_IDs that have no timedifference, meaning,it deletes all the enties where   LST_UPDT_DT  =  REFER_DT  How can I implement a KEEP statement ? Something like keep REFER_ID if   LST_UPDT_DT  =  REFER_DT    has anybody some ideas? Many thanks ... View more

I am looking for a solution to elegantly display age.   Say I have two datetime varoiables: DOB and a variable called School Entry, at which age were the children schooled ? Time_in_Seconds = (School Entry - DOB) - what is the best way to convert this into age including years, months and days?   Often it is just displayed in years, but I would want a more exact approach, therefore something like : Tane is 12 years, 5 months and 4 days old.   I could create someting over multiple colums, whereby age_min  =ROUND ((age_sec)/60); age_h    =ROUND  ((age_sec)/3600); age_d     =ROUND ((age_sec)/86400); age_y   =ROUND ((age_sec)/31536000);   but that is not very elegant. Would anybody know a better way to deal with this? many thanks ... View more

Hi   I have various proceedures where I need to work out the time or the age difference between two datetime variables.   In principle I principle I thought that I could just deduct datetime2 from datetime1, as this would give me the time difference in seconds.       Data one; Set two; REFER_VAR= (REFER_DT - LST_UPDT_DT ); RUN; Seems not to  work as results are faulty as can be seen on the screenshot below.   In this example below I want the difference between REFER_DT  and  LST_UPDT_DT resulting in REFER_VAR.   Eventually I want to keep only the smallest value of each  REFER_VAR for each REFER_ID. I think I can do the last part with a proc means function (but any advice is appreaciated): proc means data= a  NOPRINT ; class REFER_ID; var REFER_VAR;output out=b min=min max=max; run;   However, I am  failling with the datetime values. Can somenody please help how to set them up between to datetime variables? There are plenty of examples in the net with single dates, but I am having trouble to incorporate my datetime variables:  REFER_DT  and  LST_UPDT_DT   What do I need to do in order to get the right timedifferences given that different months have different mount of days? Many thanks ... View more

Hi   I have a dataset with many identical IDs, which were taken up at different times (datetime 18).  I want to know the earlierst and the last time that an ID was taken up ( and calculate the timeinterval).   So some REFER_ID appeas on multiple different times (LAT_UPDT_DT) as indicted below in red.  The aim is to calculate the timedifference between the fist time and the last time they appear.      What I have:      proc sort data = main_vic; by REFER_ID ; run; proc sql; create table want as select min(LST_UPDT_DT) as min_date format=datetime18., max(LST_UPDT_DT) as max_date format=datetime18. from main_vic; quit; This of course gives me only the first and the last date of all REFER_ID How can I group REFER_ID so  that I always receive the first and last visit of that REFER_ID?   I tried to add a by statement, but was not sucessful.  Any ideas are highly appreaciated.      ... View more