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.
Try removing the C from your ORDER BY
order by enrolid, svcdate, prod_grp
Try removing the C from your ORDER BY
order by enrolid, svcdate, prod_grp
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.