Given the contents of the raw data file EMPLOYEE:
----|----10----|----20----|----30
Alan -
19/2/2004
ACCT -
Rob -
22/5/2004
MKTG -
MaryJane -
14/3/2004
EDUC -
The following SAS program is submitted:
data emps;
infile employee;
input@1 name$
@15 date
@25 department$;
run;
Which INFORMAT correctly completes the program?
The correct INFORMAT to read the date in the format present in the data file is ddmmyyyy10. This format specifies a day, month, and four-digit year, taking up 10 characters, which matches the dates provided ('19/2/2004', '22/5/2004', '14/3/2004'). The other options either have a different number of characters or do not match the date format correctly.
given answer D is correct, as the name of the informat is ddmmyy10. (not ddmmyyyy10.) s. https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/leforinforref/p06uhyxxlwelgun1t29b5tagsyty.htm data work.EMPLOYEE; infile datalines; input @1 name $ @15 date : ddmmyy10. @25 department $; datalines; Alan 19/2/2004 ACCT Rob 22/5/2004 MKTG MaryJane 14/3/2004 EDUC ;
please leave your comments/suggestion. different opinions and the discussion will improve our understanding!
should be D?