Doing More with SAS Programming Quiz Answer. In this post you will get Quiz Answer Of Doing More with SAS Programming
Doing More with SAS Programming Quiz
Offered By ”SAS”
Week- 1
Controlling DATA Step Processing
1.
Question 1
Which statement is false concerning the compilation phase of the DATA step?
1 point
The program data vector (PDV) is created.
Initial values are assigned to the columns.
The descriptor portion of the output table is created.
The DATA step is checked for syntax errors.
=================================================
2.
Question 2
Which statement is not a compile-time-only statement?
1 point
SET
WHERE
KEEP
LENGTH
=================================================
3.
Question 3
Which statement is true concerning the execution phase of the DATA step?
1 point
An implied REINITIALIZE occurs at the bottom of the DATA step.
An implied OUTPUT occurs at the top of the DATA step.
Data is processed in the program data vector (PDV).
Columns read from the input table are set to missing when SAS returns to the top of the DATA step.
=================================================
4.
Question 4
Which PUTLOG statements create the following results in the SAS log?
12
Name=Alfred Height=69 Weight=112.5 Ratio=0.61 _ERROR_=0 _N_=1
Ratio=0.61
1 point
putlog _all_; putlog Ratio=;
putlog all; putlog Ratio=;
putlog all; putlog Ratio;
putlog _all_; putlog Ratio;
=================================================
5.
Question 5
How many rows and columns are in the output table ShippingZones given the following information?
The input table Shipping contains 5 rows and 3 columns (Product, BoxSize, and Rate).
12345678
data ShippingZones;
set Shipping;
Zone=1;
output;
Zone=2;
Rate=(Rate*1.5);
run;
1 point
10 rows and 3 columns
10 rows and 4 columns
5 rows and 4 columns
5 rows and 3 columns
=================================================
6.
Question 6
The sashelp.cars table contains 428 rows: 123 rows with Origin equal to Europe and 305 rows with Origin equal to other values.
How many rows will be in the Other table?
1234567
data Europe Other;
set sashelp.cars;
if Origin=’Europe’ then
output Europe;
output Other;
run;
1 point
428 rows
0 rows
123 rows
305 rows
=================================================
7.
Question 7
Which statement is false?
1 point
The DROP statement names the columns to exclude from the output table.
The KEEP= option in the DATA statement names the columns to include in the output table.
The KEEP statement names the columns to include from the input table.
The DROP= option in the SET statement names the columns to exclude from being read into the PDV.
=================================================
8.
Question 8
Which columns are in the final table work.boots?
7
data work.boots(drop=Product);
set sashelp.shoes(keep=Product Subsidiary Sales Inventory);
where Product=’Boot’;
drop Sales Inventory;
Total=sum(Sales,Inventory);
run;
1 point
Product, Subsidiary, Sales, and Inventory
Subsidiary and Total
Subsidiary
Product and Subsidiary
=================================================
9.
Question 9
What is the result of running the following DATA step?
6
data work.boots;
set sashelp.shoes(keep=Product Subsidiary);
where Product=’Boot’;
NewSales=Sales*1.25;
run;
1 point
The step produces work.boots with three columns.
The step produces an error because the Sales column is not read in from the sashelp.shoes table.
The step produces work.boots with four columns.
The step produces an error due to invalid syntax for the KEEP= option.
Week- 2
Summarizing Data
1.
Question 1
Which statement contains valid syntax for the RETAIN statement?
1 point
retain Year{2018};
retain Year*2018;
retain Year=2018;
retain Year 2018;
=================================================
2.
Question 2
Which statement is false concerning the sum statement?
1 point
The sum statement ignores missing values.
The sum statement initially sets the accumulator column to missing.
The sum statements adds a numeric value to an accumulator column.
The sum statement automatically retains the value of the accumulating column.
=================================================
3.
Question 3
What is the value of Count at the end of the third DATA step iteration?
12345
data newnums;
set nums;
retain Count 100;
Count+Tens;
run;
1 point
60
. (missing)
130
160
=================================================
4.
Question 4
What is the value of Count at the end of the third DATA step iteration?
1234
data newnums;
set nums;
Count+Tens;
run;
1 point
20
30
. (missing)
40
=================================================
5.
Question 5
Which step executes successfully without an error, given the input table sashelp.class?
1 point
123456
data new;
set sashelp.class;
where Sex=’M’;
Ratio=Height/Weight;
if Ratio>0.6;
run;
123456
data new;
set sashelp.class;
where Sex=’M’;
Ratio=Height/Weight;
where Ratio>0.6;
run;
12345
data new;
set sashelp.class;
Ratio=Height/Weight;
where Sex=’M’ & Ratio>0.6;
run;
123456
data new;
set sashelp.class;
if Sex=’M’;
Ratio=Height/Weight;
where Ratio>0.6;
run;
=================================================
6.
Question 6
Which statement is true given the following program?
1234
data work.student;
set sashelp.class;
by Name;
run;
1 point
The DATA step sorts the input table by the column Name.
An error is produced because the BY statement is not permitted in the DATA step.
The output table work.student contains a column named Last.Name.
The PDV contains a temporary variable named First.Name.
=================================================
7.
Question 7
What are the correct values for First.Name and Last.Name if the value of Name appears only once in the input table?
1234
data work.student;
set sashelp.class;
by Name;
run;
1 point
First.Name=0 and Last.Name=0
First.Name=1 and Last.Name=1
First.Name=0 and Last.Name=1
First.Name=1 and Last.Name=0
=================================================
8.
Question 8
Which DATA step statement indicates to continue processing the last row of a BY group?
1 point
if Last.JobTitle;
where First.JobTitle=1;
where Last.JobTitle=1;
if First.JobTitle;
=================================================
9.
Question 9
Which statement needs to be added to the DATA step to reset the value of Total for each new BY group?
12345678
data RegionTotal;
set Sales;
by Region;
… ADD STATEMENT HERE …
Total+Sales;
if Last.Region=1 then output;
run;
1 point
Total=0;
if First.Region=1 then Total=0;
if First.Region=0 then Total=0;
if Last.Region=0 then Total=0;
=================================================
10.
Question 10
What are the values for First.City and Last.City for the third row of the input table given the following information?
1234
data StatePopulation;
set Population;
by State City;
run;
1 point
First.City=1 and Last.City=1
First.City=0 and Last.City=0
First.City=1 and Last.City=0
First.City=0 and Last.City=1
Week- 3
Manipulating Data with Functions
1.
Question 1
Functions and CALL routines both return a value that must be used in an assignment statement or expression.
1 point
True
False
=================================================
2.
Question 2
Which function calculates the average of the columns Week1, Week2, Week3, and Week4?
1 point
mean(of Week1, Week4)
mean(Week1-Week4)
mean(of Week1-Week4)
mean(Week1, Week4)
=================================================
3.
Question 3
Which expression rounds each value of Sales to the nearest hundredth (or two decimal places)?
1 point
round(Sales, 2)
round(Sales, .01)
round(Sales, dollar10.2)
round(Sales)
=================================================
4.
Question 4
Which function could be used to remove the non-numeric symbols in Phone?
1 point
COMPBL
COMPRESS
SCAN
FIND
=================================================
5.
Question 5
Which statement reads CityCountry and correctly assigns a value to Country?
1 point
Country=scan(CityCountry, 2, ‘, ‘);
Country=scan(CityCountry, -1);
Country=scan(CityCountry, 2, ‘,’);
Country=scan(CityCountry, 2);
=================================================
6.
Question 6
Which expression creates CityCountry?
1 point
cats(“, “, City, Country)
cat(City, “, “, Country)
catx(“, “, City, Country)
catx(City, “, “, Country)
=================================================
7.
Question 7
How many rows are written to output based on the following statement?
if find(Location, “Oahu”, “i”) > 0 then output;
1 point
1
0
5
3
=================================================
8.
Question 8
Which of the following functions can convert the values of the numeric variable Level to character values?
1 point
put(3., Level)
put(Level, 3.)
input(3., Level)
input(Level, 3.)
=================================================
9.
Question 9
Which of the following functions converts the character values of Base to numeric values?
1 point
put(comma10.2, Base)
put(Base, comma10.2)
input(Base, comma10.2)
input(comma10.2, Base)
=================================================
10.
Question 10
Which step is not required when converting a character column named Date to a numeric SAS date column with the same name?
1 point
Specify an appropriate informat in the INPUT function.
Format the new numeric Date column.
Use the INPUT function to read the renamed CharDate character column and create a numeric column named Date.
Rename the Date column to a new name, such as CharDate.
Week- 4
Creating and Using Custom Formats
1.
Question 1
Which of the following contains valid syntax?
1 point
12
value $grades. ‘A’=’Excellent’
‘B’=’Good’;
12
value qtrfmt 1,2,3=’First’
4,5,6=’Second’;
12
value qtrfmt ‘1’-‘3’=’First’
‘4’-‘6’=’Second’;
12
value grades ‘A’=’Excellent’
‘B’=’Good’;
=================================================
2.
Question 2
What is the formatted value for the value of 100 given the following step?
6
proc format;
value rates 1-<100=’low’
100<-<200=’medium’
200-300 =’high’
other =’out of range’;
run;
1 point
medium
out of range
high
low
=================================================
3.
Question 3
In the FORMAT procedure, you specify the name of the format and the name of the column that will use the custom format.
1 point
True
False
=================================================
4.
Question 4
What is the correct formatted output given the following PROC FORMAT step and the input table?
12345
proc format;
value $answer ‘1’=’Yes’
‘2’=’No’
‘other’=’Not Answered’;
run;
1 point
=================================================
5.
Question 5
Which of the following does not have proper syntax for specifying a range in the VALUE statement?
1 point
‘A’ – ‘C’
500-<700
500>-700
‘Horse’ – ‘Mouse’
=================================================
6.
Question 6
Which statement is true concerning options for the FORMAT procedure?
1 point
The FMTLIB option specifies the library to store the format.
The CNTLIN= option specifies a table from which formats are built.
The FMTLIB option goes in the SELECT statement.
The CNTLIN= option goes in the VALUE statement.
=================================================
7.
Question 7
Which columns are required in an input table to create a format based on numeric ranges?
1 point
FMTNAME, START, END, and LABEL
FORMAT, START, LAST, NAME, and TYPE
FORMAT, START, END, and NAME
FMTNAME, START, and LABEL
=================================================
8.
Question 8
Which option in the PROC FORMAT statement specifies a library to store a custom format?
1 point
LIBRARY=
STORE=
CATALOG=
FMTLIB=
=================================================
9.
Question 9
What is the default search order that is used to locate formats?
1 point
WORK.FORMATS > LIBRARY.FORMATS
SASHELP.FORMATS > LIBRARY.FORMATS
SASHELP.FORMATS > WORK.FORMATS
LIBRARY.FORMATS > WORK.FORMATS
=================================================
10.
Question 10
Which of the following contains valid syntax for the FMTSEARCH= option?
1 point
options fmtsearch=sashelp;
options fmtsearch=[sashelp.fmts sashelp];
options fmtsearch=sashelp.formats;
options fmtsearch=(sashelp sashelp.fmts);
Week- 5
Combining Tables
1.
Question 1
Which statement is true concerning concatenating tables?
1 point
All tables must have the same number of columns.
Missing values are generated for columns that exist in one input table and not in another.
Columns in all tables must have matching names and lengths.
Tables must be in the same library.
=================================================
2.
Question 2
Which statement renames the existing column Location in work.travel as Destination?
1 point
set vacations travel(rename=(Location=Destination));
set vacations travel(rename(Destination=Location));
set vacations(rename=(Location=Destination)) travel;
set vacations travel(rename=(Destination=Location));
=================================================
3.
Question 3
Which statement is true concerning merging with matching rows?
1 point
Only two input tables can be specified in the MERGE statement.
The MERGE statement must refer to temporary input tables.
The columns in the BY statement can be in only one of the tables.
The input tables must be sorted by the columns in the BY statement.
=================================================
4.
Question 4
How many rows are in the both output table given the following input tables and code?
12345
data both;
merge agetable
foodtable;
by Name;
run;
1 point
two
four
three
five
=================================================
5.
Question 5
How many rows are in the empsauc output table given the following input tables and code?
12345
data empsauc;
merge empsau phonec;
by EmpID;
run;
1 point
four
three
two
five
=================================================
6.
Question 6
What is the result of the following step?
1234
data combine;
merge donors1 donors2;
by ID;
run;
1 point
The step fails because the BY column ID is not properly sorted.
The table combine is created with four columns and five rows.
The step fails because Units is in both tables and not the BY column.
The step fails because of duplicate ID values within the donors1 table.
=================================================
7.
Question 7
Which statement best describes the rows in the output table?
123456
data bonuses;
merge managers(in=M)
staff(in=S);
by EmpID;
if M=0 and S=1;
run;
1 point
only the rows from managers that have no match in staff
only the rows from staff that have no match in managers
all the matching and nonmatching rows from both managers and staff
all the matching rows from both managers and staff
=================================================
8.
Question 8
What are the values of C and A during the third iteration of the DATA step?
12345
data client_amount;
merge clients(in=C)
amounts(in=A);
by Name;
run;
1 point
C=1 and A=0
C=0 and A=0
C=0 and A=1
C=1 and A=1
=================================================
9.
Question 9
What is the value of Location in the output table?
1234
data locALL;
merge loc1 loc2 loc3;
by Code;
run;
1 point
France
Italy
Belgium
France Belgium Italy
=================================================
10.
Question 10
You can use one DATA step to merge the following three tables:
1 point
True
False
Week- 6
Processing Repetitive Code
1.
Question 1
Which output table does the following step produce?
6
data Earnings(keep=Qtr Earned);
Amount=1000; Rate=.075/4;
do Qtr=1 to 4;
Earned+(Amount+Earned)*Rate;
end;
run;
1 point
=================================================
2.
Question 2
Which statement is true regarding the iterative DO loop?
DO index-column = start TO stop <BY increment>;
1 point
The index column is not in the final table unless specifically kept.
The index column is incremented at the bottom of each DO loop.
The start and stop values can be character or numeric values.
If an increment value is not specified, the default increment is 0.
=================================================
3.
Question 3
How many rows are in the savings output table given the following input table and code? Note: Amount is a numeric column.
12345678910
data work.savings;
set pg2.savings;
Savings=0;
do Year=1 to 5;
do qtr=1 to 4;
Savings+Amount;
Savings+(Savings*0.02/12);
end;
end;
run;
1 point
20
5
4
1
=================================================
4.
Question 4
What is the final value of Year given the following step?
123456
data invest;
do Year=2010 to 2019;
Capital+5000;
Capital+(Capital*.03);
end;
run;
1 point
. (missing)
2020
2019
2010
=================================================
5.
Question 5
Which of the following statements contains valid syntax?
1 point
do while (Year>2025);
do 1 to 10 by 2;
do date=’01JAN2019′ to ’31JAN2019′;
do until Earnings<=100000;
=================================================
6.
Question 6
How many rows are in the bikeinfo2 output table given the following input table and code?
123456789
data bikeinfo2;
set bikeinfo;
do month=1 to 3;
do week=1 to 4;
bike=bike+2;
end;
output;
end;
run;
1 point
3
6
24
12
2
=================================================
7.
Question 7
What is the value of x at the completion of the DATA step?
123456
data test;
x=15;
do until(x>12);
x+1;
end;
run;
1 point
16
. (missing)
13
15
=================================================
8.
Question 8
Which statement is false?
1 point
The DO UNTIL loop executes until a condition is true.
The DO UNTIL loop checks the condition at the bottom of the loop.
The DO WHILE loop checks the condition at the top of the loop.
The DO WHILE loop always executes at least one time.
=================================================
9.
Question 9
Which of the following statements contains valid syntax?
1 point
do Year=2018 to 2018 or until (Earnings<=100000);
do week=1 to 52 do until (Mileage ge 2750);
do Age=10 to 14 and while (Weight<150);
do Increase=5 to 10 while (temperature Lt 102);
=================================================
10.
Question 10
Which output table does the following step produce?
123456
data test;
bike=10;
do day=1 to 7 while (bike lt 13);
bike=bike+2;
end;
run;
1 point
Week- 7
Restructuring Tables
1.
Question 1
Which is the better description for the following table?
1 point
wide table
narrow table
=================================================
2.
Question 2
When using the DATA step to go from a wide table to a narrow table, which statement is needed for creating multiple rows from a single row?
1 point
OUTPUT
WIDE
RETAIN
NARROW
=================================================
3.
Question 3
How many rows will be in the final table if work.airwide contains three rows?
12345678910111213
data work.airnarrow;
set work.airwide;
Month=’Jan’;
Air=Jan;
output;
Month=’Feb’;
Air=Feb;
output;
Month=’Mar’;
Air=Mar;
1 point
12
9
6
3
=================================================
4.
Question 4
When using the DATA step to go from a narrow table to a wide table, the KEEP statement is needed to hold values in the PDV across multiple iterations of the DATA step.
1 point
True
False
=================================================
5.
Question 5
Which statement needs to be added to the DATA step to include only the last row per value of Year in the output table?
123456789
data work.airwide2(keep=Year Jan Feb Mar);
set work.airnarrow;
by Year;
retain Jan Feb Mar;
if Month=’Jan’ then Jan=Air;
else if Month=’Feb’ then Feb=Air;
else if Month=’Mar’ then Mar=Air;
… insert statement here …
run;
1 point
if Last.Year=0 then output;
output;
if Last.Year=1 then output;
if Last then output;
=================================================
6.
Question 6
Which statement is false concerning the TRANSPOSE procedure?
1 point
Use a BY statement to sort the data while transposing.
Use a VAR statement to specify the character and numeric columns to transpose.
By default, numeric columns are transposed.
Columns are transposed into rows.
=================================================
7.
Question 7
Which statements are needed in a PROC TRANSPOSE step for the following example (narrow to wide)?
1 point
123
by Day;
id Meal;
var Food;
123
by Day;
id Food;
var Meal;
12
by Day;
var Meal Food;
12
id Day;
var Food Meal;
=================================================
8.
Question 8
Which statement or statements are needed in a PROC TRANSPOSE step for the following example (wide to narrow)?
1 point
12
id Day;
var Breakfast Lunch Dinner;
1
id Day;
1
var Breakfast Lunch Dinner;
1
by Day;
=================================================
9.
Question 9
Which option is needed in the PROC TRANSPOSE statement to rename the _NAME_ column as shown in the output table?
1 point
rename=Meal
prefix=Meal
_name_=Meal
name=Meal
=================================================
10.
Question 10
Which option is needed in the PROC TRANSPOSE statement to rename the COL columns as shown in the output table?
1 point
out=meals2(prefix=(COL1=Day7 COL2=Day1))
out=meals2(name=(COL1=Day7 COL2=Day1))
out=meals2(COL1=Day7 COL2=Day1)
out=meals2(rename=(COL1=Day7 COL2=Day1))