topic Re: Array to set criteria to missing not working in SAS Programming

Array to set criteria to missing not working

TPayne — Tue, 26 Nov 2019 19:45:08 GMT

Hello,

I have a dataset that is pulling in vaccination dates. I want to compare these dates to a specific date and set any vaccination dates to missing if they are after the comparison date. I have the following code, but the dates I would expect to be set to missing are not. Any insight would be helpful.

/*CREATE VARIABLE TO CHECK COMPLETENESS BY 25 MONTH WITH*/

DATA COMPLETE2;
SET ALLVAX3;
DATE25= HS_DOB + 760;
FORMAT DATE25 mmddyy10.;
RUN;

/* SET ANY VACCINATIONS OVER 2YR OLD TO MISSING*/
DATA COMPLETE_DATECHECK (DROP=I);
SET COMPLETE2;

ARRAY DTP(8) DTP1-DTP8;
DO I= 1 TO 8;
IF DTP[1] > DATE25 > . THEN DTP[I]= .;
END;
RUN;

All dates are formatted mmddyy10.

example dataset:

record_id	hs_dob	DTP1	DTP2	DTP3	DTP4	DTP5	DTP6	DTP7	DTP8	DATE25
224	1/5/2016	3/31/2016	7/18/2016	5/2/2017	8/8/2018					2/3/2018
227	1/5/2016	3/11/2016	5/20/2016	7/11/2016	4/26/2017					2/3/2018
245	1/4/2016	3/18/2016	5/9/2016	7/11/2016	4/5/2017					2/2/2018
254	1/5/2016	3/4/2016	8/2/2016	10/5/2016	5/11/2018					2/3/2018

In the above table, I would expect DTP4 for records 224 and 254 to be set to missing.

Thank you!

Re: Array to set criteria to missing not working

novinosrin — Tue, 26 Nov 2019 19:43:45 GMT


DATA COMPLETE_DATECHECK (DROP=I);
SET COMPLETE2;

ARRAY DTP(8) DTP1-DTP8;
DO i= 1 TO 8;
IF DTP[i] > DATE25 THEN dtp(i)=.;
END;
RUN;

Re: Array to set criteria to missing not working

TPayne — Tue, 26 Nov 2019 19:48:43 GMT

I accidentally copied code in to my post from when I was trouble-shooting the issue. My original code is what you have suggested, but that does not produce the expected results either.

Re: Array to set criteria to missing not working

PaigeMiller — Tue, 26 Nov 2019 19:51:50 GMT

@TPayne wrote:
I accidentally copied code in to my post from when I was trouble-shooting the issue. My original code is what you have suggested, but that does not produce the expected results either.

Saying it does not produce the expected results does not give enough information.

Show us the data. Show us the actual code you used. Show us the output that isn't what you expect.

Re: Array to set criteria to missing not working

TPayne — Tue, 26 Nov 2019 20:02:39 GMT

Hi Paige!

I edited my post to contain the correct code:

/*CREATE VARIABLE TO CHECK COMPLETENESS BY 25 MONTH WITH*/

DATA COMPLETE2;
SET ALLVAX3;
DATE25= HS_DOB + 760;
FORMAT DATE25 mmddyy10.;
RUN;

/* SET ANY VACCINATIONS OVER 2YR OLD TO MISSING*/
DATA COMPLETE_DATECHECK (DROP=I);
SET COMPLETE2;

ARRAY DTP(8) DTP1-DTP8;
DO I= 1 TO 8;
IF DTP[1] > DATE25 > . THEN DTP[I]= .;
END;
RUN;

For results when I run this, no dates change (i.e. DTP4 for record id 224 and 254 stays the same rather than turning to missing.) The dataset after running the code looks like this:

record_id	hs_dob	DTP1	DTP2	DTP3	DTP4	DTP5	DTP6	DTP7	DTP8	DATE25
224	1/5/2016	3/31/2016	7/18/2016	5/2/2017	8/8/2018					2/3/2018
227	1/5/2016	3/11/2016	5/20/2016	7/11/2016	4/26/2017					2/3/2018
245	1/4/2016	3/18/2016	5/9/2016	7/11/2016	4/5/2017					2/2/2018
254	1/5/2016	3/4/2016	8/2/2016	10/5/2016	5/11/2018					2/3/2018

Re: Array to set criteria to missing not working

PaigeMiller — Tue, 26 Nov 2019 20:08:22 GMT

IF DTP[1] > DATE25 > . THEN DTP[I]= .;

I'm guessing this is the problem, and it should be (not in a DO loop)

if dtp[1]>date25 then call missing(of dtp[*]);

But I don't know if that's the right logic, just to confirm, you are only check if dtp[1] is greater than date25??

Re: Array to set criteria to missing not working

TPayne — Tue, 26 Nov 2019 20:26:04 GMT

Hi Paige! that is correct- I just want any dose past date25 to be missing!

Re: Array to set criteria to missing not working

Tom — Tue, 26 Nov 2019 20:33:49 GMT

@TPayne wrote:

Hi Paige! that is correct- I just want any dose past date25 to be missing!

Which is not what Paige asked.

Your code is testing if the FIRST date is after the last date.

Sounds like you want to test each date instead.

So use the variable I as the index into the array instead of the number one.

Re: Array to set criteria to missing not working

Reeza — Tue, 26 Nov 2019 22:50:56 GMT

TPayne, both codes show you using a fixed number 1 as the index in your array not the letter i as indicated.

Re: Array to set criteria to missing not working

Shmuel — Wed, 27 Nov 2019 02:10:55 GMT

Pay attention to @novinosrin post, the code

IF DTP[1] > DATE25 > ....

1st member in array ???

you probably ment to

IF DTP[i] > DATE25 > ......

the i'th member in array