A00-211 Exam Dumps - SAS Base Programming for SAS (r) 9

The following SAS program is submitted:

data combine;

prefix=’505’;

middle=’6465 ‘;

end=’09090’;

;

run;

Which statement successfully completes the program so that TOTAL has a value of 505-6465-

09090?

The following SAS program is submitted:

data test;

set sasuser.employees;

if 2 le years_service le 10 then

amount = 1000;

else amount = 0;

amount_per_year = years_service / amount

run;

What is the value of the variable AMOUNT_PER_YEAR if an employee has been with the company for one year?

The following SAS program is submitted:

data work.accounting;

set work.department;

length jobcode $ 12;

jobcode=’FAl’;

run;

The WORK.DEPARTMENT data set contains a character variable named JOBCODE with a length of 5. What is the result?

The following SAS program is submitted:

data one;

date = ‘04juI2005’d;

format date weekdate.; run;

proc print data = one; run;

What output is generated?

The following SAS program is submitted, creating the SAS data set ONE:

data one;

infile ‘file specification’;

input num chars$;

run;

ONE

NUMCHAR

----------------

123

323

177

The following SAS program is submitted:

proc print data = one;

where char = 23;

run;

What is output?

Which statement specifies that records 1 through 10 are to be read from the raw data file customer.txt?

The following SAS program is submitted:

data work.test;

set work.staff (keep = jansales febsales marsales);

array diff_sales{3} difsales1 - difsales3;

array monthly{3} jansales febsales marsales;

run;

What new variables are created?

Given the following raw data records in DATAFILE.TXT:

Which output is correct based on the submitted program?