topic Re: if then statement in SAS Programming

if then statement

Dhana18 — Mon, 29 Apr 2019 20:19:26 GMT

Pleasse tell me what is wrong with this code?

DATA MarchNin.MERGE_March2019_P;
SET MarchNin.MERGE_March2019_O;
IF HIV_COMBON_A ="N" OR HIV_1_2_ABBLOOD ="N" OR HIV_GEENION_A="N" OR HIV_PCRN_A="N" THEN GISP_HIVRESULT ="0";
ELSE IF HIV_COMBON_A ="A" OR HIV_1_2_ABBLOOD ="A" OR HIV_GEENION_A="A" OR HIV_PCRN_A="A" THEN GISP_HIVRESULT ="9";
ELSE IF HIV_COMBON_A="P" OR HIV_1_2_ABBLOOD="P" OR HIV_GEENION_A="P" OR HIV_PCRN_A="P" THEN GISP_HIVRESULT ="1";
ELSE GISP_HIVRESULT ="7";
RUN;

PROC FREQ DATA=MarchNin.MERGE_March2019_P;
TABLE GISP_HIVRESULT;
RUN;

Here is the result:

GISP_HIVRESULT Frequency Percent CumulativeFrequency CumulativePercent079

241	64.61	241	64.61
128	34.32	369	98.93
4	1.07	373	100.00

Why am I not getting only 0, 7, and 9 and not 1 under GISP_HIVRESULT? Please help.

Re: if then statement

PGStats — Mon, 29 Apr 2019 21:04:03 GMT

Proc freq only presents to you the frequencies that occur in your data. It does not include zeros for values that could have been present but that didn't occur in your data.

Re: if then statement

Dhana18 — Mon, 29 Apr 2019 21:15:37 GMT

Thank you. I modified the like this and it worked.

DATA MarchNin.MERGE_March2019_P;
SET MarchNin.MERGE_March2019_O;
IF HIV_COMBON_A="P" THEN GISP_HIVRESULT ="1";
else IF HIV_COMBON_A ="N" OR HIV_1_2_ABBLOOD ="N" OR HIV_GEENION_A="N" OR HIV_PCRN_A="N" THEN GISP_HIVRESULT ="0";
ELSE IF HIV_COMBON_A ="A" OR HIV_1_2_ABBLOOD ="A" OR HIV_GEENION_A="A" OR HIV_PCRN_A="A" THEN GISP_HIVRESULT ="9";
ELSE GISP_HIVRESULT ="7";
RUN;

I did not have response "P" in all variables.