topic If then else in SAS Procedures

If then else

leahcho — Thu, 14 Dec 2017 16:25:30 GMT

Hi,

I am having a trouble with my if then else statements,

I wrote

data all_1;
set total;
if hud080=. then h_count=.;
else if hud080=77777 then h_count= .;
else if hud080=99999 then h_count=.;
else if huq071=1 and hud080=1 then h_count=1;
else if huq071=1 and hud080 in (2,3,4,5,6) then h_count=2;

else if huq071=2 then h_count=0;
run;

Then my output for proc freq does not have h_count=0. Could anyone explain why h_count=0 is missing ? Thanks

SAS Output

h_count Frequency Percent CumulativeFrequency CumulativePercent12Frequency Missing = 45980

3705	74.32	3705	74.32
1280	25.68	4985	100.00

Re: If then else

RW9 — Thu, 14 Dec 2017 16:31:39 GMT

No, we can't tell you why that is, you have not shown any test data. SAS is based on data, without that part the logic doesn't do anything. At a guess:

else if huq071=2 then h_count=0;

This condition is never met.

Maybe you meant:

else h_count=0;

Re: If then else

Astounding — Thu, 14 Dec 2017 16:36:03 GMT

The IF/THEN statements look OK. Maybe the problem is with the data. Do you actually have any observations that have 2 as the value of HUQ071?

Here's a good way to check what is in your data:

proc format;

value check .='Missing' 77777 = '77777' 99999='99999' other='Valid';

run;

proc freq data=have;

tables HUQ071 * HUD080 / missing;

format HUD080 check. ;

run;

Re: If then else

ballardw — Thu, 14 Dec 2017 17:43:14 GMT

If you have many values for each of the two variables this modification of @Astounding's Proc freq may be of interest:

proc freq data=have;

tables HUQ071 * HUD080 / list nopercent missing;

run;

The LIST option creates one row per combination instead of the large two dimensional table and suppresses all of the percentages which I seldom find helpful in identifying data combinations.