I'm trying to create a table that is limited to only the members I specify, but I'm getting all the members.
The members are here identified by their ctg_id_txt.
proc sql;
create table mems_a_&year as
select distinct
a.ctg_id_txt as ctg
,b.npi_id as npi
,b.tin
,b.tin_nm
,b.tin_nm_rllp
,a.eligty_mo_yyyymm
,b.clm_sys_pvdr_id
from ACORS.core_attrbn_reslt_pmpm a, DATA.pvdr_roster b
where a.npi_txt = b.npi_id
and a.tax_id_txt = b.tin
and cntrct_typ_id in (331929496) /*MA PPO*/
and ctg_id_txt in (995999994922850,
995999995203792,
999499993122771,
999499993127895)
and eligty_mo_yyyymm between &yearmo_beg and &yearmo_end
;quit;
What isn't working?
As I mentioned, I'm returning all members, not just the ones with the ctg_id_txt I specified. In exploring the matter further I think it is because the ctg_id_txt is a character datatype so, I think, I need to put the values in single quotes.
Yes, if it's a character it needs to be quoted, single or double.
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 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.