If then and do loop

[roland9]

Can someone please tell me for the following output

capacity airplanetype staff
150 Large 10

why the first code works and the second doesnt...

CODE_1
data work.test;
capacity = 150;
if 100 le capacity le 200 then
do;
airplanetype = 'Large';
staff = 10;
end;
else
do;
airplanetype = 'Small';
staff = 5;
end;
run;

CODE_2
data work.test;
capacity = 150;
if 100 le capacity le 200 then
airplanetype = 'Large' and staff = 10;
else airplanetype = 'Small' and staff = 5;

Thanks
run;

 

[roland9]

Hey it would be great if someone can tell me this by latest tomm morning as I have an exam which may consits of questions like these..

Thanks

 

[ChrisW75]

Sorry, it's too late for your exam, but if it's still of use to you, the problem is this line:-

if 100 le capacity le 200 then
airplanetype = 'Large' and staff = 10;

You cannot use AND in this context. You can say "if A=B AND C=D" but you cannot say "A=B AND C=D" You have to use the "DO.... END" construction as in the first example.

 

[roland9]

Hey thanks that helps.Sometimes just oversee these minute logical details.This seems to be a good forum to get some doubts cleared..

 

[ChrisW75]

You never get out of the stage of overlooking your own simple errors, but as time goes on, you find it easier to spot other peoples.