Hey everyone, I have been trying to determine the amount of days between the first date and the last date. I have tried subtracting the first date from the last date but have run into a strange issue. If the amount of days between the first and last date is over a 100, it is still listed as 100. So if there was 200 days between the first and last visit, it would be listed as 100. Example: PROC SQL; CREATE TABLE FIRSTLAST AS SELECT ID, COUNT(ID) AS COUNT, MIN(DOS_FROM) AS FIRST, MAX(DOS_TO) AS LAST, DOS_TO - DOS_FROM AS DAYS FROM DATA GROUP BY ID; QUIT; Any help would be much appreciated and if anyone has a better suggestion as to how to construct a better syntax, I am all ears. Thanks, Mike
... View more