Can anybody help me find my syntax error in the code below?   Thanks!   proc sql; create table test3 as select distinct bb.* , from ((select mmcor_cd, srv_type_cd, srv_dt, CLAIM_LINE_NUM, claim_class_cd, max(claim_line_num) as max_claim from claim_trans group by tcn)) aa, claim_ppv bb where aa.tcn = bb.tcn and bb.claim_line_num = aa.max_claim order by tcn, claim_line_num ; quit; ... View more

hello all,   I am trying to convert some dates to quarters and week days as well as calculating length of stay with them using proc sql. I have used the code before and it's worked but today it's been giving me the following notes:   below is a sample of the code that I've been using and my formats:   proc sql; create table NEW as select a.*,       case when VAR='88'  then 1 else 0 end as CAT,       put(qtr(VAR1), qr.) as a_qtr,           put(qtr(VAR2), qr.) as d_qtr,       put(weekday(VAR1), wk.) as a_day,       intck('DAY',VAR2,VAR1) as c_los, from OLD a ; quit;   value wk 1='SUN' 2='MON' 3='TUE' 4='WED' 5='THU' 6='FRI' 7='SAT'   value qr 1='Jan-Mar' 2='Apr-Jun' 3='Jul-Sep' 4='Oct-Dec'   What am I doing wrong?? ... View more