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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.