Hi All, Could someone to help me please. I need to take closest visit date which lies between (start date) and (end date) of treatment taken. I tried to make it using sql but my skills is not so far as wanted. Here is piece of code: proc sql; create table fix_ex1 as select a.treat, a.subject, a.date, a.exstdt, a.exrdi, a.date, a.rec_ds, a.dsdecod, max(b.vddt) as b.vdd_max, b.foldername, b.folderseq, b.vdyn from fix_ex1_1 as a left join visits as b on a.subject=b.subject where calculated b.vdd_max between a.exstdt and a.date order by a.subject,b.vdd_max,b.folderseq; quit; But error comes out: max(b.vddt) as b.vdd_max, _ 22 76 ERROR 22-322: Syntax error, expecting one of the following: a quoted string, ',', AS, FORMAT, FROM, INFORMAT, INTO, LABEL, LEN, LENGTH, TRANSCODE. ERROR 76-322: Syntax error, statement will be ignored.
... View more