The SAS data set named COMPANY.PRICES is listed below:
COMPANY.PRICES
prodid price producttype sales returns
K12S 5.10 NETWORK 15 2
B132S 2.34 HARDWARE 300 10
R18KY2 1.29 SOFTWARE 25 5
3KL8BY 6.37 HARDWARE 125 15
DY65DW 5.60 HARDWARE 45 5
DGTY23 4.55 HARDWARE 67 2
The following SAS program is submitted:
libname company 'SAS-data-library';
data hware inter soft;
set company.prices (keep = producttype price);
if price le 5.00;
if producttype = 'HARDWARE' then output HWARE;
else if producttype = 'NETWORK' then output INTER;
else if producttype = 'SOFTWARE' then output SOFT;
run;
How many observations does the HWARE data set contain?
A. 0
B. 2
C. 4
D. 6
Click Comment link to get answer
ElearnSAS.com
SAS Learning Platform
B
ReplyDeleteif price le 5.00;
ReplyDeleteSo the Ans is B
Obs price producttype
1 2.34 HARDWARE
2 4.55 HARDWARE
can some one please explain in detail why it is B.
ReplyDeleteFollowing three observation satisfy condition if price le 5.
ReplyDeleteB132S 2.34 HARDWARE 300 10
R18KY2 1.29 SOFTWARE 25 5
DGTY23 4.55 HARDWARE 67 2
Out of the above 3 observation only 2 observation have producttype = 'HARDWARE', so number of observation in HWARE is 2, hence answer is B.
thank you
DeleteYeah this is understandable :)
DeleteA -- the else, if statements must end with an else statement
ReplyDeleteI have seen many stupid comments in this blog but the one right above beats them all
ReplyDeleteI have seen many hilarious posts in this blog but yours one beats them all :) :D
DeleteTrue. The dudes high on something.
ReplyDeleteIf we do not close loop for iF statement than it will not give any result.
ReplyDeleteIs it open?
ReplyDelete....
ReplyDeletedata test;
ReplyDeleteinput prodid $ price producttype $ sales returns;
cards;
K12S 5.10 NETWORK 15 2
B132S 2.34 HARDWARE 300 10
R18KY2 1.29 SOFTWARE 25 5
3KL8BY 6.37 HARDWARE 125 15
DY65DW 5.60 HARDWARE 45 5
DGTY23 4.55 HARDWARE 67 2
;run;
data hware inter soft;
set test;
if price le 5.00;
if producttype = 'HARDWARE' then output HWARE;
else if producttype = 'NETWORK' then output INTER;
else if producttype = 'SOFTWARE' then output SOFT;
run;
proc print data=hware; run;
try it and you'll see that the answer is B for sur! there isn't any problem of "closing the IF ELSE statment !!"
ps: sorry for my english
if price le 5.00; is an if sub-setting statement in this case
Deleteans is B.
ReplyDeletethere is no need to close an IF\THEN statement.
its compulsory to close a DO statement.
the above program posted by anonymous is correct.
B
ReplyDeletedata ganesh.company_prices;
ReplyDeleteinput @1 prodid $ @8 price 4.2 @13 producttype $9. @23 sales 3. @27 returns 2.;
format price 4.2;
datalines;
K12S 5.10 NETWORK 15 2
B132S 2.34 HARDWARE 300 10
R18KY2 1.29 SOFTWARE 25 5
3KL8BY 6.37 HARDWARE 125 15
DY65DW 5.60 HARDWARE 45 5
DGTY23 4.55 HARDWARE 67 2
;
run;
data company_prices;
set ganesh.company_prices;
if price le 5.00;
if producttype = 'HARDWARE' then output = 'HWARE';
else if producttype = 'NETWORK' then output = 'INTER';
else if producttype = 'SOFTWARE' then output = 'SOFT';
run;
This syntax will give you 2 observation for Hardware and one for software;
so B seems to be the correct answer. The question is output = 'SOFT' or output SOFT which one is correct; with output SOFT is giving errors.
If two IF statements change the position each other, then what happened? why do sas data set HWARE have 4obs?
ReplyDeleteHware output takes 4 observations from hardware productype prior to 'if price' statement has run
DeleteB is right
ReplyDeleteB
ReplyDeleteactually there should be 3 observations as price is le 5. price 5 also should be considered. but we donot have that option.
ReplyDeleteHow does the presence of ELSE statements affect the results ? Do we ignore any condition in ELSE in this case?
ReplyDeleted is correct
ReplyDeleteInformative and helpful Article. Really good work. Appreciate it. You might be looking for Sales Order Management in Bangalore
ReplyDelete