topic I want to flag a data pull in SAS Enterprise Guide

I want to flag a data pull

bhca60 — Mon, 20 Jun 2022 14:40:02 GMT

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;

Re: I want to flag a data pull

PaigeMiller — Mon, 20 Jun 2022 14:57:22 GMT

@bhca60 wrote:

I want to flag this pull as "sufficient":

Please explain what that means.

Re: I want to flag a data pull

bhca60 — Mon, 20 Jun 2022 15:01:09 GMT

I want to define this as "sufficient" and I have another that will be "related"

Re: I want to flag a data pull

bhca60 — Mon, 20 Jun 2022 15:03:24 GMT

never mind, i guess i'll just name the tables sufficeint or related then go from there.