A00-212 exam

Which one of the following options controls the pagesize of a SAS data set?A . SIZE=B . BUFNO=C . BUFSIZE=D . PAGESIZE=View AnswerAnswer: C

The following SAS program is submitted: options reuse=YES; data sasuser RealEstate(compress=CHAR); set sasuser houses; run; What is the effect of the REUSE=YES SAS system option?A . It tracks and recycles free spaceB . It allows a permanently stored SAS data set to be replacedC . It allows users to access...

The SAS data set WORK.TEMPDATA contains the variables FMTNAME, START and LABEL and it consists of 10 observations. The following SAS program is submitted: Proc format cntlin=wor.tempdata; Run; What is the result of submitting the FORMAT procedure step?A . It uses the WORB . TEMPDATA SAS data set as input...

The variable attributes of SAS data sets ONE and TWO are shown below: ONE TWO # Variable Type Len Pos # Variable Type Len Pos 2 sales Num 8 8 2 budget Num 8 8 1 year Num 8 0 3 sales Char 8 16 1 year Num 8 0...

Given the SAS data set SAUSER.HIGWAY: SASUSER.HIGHWAY The following SAS program is submitted: %macro highway; proc sql nonprint; %let numgrp=6; select distinct status into: group1-: group&numgrp from sasuser.highway; quit; %do i=1 %to &numgrp; proc print data =sasuser.highway; where status ="&&group&I"; run; %end; %mend; %highway How many reports are produced?A ....

Which DICTIONARY table provides information on all the tables containing a variable named LASTNAME?A . DICTIONARB . COLUMNSC . DICTIONARD . VARIABLESE . DICTIONARF . MEMBERSG . DICTIONARH . TABLESView AnswerAnswer: A

Which one of the following is an advantage of creating and using a SAS DATA step view?A . It can store an index.B . It always accesses the most current data.C . It works quickly through multiple passes of the data.D . It is useful when the underlying data file...

Which of the following statement(s) in the DATASETS procedure alters the name of a SAS data set stored in a SAS data library?A . RENAME statement onlyB . CHANGE statement onlyC . MODIFY and RENAME statementsD . MODIFY and CHANGE statementsView AnswerAnswer: B

Given the data set SASHELP.CLASS: SASHELP.CLASS NAME AGE Mary 15 Philip 16 Robert 12 Ronald 15 The following SAS program is submitted: %let value = Philip; proc print data = sashelp.class; <insert WHERE statement here> run; Which WHERE statement successfully completes the program and procedures a report?A . Where upcase(name)=%upcase(&value);B...

The following SAS program is submitted: %macro location; data _null_; call symput ('dept','sales'); run; %let country=Germany; %put_global_; %mend; %let company = ABC; %location; Which macro variables are written to the SAS log?A . COMPANY and DEPT onlyB . COMPANY, COUNTRY and DEPTC . COMPANY OnlyD . COMPANY and COUNTRY onlyView...