Hi, I want to calculate number of event days without overlapping count of days. Example set of data : Event Start End Mall1 1-May 5-May Mall1 3-May 7-May Mall1 11-May 14-May : From this set of data, then for Mall1 count of days is : 1-7may + 11-14may = 7+4 = 11 days Need help how to sum up days for Mall1 without overlapping. Currently what i do is sum up (start-end) group by Event(Mall1) and my result is 14 Thanks before. ... View more

Hi, My office just migrate from SAS BASE 9.1 to SAS EG 5.1(32bit) and it seems EG 5.1 can't export to access. Code : Proc Export data = Temp.Account_2013           outtable = "Account Data"           dbms = access           replace;      database = "/sasserver/data/temp/Account_Data.mdb"; run; it shows error : DBMS type ACCESS not valid for export. anyone can help? Thanks & Regards Edrick ... View more