A00-211 SAS Base Programming for SAS (r) 9 Questions and Answers

The following SAS program is submitted:

If the value for the variable Jobcode is: PILOT2, what is the value of the variable Description?

This questions will ask you to provide two missing variable names.

The following SAS program is submitted:

data WORK.TOTAL;

set WORK.SALARY;

by Department Gender;

if First. then Payroll=0

Payroll+Wagerate;

if Last.;

run;

The SAS data set WORK.SALARY is currently ordered by Gender within Department. Which inserted code will accumulate subtotals for each Gender within Department?

The contents of the raw data file SIZE are listed below:

--------10-------20-------30

72 95

The following SAS program is submitted:

data test;

infile 'size';

input @1 height 2. @4 weight 2;

run;

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

The following SAS program is submitted:

data work.new;

mon = 3;

day = 23;

year = 2000;

date = mdy(mon,day,year);

run;

Which one of the following is the value of the DATE variable?

The following SAS program is submitted:

What is the result?

The Excel workbook REGIONS.XLSX contains the following four worksheets:

EAST

WEST

NORTH

SOUTH

The following program is submitted:

libname MYXLS pcfiles path=’c:\regions.xlsx’;

Which PROC PRINT step correctly displays the NORTH worksheet?

Given the following raw data record:

07Jan2005

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

The following SAS program is submitted:

libname rawdata1 'location of SAS data library';

filename rawdata2 'location of raw data file';

data work.testdata;

infile

input sales1 sales2;

run;

Which one of the following is needed to complete the program correctly?

Given the SAS data set AGES:

AGES

AGE

---------

The variable AGE contains character values. The following SAS program is submitted:

data subset;

set ages;

where age> 12;

run;

How many observations are written out to the data set SUBSET?

Which ODS statement option terminates output being written to an HTML rile?

The following SAS program is submitted:

data work.total;

set work.salary(keep = department wagerate);

by department;

if first.department

then payroll = 0;

payroll + wagerate;

if last.department

run;

The SAS data set WORK.SALARY, currently ordered by DEPARTMENT, contains 100 observations for each of 5 departments.

What is the result?

The following output is created by the FREQUENCY procedure:

Which TABLES option(s) would be used to eliminate the row and column counts and just see the frequencies and percents?

The contents of the raw data file PRODUCT are listed below:

--------10-------20-------30

24613 $25.31

The following SAS program is submitted:

data inventory;

infile 'product';

input idnum 5. @10 price;

run;

Which one of the following is the value of the PRICE variable?

Given the SAS data set QTR 1_REVENUE:

destinationrevenue

YYZ53634

FRA62129

FRA75962

RDU76254

YYZ82174

The following SAS program is submitted:

proc sort data = qtr1_revenue;

by destination descending revenue; run;

What is the first observation in the output data set?

Given the SAS data set EMPLOYEE INFO:

EMPLOYEE_INFO

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 BY statement completes the program and sorts the data sequentially by ascending expense values within each ascending IDNUMBER value?

Given the raw data file EMPLOYEE:

----I----1 0---I----20---I----30

Ruth 39 11

Jose 32 22

Sue 30 33

John 40 44

The following SAS program is submitted:

data test;

infile ‘employee’;

input employee_name $ 1-4;

if employee_name = ‘Ruth’ then input idnum 10-11;

else input age 7-8;

run;

What value does the variable IDNUM contain when the name of the employee is “Ruth”?

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?

Given the SAS data set WORK.EMP_NAME:

Given the SAS data set WORK.EMP_DEPT:

The following program is submitted:

How many observations are in data set WORK.ALL after submitting the program?

Given the contents of the raw data file TYPECOLOR.DAT:

The following SAS program is submitted:

What are the values of the variables Type and Color?

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?

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

Given the SAS data set WORK.TEMPS:

The following program is submitted:

Which output is correct?

The following SAS program is submitted:

data one;

addressl = ‘214 London Way’;

run;

data one;

set one;

address = tranwrd(address1, ‘Way’, ‘Drive’); run;

What are the length and value of the variable ADDRESS?

The following program is submitted:

proc contents data=_all_;

run;

Which statement best describes the output from the submitted program?

Given the raw data record in the file phone.txt:

Which SAS statement completes the program and results in a value of "James Stevens" for the

variableFullName?

The value 110700 is stored in a numeric variable named SALARY.

Which FORMAT statement displays the value as $110,700.00 in a report?

The following SAS program is submittad:

data work.sales;

do year = 1 to 5;

do month=1 to 12;

x+1;

output

end;

end;

run;

How many observations are written the WORK SALES data set?

The following SAS program is submitted:

Data WORK.COMPRESS;

ID = ‘1968 05-10 567’;

NewID = compress (ID, “-“);

run;

What will the value of NewID be in the WORK.COMPRESS data set?

Given the SAS data set WORK.EMP_NAME:

Given the SAS data set WORK.EMP_DEPT:

The following program is submitted:

How many observations are in data set WORK.ALL after submitting the program?

Enter your numeric answer in the space below.

This question will ask you to provide a line of missing code.

The following SAS program is submitted:

proc freq data = WORK.SALES;

run;

The following output is created by the FREQUENCY procedure:

Which statement was used to complete the above program that produced the output?

Given the SAS data set WORK.ORDERS:

The variable order_id is numeric; customer is character; and shipped is numeric, contains a SAS date value, and is shown with the DATE9. format. A programmer would like to create a new variable, ship_note, that shows a character value with the order_id, shipped date, and customer name. For example, given the first observation ship_note would have the value "Order 9341 shipped on 02FEB2009 to Josh Martin".

Which of the following statement will correctly create the value and assign it to ship_note?

The SAS data set WORK.ONE contains a numeric variable named Num and a character variable named Char:

The following SAS program is submitted:

What is output?

This question will ask you to provide a segment of missing code.

Given the SAS data set WORK.ONE:

The following SAS program is submitted:

The data set WORK.TWO is created, where Day would be the day of the month:

Which expression successfully completed the program and creates the variable Day?

The following SAS program is submitted:

proc means data = sasuser.houses std mean max;

var sqfeet;

run;

Which one of the following is needed to display the standard deviation with only two decimal places?

Unless specified, which variables and data values are used to calculate statistics in the MEANS procedure?

The following SAS program is submitted:

data work.test;

Author = 'Agatha Christie';

First = substr(scan(author,1,' ,'),1,1);

run;

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

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?