Searching Across Variables CPT Codes

kingsii24 — Wed, 23 Dec 2020 19:19:29 GMT

I have a dataset that contains procedure codes ranging from 1 to 12 (cpt_code1-cpt_code12), that were performed on the same day. I need to search across these variables for specific codes that are related to a specific test being carried on on a patient.

The codes related to each procedure are listed below:

Test1: 81507, 84702

Test2: 84163, 84702, 76813

Test3: 82677, 84702, 86336
Test4: 82105, 84702, 86336, 82677

Note that all the codes listed for each test need to exist in the same row (i.e.cpt_code1-cpt_code12) for that test to be valid. In other words, let's say for a specific person, their row only contains cpt code 81507, I wouldn't be able to classify them as receiving Test1 since cpt code 84702 is not included in that line.

I've tried searching previous forums (and reading about arrays) but I can't seem to find anything that matches my situation.

Below is a snippet of what I have so far:

data work.example2;
length test_type $20.;
set work.example;
array acpt_code(1:12) cpt_code1-cpt_code12;
do i=1 to 12;
if acpt_code[i] in ('81507', '84702') then test_type="Test1";	
end;
run;

I know the above code is not correct since I'm just telling SAS to search across the variables to see if at least one of the cpt codes exist, and I need to know that both codes exist in order for Test1 to be assigned as the test type (which is where I'm stuck).

Thanks in advance!

Re: Searching Across Variables CPT Codes

data_null__ — Wed, 23 Dec 2020 21:11:31 GMT

Show example input your HAVE data.

Re: Searching Across Variables CPT Codes

FreelanceReinh — Wed, 23 Dec 2020 21:41:05 GMT

Hi @kingsii24,

Just adapt the program code to the logic and search for those specific codes in the array (and not vice versa), for example:

if '81507' in acpt_code & '84702' in acpt_code then test_type="Test1";

topic Re: Searching Across Variables CPT Codes in SAS Programming

Searching Across Variables CPT Codes

Re: Searching Across Variables CPT Codes

Re: Searching Across Variables CPT Codes