Hi experts, I am facing an error in SAS Viya. Error - SAS FEDSQL doesn't supports Subquery in its Syntax. While using subquery in the code its throwing error.As i want to use in Fedsql itself, I can't use this code in Proc Sql as I'm fetching the data from database. How we can resolve it. Can you please help me out? Code -: Proc Fedsql Mysession = Sessref; create table casuser.table {options replace = true compress - true} as select htd.TRAN_DATE,htd.tran_amt,htd.tran_id,decode(htd.part_tran_type,'C','CREDIT','DEBIT') part_tran_type,gam.acid as gamacid,htd.acid as htdacid, (select foracid from tbaadm.gam@finlink where acid=htd.acid)account from tbaadm.htd@finlink,tbaadm.gam@finlink where gam.foracid IN ('0582955100398') and acct_cls_flg='N' and entity_cre_flg='Y' and htd.pstd_flg='Y' and htd.del_flg='N' and htd.tran_date BETWEEN '23-Mar-2023' AND '23-Mar-2023' and (tran_id,tran_date) in (select tran_id,tran_date from tbaadm.htd@finlink where htd.acid=gam.acid); quit;
... View more
