We provide real A00-281 exam questions and answers braindumps in two formats. Download PDF & Practice Tests. Pass SAS Institute A00-281 Exam quickly & easily. The A00-281 PDF type is available for reading and printing. You can print more and practice many times. With the help of our SAS Institute A00-281 dumps pdf and vce product and material, you can easily pass the A00-281 exam.
Q17. The following output is displayed:
Which SAS program created this output?
A. proc freq data=WORK.TESTDATA;
tables gender * answer / nocol norow nopercent; run;
B. proc freq data=WORK.TESTDATA;
tables answer * gender / nocol norow nopercent; run;
C. proc freq data=WORK.TESTDATA;
tables gender * answer / nocol norow nopercent missing; run;
D. proc freq data=WORK.TESTDATA;
tables answer * gender / nocol norow nopercent missing; run;
Answer: A
Q18. Given two data sets with the following variables:
Why is the blue note showing in the log?
A. The variable VISIT occurs in both data sets but is not included in the BY statement.
B. There are no observations with matching values for SUBJID in either data set.
C. There are multiple observations with the same value for SUBJID in both data sets.
D. One of the two data sets has multiple observations with the same value for SUBJID.
Answer: C
Q19. Which clause allows macro variable creation on a select statement in PROC SQL?
A. INTO
B. SYMPUT
C. AS
D. %MACRO
Answer: D
Q20. Given the VITALS data set:
A. proc transpose data=vitals ; var pulse sysbp diabp ;
run ;
B. proc transpose data=vitals ; by patid visit ;
run ;
C. proc transpose data=vitals ; var patid visit ;
run ;
D. proc transpose data=vitals ; id patid visit ;
run ;
Answer: B
Q21. CORRECT TEXT
Which CDISC filename contains the following items?
• Variable attributes
• Controlled terminology
• Computational methods
Enter your answer in the space below (Case is ignored. Do not add leading or trailing spaces to your answer.).
Answer:
DEFINE.XML,DEFINE.PDF,DEFINE
Q22. Given the following partial output data set:
Which code was used to create AGECAT?
A. if age <18 then AGECAT=1;
if 18<=AGE<=40 then AGECAT=2;
else AGECAT=3;
B. if age <=18 then do AGECAT=1;
else if 18<AGE<=40 then do AGECAT=2; else do AGECAT=3;
C. if age <18 then AGECAT=1;
else if 18<=AGE<=40 then AGECAT=2; else AGECAT=3;
D. if age <=18 then AGECAT=1;
else if 18<AGE<=40 then AGECAT=2; else AGECAT=3;
Answer: D
Q23. The following SAS program is submitted:
Which types of variables are DayofMonth, MonthofYear, and Year?
A. DayofMonth, Year, and MonthofYear are character.
B. DayofMonth, Year, and MonthofYear are numeric.
C. DayofMonth and Year are numeric. MonthofYear is character
D. DayofMonth, Year, and MonthofYear are date values
Answer: B
Q24. You have been asked to import an Excel spreadsheet. What will lead to substantial differences between the original Excel spreadsheet and the resulting SAS data set?
A. the number of rows to be read from the Excel file
B. the number of columns to be read from the Excel file
C. multiple value types within a single column
D. multiple value types within a single row
Answer: C