I have a sql code as below:
select tbraccd_Detail_code "detail code",tbraccd_term_code "Term",tbraccd_effective_date "Effective_Date",
sum (tbraccd_balance) "Balance"
from spriden, tbraccd,TBBDETC
where spriden_pidm = tbraccd_pidm
and tbbdetc_detail_code = tbraccd_detail_code
and tbraccd_term_code = '201610'
and TBBDETC_DCAT_CODE = 'IPL'
and spriden_change_ind is null
having sum(tbraccd_balance) <>0
and spriden_id = 'V033796'
group by spriden_id,tbraccd_detail_code,tbraccd_term_code,tbraccd_effective_date
order by tbraccd_effective_date desc
I need to convert this to SAS code. i converted as below but solution is not same. Where is my mistake?
select tbraccd_Detail_code as detail_code, tbraccd_term_code as Term, tbraccd_effective_date as Effective_Date,
sum (tbraccd_balance) as Balance
from stg.spriden, stg.tbraccd,stg.TBBDETC
where spriden_pidm = tbraccd_pidm and tbbdetc_detail_code = tbraccd_detail_code
and TBBDETC_DCAT_CODE = 'IPL' and tbraccd_term_code= "201610"
and spriden_id = 'V033796' and spriden_change_ind is null group by spriden_id,tbraccd_detail_code,tbraccd_term_code,tbraccd_effective_date
having sum(tbraccd_balance) <>0 order by tbraccd_effective_date desc ;quit;
... View more