A00-212 exam

The following SAS program is submitted: data temp; length 1 b 3 x; infile 'file reference'; input a b x; run; What is the result?A . The data set TEMP is not created because variables A and B have invalid lengthsB . The data set TEMP is created, but variable...

Given the following SAS data sets ONE and TWO: ONE TWO YEAR QTR BUDGET YEAR QTR SALES 2001 3 500 2001 4 300 2001 4 400 2002 1 600 2002 1 700 The following SAS program is submitted: proc sql; select one.*, sales from one, two; quit; Which one of...

When is it appropriate to create indexes on a SAS data set for efficient processing?A . if small subsets of data are often retrievedB . if the key variable has very few unique valuesC . if the data are often used for BY group processingD . if the SAS data...

The following SAS program is submitted: %macro test(var); %let jobs = BLACKSMITH WORDSMITH SWORDSMITH; %let type = %index(&jobs,&var); %mend; %test(SMITH) Which one of the following is the resulting value of the macro variable TYPE?A . 0B . 3C . 6D . nullView AnswerAnswer: C

The following SAS program is submitted: data temp; array points {2,3} (10,15,20,25,30,35); run; What impact does the ARRAY statement have in the Program Data Vector (PDV)?A . No variable are created in the PDVB . The variables named POINTS10, POINTS15, POINTS20, POINTS25, POINTS30, POINTS35 are created in the PDVC ....

Which one of the following statements is true?A . The WHERE statement can be executed conditionally as part of an IF statement.B . The WHERE statement selects observations before they are brought into the PDD . The subsetting IF statement works on observations before they are read into the PDF...

The following SAS program is submitted: %let lib = %upcase(sasuser); proc sql; select nvar from dictionary.tables where libname = "&lib"; quit; Given that several SAS data sets exist in the SASUSER library, which one of the following is generated as output?A . no result setB . a syntax error in...

Given the following SAS data set ONE: ONE COUNTRY CITY VISIT USA BOSTON 10 UK LONDON 5 USA DALLAS 10 UK MARLOW 10 USA BOSTON 20 UK LONDON 15 USA DALLAS 10 The following SAS program is submitted: proc sql; select country, city, sum(visit) as TOTAL from one group by...

The following SAS program is submitted: %let first=yourname; %let last=first; %put &&&last; What is written to the SAS Log?A . FirstB . YournameC . &&FirstD . &yournameView AnswerAnswer: B

The following SAS program is submitted: %macro execute; <insert statement here> proc print data = sasuser.houses; run; %end; %mend; Which of the following completes the above program so that it executes on Tuesday?A . %if &sysday = Tuesday %then %do;B . %if &sysday = 'Tuesday' %then %do;C . %if "&sysday"...