Hate to state the obvious but have you checked that you've got the correct path and filename - no spaces, for example. Only asking from experience. Second, might try using the PCFILES access method: LIBNAME lref PCFILES PATH=<>; Third, try importing from the Import wizard: File<Import Data ... View more

Take a look at the WeekDay() function. Give a date value, it returns 1-7, where 1=Sunday, 7=Saturday indicating the day of the week To convert from Date-Time, use the DatePart() function, So, isweekday = (WeekDay(DatePart(dtvalue)) IN (2..6)); * think I got the parens right ; returns, 0 (false), or 1(true). ... View more

Second data step gets what you want. Hopefully enough comments so you can understand what I'm doing Shows a couple of useful techniques. DATA test; INPUT user : $1. element : $2. epoch_start_date : DATE9.; FORMAT epoch_start_date DATE.; CARDS; 1 A1 1OCT2014 1 A2 10OCT2014 1 A3 20OCT2014 2 A1 5OCT2014 2 A2 15OCT2014 2 A3 25OCT2014 3 A1 8OCT2014 4 A1 11OCT2014 4 A2 21OCT2014 ;;;; DATA results; SET test NOBS=_no;  /* NOBS contains number of observations */ IF _n_ < _no THEN DO;  /* don't want to go past End of file */   P = _N_+1;  /* set the point variable */   SET test(RENAME=(user=_u element=_e epoch_start_date=epoch_end_date)) POINT=P ; /* read second stream, using POINT SET option */   epoch_end_date = IFN (user=_u,Sum(epoch_end_date,-1),.); /* test that we are reading the same user if */   OUTPUT;  /* write out */   Call Missing(epoch_end_date); /* clear out end date, otherwise it carries over */ END; ELSE OUTPUT; /* write out last obs */ DROP _:; /* drop all _ variables */ RUN; ... View more

Did you try SAS support? ... View more

assuming your data set is named t: PROC MEANS data=T nway noprint; CLASS id year; VAR bill charlie; OUTPUT OUT=sum_t sum(bill charlie)=; RUN; no need to sort, class statement does it for you. output dataset is sum_t ... View more

Try using a SELECT in front of the Max(). You're using a FROM and WHERE, presumably trying to make an sql expression ... View more