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;
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;
Well, to start you have an extra comma after bb.* which shouldn't be there...
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;
Well, to start you have an extra comma after bb.* which shouldn't be there...
That was it! Thanks. I knew it was gonna be something dumb
proc sql;
create table table_name as
select column_names
from table
where restrictions ;
run;
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;
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.