SAS error proc sql union

manya92 — Mon, 17 Sep 2018 02:43:25 GMT

hi all

I am unable to figure out the erorr in this code. Any help is appreciated.

Thank You

NOTE: Remote submit to MYNODE complete.
43   rsubmit ;
NOTE: Remote submit to MYNODE commencing.
303  *union t table from medicare and medicad together ;
304  proc sql;
305
306      *commercial;
307
308      create table data._03_t_table as
309          select distinct a.*,b.dtstart,b.dtend
310          from data._01_claims as a
311          inner join original.ccaet141 as b
312          on a.enrolid =b.enrolid
313      union
314          select distinct c.*,d.dtstart,d.dtend
315          from data._01_claims as c
316          inner join original.ccaet151 as d
317          on c.enrolid =d.enrolid
318          order by c.enrolid,c.svcdate,c.prod_grp
319      ;
ERROR: Unresolved reference to table/correlation name c.
ERROR: Unresolved reference to table/correlation name c.
ERROR: Unresolved reference to table/correlation name c.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
320  quit ;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds

NOTE: Remote submit to MYNODE complete.

Re: SAS error proc sql union

SASKiwi — Mon, 17 Sep 2018 02:48:42 GMT

Try removing the C from your ORDER BY

 order by enrolid, svcdate, prod_grp

topic Re: SAS error proc sql union in SAS Programming

SAS error proc sql union

Re: SAS error proc sql union