Question 56
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?

Which TABLES option(s) would be used to eliminate the row and column counts and just see the frequencies and percents?
Question 57
Which one of the following is true when SAS encounters a data error in a DATA step?
Question 58
A raw data file is listed below:
RANCH,1250,2,1, Sheppard Avenue,"$64,000"
SPLIT,1190,1,1, Rand Street,"$65,850"
CONDO,1400,2,1.5, Market Street,"80,050"
TWOSTORY,1810,4,3, Garris Street,"$107,250"
RANCH,1500,3,3, Kemble Avenue,"$86,650"
SPLIT,1615,4,3, West Drive,"94,450"
SPLIT,1305,3,1.5, Graham Avenue,"$73,650"
The following SAS program is submitted using the raw data file as input:
data work.condo_ranch;
infile 'file-specification' dsd;
input style $ @;
if style = 'CONDO' or style = 'RANCH';
input sqfeet bedrooms baths street $
price: dollar10.;
run;
How many observations will the output data set contain?
RANCH,1250,2,1, Sheppard Avenue,"$64,000"
SPLIT,1190,1,1, Rand Street,"$65,850"
CONDO,1400,2,1.5, Market Street,"80,050"
TWOSTORY,1810,4,3, Garris Street,"$107,250"
RANCH,1500,3,3, Kemble Avenue,"$86,650"
SPLIT,1615,4,3, West Drive,"94,450"
SPLIT,1305,3,1.5, Graham Avenue,"$73,650"
The following SAS program is submitted using the raw data file as input:
data work.condo_ranch;
infile 'file-specification' dsd;
input style $ @;
if style = 'CONDO' or style = 'RANCH';
input sqfeet bedrooms baths street $
price: dollar10.;
run;
How many observations will the output data set contain?
Question 59
The following SAS program is submitted:

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

If the value for the variable Jobcode is: PILOT2, what is the value of the variable Description?
Question 60
The SAS data sets WORK.EMPLOYEE and WORK.SALARY are listed below:
WORK.EMPLOYEE WORK.SALARY
fname age fname salary
Bruce 30 Bruce 25000
Dan 40 Bruce 35000
Dan 25000
The following SAS program is submitted:
data work.empdata;
merge work.employee
work.salary;
by fname;
totsal + salary;
run;
How many variables are output to the WORK.EMPDATA data set?
WORK.EMPLOYEE WORK.SALARY
fname age fname salary
Bruce 30 Bruce 25000
Dan 40 Bruce 35000
Dan 25000
The following SAS program is submitted:
data work.empdata;
merge work.employee
work.salary;
by fname;
totsal + salary;
run;
How many variables are output to the WORK.EMPDATA data set?
