[Jun-2024] A00-231 Dumps With 100% Verified Q&As - Pass Guarantee or Full Refund [Q17-Q35] : Actual Test Materials : http://blog.actualtests4sure.com

Q17. Given the raw data record DEPT:
—-|—-10—|—-20—|—-30
Printing 750
The following SAS program is submitted:
data bonus;
infile ‘dept’;
inputdept$ 1-11 number 13- 15;
<insert statement here>
run;
Which SAS statement completes the program and results in a value of ‘Printing750’ for the DEPARTMENT variable?

department = dept II number;

department = left(dept) II number;

department = trim(dept) number;

department=trim(dept)||put(number,3.);

Q18. 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?

The RETAIN statement is fine, but the value of City will be truncated to 8 bytes as theLENGTH statement has been omitted.

Both the RETAIN and assignment statement are being used to initialize new variables and are equally efficient. Method used is a matter of programmer preference.

The assignment statement is fine, but the value of City will be truncated to 8 bytes as theLENGTH statement has been omitted.

City’s value will be assigned one time, State’s value 5 times.

Q19. Which step sorts the observations of a permanent SAS data set by two variables and stores the sorted observations in a temporary SAS data set?

proc sort out=EMPLOYEES data=EMPSORT;by Lname and Fname;run;

proc sort data=SASUSER.EMPLOYEES out=EMPSORT;by Lname Fname;run;

proc sort out=SASUSER.EMPLOYEES data=WORK.EMPSORT;by Lname Fname;run;

proc sort data=SASUSER.EMPLOYEES out=SASUSER.EMPSORT;by Lname and Fname;run;

Q20. The following SAS program is submitted:
data temp.x;
set sasuser.y;
run;
What must be submitted prior to this SAS program for the program to execute successfully?

A LIBNAME statement for the libref TEMP only must be submitted.

A LIBNAME statement for the libref SASUSER only must be submitted.

LIBNAME statements for the librefs TEMP and SASUSER must be submitted.

No LIBNAME statement needs to be submitted.

Q21. A SAS program is submitted and the following SAS log is produced:
2 data gt100;
3 set ia.airplanes
4 if mpg gt 100 then output;
22 202
ERROR: File WORK.IF.DATA does not exist.
ERROR: File WORK.MPG.DATA does not exist.
ERROR: File WORK.GT.DATA does not exist.
ERROR: File WORK.THEN.DATA does not exist.
ERROR: File WORK.OUTPUT.DATA does not exist.
ERROR 22-322: Syntax error, expecting one of the following: a name,
a quoted string, (, ;, END, KEY, KEYS, NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_.
ERROR 202-322: The option or parameter is not recognized and will be ignored.
5 run;
The IA libref was previously assigned in this SAS session.
Which one of the following corrects the errors in the LOG?

Delete the word THEN on the IF statement.

Add a semicolon at the end of the SET statement.

Place quotes around the value on the IF statement.

Add an END statement to conclude the IF statement

Q22. 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 data set?

LocalFee has format of 9. and CountryFee has a format of percent7.2

LocalFee has format of 9. and CountryFee has a format of 7.

Both LocalFee and CountryFee have a format of percent7.2

The data step fails execution; there is no format for LocalFee.

Q23. The following program is submitted:

Why does the program fail?

The PAGENO option is invalid in the OPTIONS statement.

The RUN statement is missing after the FORMAT procedure.

The format name contains a period in the VALUE statement.

The LABEL option is missing from the PROC PRINT statement.

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

The following SAS program is submitted:
proc print data=WORK.ONE;
where Num=contains (1);
run;
Which output is generated?

No output is generated

Q25. Given the SAS data set WORKAWARDS:
WORK.AWARDS
FNAMEPOINTSMONTH
———————————-
Amy24
Amy17
Gerard33
Wang33
Wang112
Wang18
The following SAS program is submitted:
proc sort data = work.awards;
by descending fname points;
run;
How are the observations sorted?

ENAME POINTS MONTH Wang33 Wang112 Wang18 Gerard33 Amy24 Amy17

ENAME POINTS MONTH Amy24 Amy17 Gerard33 Wang33 Wang18 Wang112

ENAME POINTS MONTH Wang33 Wang18 Wang112 Gerard33 Amy24 Amy17

ENAME POINTS MONTH Wang112 Wang18 Wang33 Gerard33 Amy17 Amy24

Q26. The following SAS program is submitted once:

Which procedure output will appear in test.html?

Only the FREQ procedure output

Only the PRINT procedure output

No procedure output due to syntax errors

Both the PRINT procedure and FREQ procedure output

Q27. The SAS data set named WORK.SALARY contains 10 observations for each department, and is currently ordered by Department. The following SAS program is submitted:

Which statement is true?

The by statement in the DATA step causes a syntax error.

The statement Payroll+(MonthlyWageRate*12); in the data step causes a syntax error.

The values of the variable Payroll represent the monthly total for each department in the WORK.SALARY data set.

The values of the variable Payroll represent a monthly total for all values of WAGERATE in the WORK.SALARY data set.

Q28. The following code was modified to generate the results further below:
proc format;
value agegrp
low-12 =’Pre-Teen’
13-high = ‘Teen’;
run;
proc means data=SASHELP.CLASS;
var Height;
class Sex Age;
format Age agegrp.;
run;
The following results were generated to display only specific statistics and limit the decimals with the modification:

Which statement below was modified or added to generate the results above:

var Height / nobs min max mean maxdec=1;

proc means data=SASHELP.CLASS maxdec=1 ;

proc means data=SASHELP.CLASS min max mean maxdec=1;

output nobs min max mean maxdec=1;

Q29. The data set RALESTATE has the variable LOCALFEE with a format or 9. and a variable COUNTRYFEE with a format or 7.; The following SAS program is submitted:
data history;
format local fee country fee percent6.;
set realestate;
local fee = local fee / 100;
country fee = country fee / 100;
run;
What are the formats of the variables LOCALFEE and COUNTRYFEE in the output dataset?

LOCALFEE has format of 9. and COUNTRYFEE has a format of 7.

LOCALFEE has format of 9. and COUNTRYFEE has a format of percent6.

LOCALFEE has format of percent6. and COUNTRYFEE has a format of percent6.

The data step fails execution; there is no format for LOCALFEE

Q30. The following program is submitted:
proc sort data=SASUSER.PROJECTS out=PSORT;
by Code descending Date Cost;
run;
Which of the following is true concerning the submitted program?

The descending option applies to the variable Code.

The variable Code is sorted by ascending order.

The PSORT data set is stored in the SASUSER library.

The descending option applies to the Date and Cost variables.

Q31. The SAS data set WORK STAFF has three variables:
The following SAS program is submitted:

What is the length of the Name variable in the data set WORK STAFF_UPDATE?

Q32. The following SAS program is submitted:

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

Hemingway

Hemingwa

” (a missing value)

The program contains errors. No variables are created.

Q33. Consider the following data step:

In filtering the values of the variable X in data set WORK.OLD, what value new value would be assigned to X if its original value was a missing value?

X would get a value of 1.

X would get a value of 3.

X would retain its original value of missing.

This step does not run because of syntax errors.

Q34. 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?

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

What issue generated the error in the log?

There should have been commas between the variable names.

The list of variables should have been enclosed in parentheses.

A drop statement and a keep= data set option cannot both be used at the same time.

The syntax of the drop statement does not use an equals sign.