Free and Premium SAS Institute A00-212 Dumps Questions Answers

The following are values of the variable STYLE from the SAS data set

SASUSER.HOUSES:

SASUSERS.HOUSES

OBS STYLE

1 RANCH

2 SPLIT

3 CONDO

4 TWOSTORY

5 RANCH

6 SPLIT

7 SPLIT

The following SAS program is submitted:

proc sql noprint;

select distinct style

into :styles separated by ' '

from sasuser.houses

order by style;

quit;

Which one of the following is the value of the resulting macro variable?

The following SAS program is submitted:

options yearcutoff = 1950;

%macro y2kopt(date);

%if &date >= 14610 %then %do;

options yearcutoff = 2000;

%end;

%else %do;

options yearcutoff = 1900;

%end;

%mend;

data _null_ ;

date = "01jan2000"d;

call symput("date",left(date));

run;

%y2kopt(&date)

The SAS date for January 1, 2000 is 14610 and the SAS system option for

YEARCUTOFF is set to 1920 prior to submitting the above program.

Which one of the following is the value of YEARCUTOFF when the macro finishes execution?

Given the data set shown on the left, the SAS program on the right is submitted:

Which statement is true regarding the WORK.MISSING data set?

Given has SAS dataset ONE:

The following SAS program is submitted:

Proc sql;

from one;

quit;

The following output is desired:

Which SQL procedure clause completes the program and generates the desired output?

A data set stored on a network drive has the following characteristics:

• 14 Million observations
• 400 numeric variables
• 0 character variables of length 20
• Binary compression

A DATA Step query requires only 3 character and 15 numeric variables from this data set. What is the best way to reduce computer resource utilization in this DATA Step?

The following SAS program is submitted:

%macro test(var);

proc print data = sasuser.class;

where age > &var;

run;

%mend;

Which type of parameter is the macro variable VAR?

Which one of the following techniques concatenates data in SAS?

Which one of the following SAS procedures changes a permanent format of a variable stored in a SAS data set?

Given the following SAS data set named WORK.INTERNAT:

WORK.INTERNAT

LOCATION SUM

USA 30

EUR 40

The following SAS program is submitted:

%let LOC = Usa;

proc sql;

select *

from internat

where location = "&Loc";

quit;

Which one of the following is the result when the above code is executed on the above data set?

Assume today is Tuesday, July 23, 2002. Which one of the following statements submitted at the beginning of a SAS session assigns the value Tuesday, July 23, 2002 to the macro variable START?

CORRECT TEXT

The following SAS program is submitted:

%macro check(num=4);

%let result=%sysevalf(&num+0.5);

%put result is &result;

%mend;

%check(num=10)

What is the written to the SAS log?

The SAS set WORK CHECK has an index on the variable Code and the following SAS program is submitted.

proc sort data=WORK.CHECK;

by Code;

run;

What describes the result of submitting SAS program?

The following SAS program is submitted:

%let test=one;

%let one=two;

%let two=three;

%let three=last;

%put what displays is &&&&&test;

What is the written to the SAS log?

The following SAS program is submitted:

data new(bufsize = 6144 bufno = 4);

set old;

run;

What is the difference between the usage of BUFFSIZE= and BUFNO= options?

Given the following SAS data set ONE:

ONE

CATEGORY AGE SALARY BONUS

M 28 200 20

M 25 100 10

M 28 300 10

M 33 300 30

F 18 100 50

F 25 200 10

F 35 400 50

The following SQL program is submitted:

proc sql;

create table two as

select distinct age

from one

where age < 33;

quit;

How many rows are written to the SAS data set TWO?

Given the SAS data sets:

A SAS program is submitted and the following is written to SAS to:

What would allow the program to successfully execute without errors?

Given the following SAS program:

proc sql;

select product, type, sum(sales) as revenue

from one

group by product, type;

quit;

Which one of the following clauses should be added to the program to sort the output by PRODUCT and decreasing REVENUE?

In which one of the following SAS programs is the SAS data set index named CHAR1 always used?

Which one of the following statements is true?

The following SAS program is submitted:

%let a = cat;

%macro animal(a = frog);

%let a = bird;

%mend;

%animal(a = pig)

%put a is &a;

Which one of the following is written to the SAS log?

Which one of the following is true regarding the KEEP statement?

Consider the following SAS log:

229 data sasuser.ranch sasuser.condo / view = sasuser.ranch;

230 set sasuser.houses;

231 if style = 'RANCH' then output sasuser.ranch;

232 else if style = 'CONDO' then output sasuser.condo;

233 run;

NOTE: DATA STEP view saved on file SASUSER.RANCH.

NOTE: A stored DATA STEP view cannot run under a different operating system.

234

235 proc print data = sasuser.condo;

ERROR: File SASUSER.CONDO.DATA does not exist.

236 run;

NOTE: The SAS System stopped processing this step because of errors.

Which one of the following explains why the PRINT procedure fails?

Given the following SAS data set ONE:

ONE

GROUP SUM

A 765

B 123

C 564

The following SAS program is submitted:

data _null_;

set one;

call symput(group,sum);

run;

Which one of the following is the result when the program finishes execution?

Given the SAS data set WORK.ONE:

The following SAS program is submitted;

Which result set would be generated?

Which SET statements option names a variable that contains the number of the observation to read during the current iteration of the DATA step?

Which one of the following is the purpose of the IDXNAME= data set option?

The following SAS program is submitted:

proc contents data = testdata.one;

run;

Which one of the following SQL statements produces similar information about the column attributes as the above CONTENTS procedure?