Good Afternoon, I need to know how I can get this to work for me. Everything but this portion is not working and need to know why the error appears and how to get it to work. Thanks for the help. TO_DATE(((TO_DATE('01-JAN-1970','DD-MON-RRRR')) + ((h.MODIFIED/86400) + (-7/24)))) as time All code: proc sql; create table ACCESS_SUMMARY as select a.type_,s.clinic , a.code, a.appointment, a.createdate,a.date_ , s.custom1 as LOC, a.clinic, a.patient, c.chart, r.typecode, A.producer, datepart(A.Date_), month(datepart(A.DATE_)) as month, h.modified as modifiedtime, TO_DATE(((TO_DATE('01-JAN-1970','DD-MON-RRRR')) + ((h.MODIFIED/86400) + (-7/24)))) as time, (datepart(A.DATE_) - datepart(A.createdate)) / 7 as n_weeks, case when (month(datepart(A.DATE_)) in (1,2,3)) then 'Q1' when (month(datepart(A.DATE_)) in (4,5,6)) then 'Q2' when (month(datepart(A.DATE_)) in (7,8,9)) then 'Q3' when (month(datepart(A.DATE_)) in (10,11,12)) then 'Q4' else '' end as Quarter from myora.ax_appoint A, myora.ax_patient c, myora.ax_producer r, myora.ax_clinic S, myora.ax_appthis h where c.patient = a.patient and A.APPOINTMENT = H.APPOINTMENT and r.producer = a.producer and a.clinic = s.clinic and a.status = 0 and a.type_ in (2,1,0) and h.type_ = 0 and r.typecode in &DENT and A.date_ between &TDDAY and &ENDDATE and a.date_ = a.createdate and coalesce(a.code, 'unknown') not in ('NEWAPT', 'EVAL','NEWA','NEWA INT','EVAL1','NEWPT','2CH 3U ASST') and a.code not in ('NEWAPT', 'EVAL','NEWA','NEWA INT','EVAL1','NEWPT','2CH 3U ASST') order by s.custom1; quit;
... View more
