SAS Institute A00-212 dumps - 100% Pass Guarantee!

Which macro statement would remove the macro variable mv_Info from the symbol table?

A. %symercase Mv_Info;

B. %symdel and Mv_Info;

C. %symdel Mv_Info;

D. %mdelete and Mv_Info;

Given the SAS data set ONE:

ONE

DIVISION SALES

A 1234

A 3654

B 5678

The following SAS program is submitted:

Data_null_;

Set one;

By divition;

If first.division then

Do;

%let mfirst=sales;

end;

run;

What is the value of the macro variable MFRIST when the program finishes execution?

A. 1234

B. sales

C. 5678

D. null

Given the following partial SAS log:

Which SQL procedure statement generated this output?

A. DECREASE TABLE SASHELP.CLASS;

B. CONTENTS TABLE SASHELP.CLASS;

C. DESCRIBE TABLE=SASHELP.CLASS;

D. ATTRIBUTE TABLE=SASHELP.CLASS

The following SAS program is submitted:

proc datasets lib = testdata;

modify one;

label num = 'Number';

format num 4.;

quit;

Which one of the following SQL programs produces the same results as the above DATASETS procedure?

A. proc sql; modify table testdata.one num format = 4. label = 'Number'; quit;

B. proc sql; alter table testdata.one modify num format = 4. label = 'Number'; quit;

C. proc sql; modify table testdata.one alter num format = 4. label = 'Number'; quit;

D. proc sql; alter table testdata.one modify num (format = 4. label = 'Number'); quit;

Given the following SAS data set ONE: ONE JOB LEVEL SALARY ACC 2 300 SEC 1 100 SEC 2 200 MGR 3 700 ACC 1 . ACC 3 . MGR 2 400 The following SAS data set TWO is created: TWO JOB LEVEL BONUS ACC 2 30 MGR 3 70 MGR 2 40 Which one of the following SAS programs creates data set TWO?

A. proc sql; create table two as select job, level, salary * 0.1 as bonus from one where bonus > 20; quit;

B. proc sql; create table two as select job, level, salary * 0.1 as bonus from one where salary > 20; quit;

C. proc sql; create table two as select job, level, salary * 0.1 as bonus from one where calculated salary * 0.1 > 20; quit;

D. proc sql;D.proc sql; create table two as select job, level, salary * 0.1 as bonus from one where calculated bonus > 20; quit;