topic Re: Claim can have certain diagnosis code but not a particular code in New SAS User

Claim can have certain diagnosis code but not a particular code

Divya12 — Thu, 09 Apr 2020 18:02:36 GMT

Hi,

I need to select claims which have certain diagnosis code but should not a have a particular code within the submitted claim.

Condition -

A claim can have Codes in ('0260','0261','0262','0263')

but should not have code ('560')

Re: Claim can have certain diagnosis code but not a particular code

ballardw — Thu, 09 Apr 2020 18:22:12 GMT

You might want to provide some example of what the data looks like and what you actually expect the output to look like.

For instance, we cannot tell if you are adding one or more variables or keeping/removing records from a data set.

Does each record have exactly one code variable to compare or are there multiple codes?

Some coding systems with diagnosis may also have a decimal portion such as 0260.1 0260.2 or similar. If your values look like this then are you comparing the whole value or just the base part?

Re: Claim can have certain diagnosis code but not a particular code

Divya12 — Thu, 09 Apr 2020 18:30:34 GMT

This is how the table will look like

claimnumber	code
101	0260
101	0261
101	0262
101	0865
102	0260
102	0261
102	0560

Output
claimnumber	code
101	0260
101	0261
101	0262
101	0865

Here we will not be selecting claim 102 because it has '0560' code in it but we will select 101 as it has codes which are in ('0260','0261','0262','0263')

Re: Claim can have certain diagnosis code but not a particular code

Jagadishkatam — Thu, 09 Apr 2020 19:07:59 GMT

data have;
input claimnumber code;
cards;
101 0260
101 0261
101 0262
101 0865
102 0260
102 0261
102 0560
;

proc sql;
create table want as select * from have where claimnumber not in (select claimnumber from have where code=0560);
quit;

Re: Claim can have certain diagnosis code but not a particular code

Divya12 — Fri, 10 Apr 2020 12:32:57 GMT

But i would also have to check if they have codes in ('0260','0261','0262','0263') because not every claim may have these codes.

Re: Claim can have certain diagnosis code but not a particular code

Jagadishkatam — Fri, 10 Apr 2020 13:24:37 GMT

you may try the below code


proc sql;
create table want as select * from have where claimnumber not in (select claimnumber from have where code=0560) and claimnumber in (select claimnumber from have where code in (0260,0261,0262,0263));
quit;