Free A00-211 Exam Dumps Preview

The following SAS program is submitted:
options pageno = 1;
proc print data = sasuser.houses;
run;
proc means data = sasuser.shoes;
run;

The report created by the PRINT procedure step generates 5 pages of output.

What is the page number on the first page of the report generated by the MEANS procedure step?

The following program is submitted:

proc contents data=_all_;

Which statement best describes the output from the submitted program?

The following SAS program is submitted:

What is the value of the second variable in the data set WORK.AUTHORS?

The following SAS program is submitted:

data work.january;
set work.allmonths (keep = product month num_sold cost);
if month = 'Jan' then output work.january;
sales = cost * num_sold;
keep = product sales;
run;

Which variables does the WORK.JANUARY data set contain?

Given the contents of the raw data file TYPECOLOR:

----I----10---I----20---I----30
Daisyyellow
The following SAS program is submitted:
data flowers;
infile `typecolor';
input type$ 1-5+1 color$;
run;

What are the values of the variables TYPE and COLOR?

After a SAS program is submitted, the following is written to the SAS log:

What changes should be made to the KEEP statement to correct the errors in the LOG?

Which statement describes a characteristic of the SAS automatic variable_ERROR_?

Given the SAS data set WORK.TEMPS with numeric variables Day and Temp and character variable Month:

The following SAS program is submitted:

proc sort data=WORK.TEMPS;
by Day descending Month;
run;

proc print data=WORK.TEMPS;
run;

Which output is correct?

The SAS data set EMPLOYEE_INFO is listed below:

IDNumber Expenses
2542 100.00
3612 133.15
2198 234.34
2198 111.12

The following SAS program is submitted:
proc sort data = employee_info;
run;

Which one of the following BY statements completes the program and sorts the data sequentially by descending expense values within each descending IDNUMBER value?

Given the SAS data set PRICES:

PRICES
Prodid price producttype sales returns
K125 5.10 NETWORK 15 2
B132S 2.34 HARDWARE 300 10
R18KY2 1.29 SOFTWARE 25 5
3KL8BY 6.37 HARDWARE 125 15
DY65DW 5.60 HARDWARE 45 5
DGTY23 4.55 HARDWARE 67 2
The following SAS program is submitted:
data hware inter cheap;
set prices(keep = productype price);
if producttype = `HARDWARE' then output hware; else if producttype = `NETWORK' then output
inter;
if price le 5.00;
run;
if producttype = `HARDWARE' then output hware; else if producttype = `NETWORK' then output
inter;
if price le 5.00;
run;

How many observations does the HWARE data set contain?

Given the raw data file AMOUNT:

----I---- 10---I----20---I----30
$1,234
The following SAS program is submitted:
data test;
infile `amount';
input@1 salary 6.;
if_error_then description = `Problems';
else description = `No Problems';
run;

What is the result?

The following SAS program is submitted:

footnote1 `Sales Report for Last Month';
footnote2 `Selected Products Only';
footnote3 `All Regions';
footnote4 `All Figures in Thousands of Dollars';
proc print data = sasuser.shoes;
footnote2 `All Products';
run;

Which footnote(s) is/are displayed in the report?

The following SAS program is submitted:

data work.test;
array agents{4} $ 12 sales1 - sales4;
run;

Which one of the following represents the variables that are contained in the output data set?

The following SAS program is submitted:

What is the initial value of the variable Total in the following program?

Consider the data step:

Which of the following assignment statements for variable group are functionally equivalent to the original statement used in the above data step?

Given the following raw data records in DATAFILE.TXT:

Which output is correct based on the submitted program?

The following SAS DATA step is submitted:

libname temp 'SAS-data-library';
data temp.report;
set sasuser.houses;
newvar = price * 1.04;
run;

Which one of the following statements is true regarding the program above?

The following SAS DATA step executes on Monday, April 25, 2000:

data newstaff;
set staff;
start_date = today();
run;

Which one of the following is the value of the variable START_DATE in the output data set?

A user-defined format has been created using the FORMAT procedure.

Where is it stored?

Given the following code:

proc print data=SASHELP.CLASS(firstobs=5 obs=15);
where Sex='M';
run;

How many observations will be displayed?

The data set WORK.REALESTATE has the variable LocalFee with a format of 9. and a variable CountryFee with a format of 7.;

The following SAS program is submitted:

What are the formats of the variables LOCALFEE and COUNTRYFEE in the output dataset?

The following SAS program is submitted:

proc sort data = sasuser.houses out = houses;
by style;
run;
proc print data = houses;

run;
Click on the Exhibit button to view the report produced.
style bedrooms baths price
CONDO 2 1.5 80050
3 2.5 79350
4 2.5 127150
2 2.0 110700
RANCH 2 1.0 64000
3 3.0 86650
3 1.0 89100
1 1.0 34550
SPLIT 1 1.0 65850
4 3.0 94450
3 1.5 73650
TWOSTORY 4 3.0 107250
2 1.0 55850
2 1.0 69250
4 2.5 102950

Which of the following SAS statement(s) create(s) the report?

Which program will create a comma delimited raw data file (CSV)?

The following SAS program is submitted:

libname sasdata 'SAS-data-library';
data test;
set sasdata.chemists (keep = job_code);
if job_code = 'chem3'
then description = 'Senior Chemist';
run;

The variable JOB_CODE is a character variable with a length of 6 bytes.

Which one of the following is the length of the variable DESCRIPTION in the output data set?

The observations in the SAS data set WORK.TEST are ordered by the values of the variable SALARY.
The following SAS program is submitted:

proc sort data = work.test out = work.testsorted;
by name;
run;

Which one of the following is the result of the SAS program?

Given the following raw data record:

07Jan2005

Which INFORMAT reads this raw data and stores it as a SAS date value?

Consider the following data step:

The computed variables City and State have their values assigned using two different methods, a RETAIN statement and an Assignment statement.

Which statement regarding this program is true?

Which step displays a listing of all the data sets in the WORK library?

Given the following raw data records:

The following output is desired:

Which SAS program correctly reads in the raw data?

The contents of the SAS data set PERM.JAN_SALES are listed below:

VARIABLE NAME TYPE
idnum character variable
sales_date numeric date value

A comma delimited raw data file needs to be created from the PERM.JAN_SALES data set. The SALES_DATE values need to be in a MMDDYY10 form.

Which one of the following SAS DATA steps correctly creates this raw data file?

Which statement is true concerning the SAS automatic variable_ERROR_?

The following SAS program is submitted:

Data_null_;
set old;
put sales 1 sales2;
run;

Where is the output written?

The following SAS DATA step is submitted:

data work.accounting;
set work.department;
length jobcode $ 12;
run;

The WORK.DEPARTMENT SAS data set contains a character variable named JOBCODE with a length of
5.

Which one of the following is the length of the variable JOBCODE in the output data set?

Given the SAS data set PERM.STUDENTS:

PERM.STUDENTS NAME AGE
--------- ------- Alfred 14
Alice 13
Barbara 13
Carol 14

The following SAS program is submitted:
libname perm `SAS data library';
data students;
set perm.students;
file `file specification';
put name $ age;
<insert statement here>
run;

The following double-spaced file is desired as output

Alfred 14
Alice 13
Barbara 13
Carol 14

Which statement completes the program and creates the desired file?

The following SAS program is submitted:

data work.one;
x = 3;
y = 2;
z = x ** y;
run;

Which one of the following is the value of the variable Z in the output data set?

The following SAS program is submitted:

What will the data set WORK.TEST contain?

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

data one;
infile `file specification';
input num chars$;
run;
ONE
NUM CHAR
------- ---------
1 23
3 23
1 77

The following SAS program is submitted:

proc print data = one;
where char = 23;
run;

What is output?

Given the data sets below:

WORK.EMP with variables:

WORK.NEWHIRE with variables:

The following SAS program is submitted:

The SAS data set WORK.EMP has 50 observations, and the data set WORK.NEWHIRE has 4 observations.

How many variables will the data set WORK.ALLEMP contain?

The following SAS program is submitted:

What types of variables are DayOfMonth, MonthOfYear, and Year?

The following SAS program is submitted:

data work.test;
First = 'Ipswich, England';
City = substr(First,1,7);
City_Country = City!!', '!!'England';
run;

Which one of the following is the value of the variable CITY_COUNTRY in the output data set?

Given the following data set WORK.TOYS:

The following SAS program s submitted:

data WORK.GROUPS;
set WORK.TOYS;
if Product="Cards" then Group_Desc="Indoors";
else if Product in ("Drum", "Recorder") then Group_Desc="Instruments";
else if Product="Ball" then Group_Desc="Outdoors";
run;
proc print data=WORK.GROUPS noobs;
run;

Which output is produced?