I want to flag this pull as "sufficient":
proc sql;
create table dxtable as
select
claimHeaderId,
dxCode as icd,
dxCodeDescription,
dxSeqNo
from diagnosistable
where dxSeqNo = 1
and (compress(icd,".") in &ASTHMA_SUFF OR compress(icd,".") in &CAD_SUFF OR compress(icd,".") in &CHF_SUFF OR compress(icd,".") in &COPD_SUFF OR
compress(icd,".") in &DIAB_SUFF OR compress(icd,".") in &HTN_SUFF);
quit;
@bhca60 wrote:
I want to flag this pull as "sufficient":
Please explain what that means.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.