Base Programmer A00-211 Reddit Questions

The following SAS program is submitted:

data WORK.ACCOUNTING;

set WORK.DEPARTMENT;

length EmpId $6;

CharEmpid=EmpId;

run;

If data set WORK.DEPARTMENT has a numeric variable EmpId. Which statement is true about the output dataset?

The following SAS program is submitted:

data work.totalsales (keep = monthsales{12} );

set work.monthlysales (keep = year product sales);

array monthsales {12} ;

do i=1 to 12;

monthsales{i} = sales;

end;

run;

The data set named WORK.MONTHLYSALES has one observation per month for each of five years for a total of 60 observations.

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

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?

Which of the following programs correctly invokes the DATA Step Debugger?