pcpNPI is a numeric 20 variable but i'm getting an error for some reason: 454 proc sql; 455 create table ppp 456 as select 457 a.pid, 458 a.input(pcpNPI, 20.) format=20. as pcpNPI2, _ __ 79 22 76 ERROR 79-322: Expecting a FROM. ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, CONNECTION, DICTIONARY. ERROR 76-322: Syntax error, statement will be ignored. 459 a.pname, 460 a.group, 461 b.nflg, 462 b.dflg, 463 b.cond, 464 b.days 465 from ftable as A 466 inner join numerator1 as B 467 on a.pid=b.pid 468 where pcpNPI2 in ('444', '444','444','444','444','444', 469 '44','44','44','444','444'); NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 470 run;   ... View more

I'm trying to do an inner join in the final step on pid but I'm getting an error (I posted the previous two data steps for reference): /*DENOMINATOR - merge to get dx rank for the dx codes*/ /*ran successfully and the ddate column populates correctly per the formula*/ data denom_final; length dx $100; merge opipdata (in=ina) out.diag; by pid; format ddate yymmdd10.; if ina; if ((dxpos = 1 and dx in &aaa) then condition = "AAA"; if ((dxpos = 1 and dx in &ccc) then condition = "CCC"; if ((dxpos = 1 and dx in &ppp then condition = "PPP"; if ((dxpos = 1 and dx in &ppp) then condition = "OOO"; if ((dxpos = 1 and dx in &ddd) then condition = "DDD"; if ((dxpos = 1 and dx in &hhh) then condition = "HHH"; /*op data will not have disc date so create variable for when dischdate is missing and replace with edate*/ if missing(input(dischdate,yymmdd10.))then ddate= input(edate,yymmdd10.); else ddate= input(dischdate,yymmdd10.); run; /*NUMERATOR*/ /*RAN SUCCESSFULLY*/ proc sql; create table numerator as select id, pid, dx, edate as ndate, admitdate, dischdate from detailstable where dx in &aaa_suff OR dx in &ccc_suff OR dx in &ooo_suff OR dx in &ppp_suff OR dx in &ddd_suff OR dx in &hhh_suff OR dx in &aaa_rel OR dx in &ccc_rel OR dx in &ooo_rel OR dx in &ppp_rel OR dx in &diab_rel OR dx in &htn_rel) AND edate between '01Jan2021' and '31Dec2021' and (rev in &ED_REV or rev in &OBS_REV or cpt in &ED_CPT or cpt in &OBS_CPT) order by pid; quit; proc sql; create table combined as select id, pid, a.ddate, b.ndate from denom_final a inner join numerator b on pid; quit; ERROR: Ambiguous reference, column pid is in more than one table.   ... View more