topic Re: Code Technically correct in SAS Programming

Code Technically correct

Ranjeeta — Wed, 19 Dec 2018 17:56:55 GMT

Hello folks,

I run the code below and get no errors but it is not resulting in the expected output

Is the code technically correct?

data mitra1617;
set dad.dad1617;
ARRAY ARRAY_IC [20] INTERV_CODE_01- INTERV_CODE_20;
if PROVINCE_ISSUING_HCN='ON' and RESPONSIBILITY_FOR_PAYMENT='01' and HCN_INDEX='H'
and AGE >=18 ;
DO I=1 TO 20;

IF SUBSTR(ARRAY_IC[I],1,5) ='1HU80' THEN output;

END;

Re: Code Technically correct

PaigeMiller — Wed, 19 Dec 2018 18:04:12 GMT

@Ranjeeta wrote:

but it is not resulting in the expected output

Explain this further. Show us the output that is not what you expect, and show us what you do expect.

Re: Code Technically correct

Reeza — Wed, 19 Dec 2018 18:05:37 GMT

A code can be correct syntax wise, but that doesn't mean the logic is correct. So I suspect an issue you're seeing here is duplicate records being output? Otherwise, without knowing what logic you're trying to implement we can't really answer that question.

Re: Code Technically correct

ballardw — Wed, 19 Dec 2018 18:12:09 GMT

Re: Code Technically correct

Shmuel — Wed, 19 Dec 2018 20:52:49 GMT

Please post:

(1) a sample of your data

(2) The output of that sample

(3) Point which output is not expected and explain why