The contents of the raw data file NAMENUM are listed below:
--------10-------20-------30
Joe xx
The following SAS program is submitted:
data test;
infile 'namenum';
input name $ number;
run;
Which one of the following is the value of the NUMBER variable?
A. xx
B. Joe
C. . (missing numeric value)
D. The value can not be determined as the program fails to execute due to errors.
Click Comment link to get answer
Answer is C, missing value, since a numeric value is expected for the variable been read, and a character value was found.
ReplyDeleteAnswer C
ReplyDeleteAnswer is C.
ReplyDeleteYou have given name as character and there was no delimiter. so it will read 1st characters including the space i.e Joe xx and number seems to be missing. So output will be missing..
Correct it if am wrong
Kiruba, there was no delimiter means default space will be used as delimiter here. So name will read Joe and number is expecting numeric value but it reads xx, so number is set to missing.
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteAnswer is C
ReplyDeleteAnswer is C
ReplyDeleteanser is c
ReplyDeleteD
ReplyDeleteanswer is c because variable is character not the numeric and hence $ was not given it ll be missing
ReplyDeleteAnswer is A
ReplyDeleteSAS encounters character data for numeric data and sets _error_=1. However, SAS still runs the code and generates an list file with name=Jeo and number is set to a missing value
ReplyDeleteC
ReplyDeleteC
ReplyDeletehow can the answer be c? the program will not execute if you give infile 'namenum';we cannot use a name in quotes in infile statement.it didn't execute when i tried.i think the answer is D
ReplyDeleteAns is D
ReplyDeleteSakar;
ReplyDeletePlease focus on logic, in input we have name $ ( which is defined a character variable) number ( a numeric variable),
When we execute the sas program it reads in data vector name as character variable looks for numeric variable as assigned in input statement. But is does not find numeric but xx is character so in data vector it writes 1 and which is missing numeric value.
Who ever said a or be needed to grasp the logical side of SAS program. Do not get confused as well do not confuse others too.
Thank you.
ans is C
ReplyDeleteanswer is missing value
ReplyDelete