Free Practice SAS Institute A00-231 Exam Questions 2025

Stay ahead with 100% Free SAS 9.4 Base Programming -- Performance-based A00-231 Dumps Practice Questions

Page: 1 / 38

Total 186 Questions | Updated On: Apr 12, 2025

Add To Cart

Question 1

What are the temporary variables that can be helpful when debugging a DATA step?

A : _N_

B : _ERROR_

C : OBS

D : b and c only

Answer: D

Question 2

Scenario:The following code is submitted: data WORK.FINAL_EMPS; set WORK.EMPLOYEE WORK.NEW_EMPS; run; proc print data=WORK.FINAL_EMPS; title 'The RESULTS Data Set'; run; What is the resulting data set?

A : The RESULTS Data Set nameDeptage TomEngineering36 SallyHR42 Davidengineering30 Mary27

B : The RESULTS Data Set nameDeptage TomEngineering36 SallyHR42 Davidengineering30 Maryengineering27

C : The RESULTS Data Set nameDeptage TomEngineering36 SallyHR42 Davidengineering30

D : The RESULTS Data Set nameDeptage Mary27 TomEngineering36 SallyHR42 Davidengineering30

Answer: A

Question 3

Assume that Sasuser.One does not exist and that the following SAS program is submitted at the beginning of a new SAS session: data sasuser.one; x=1; y=27; output one; run; Select one:

A : The data set Sasuser.One is created with 2 variables and 3 observations.

B : The data set Sasuser.One is created with 2 variables and 0 observations.

C : The data set Work.One is created with 2 variables and 1 observation.

D : The data set Sasuser.One is created with 2 variables and 1 observation.

Answer: B

Question 4

Which program below creates the following output?

A : proc sort data=cert.credit; by type descending; run;

B : proc print data=cert.credit; by type; run;

C : proc sort data=cert.credit; by type ascending; run;

D : proc sort data=cert.credit; by type; run;

Answer: D

Question 5

Because of the growth within the 919 area code, the telephone exchange 555 is being reassigned to the 920 area code. The data set Clients.Piedmont includes the variable Phone, which contains telephone numbers in the form 919-555-1234. Which of the following programs correctly changes the values of Phone?

A : data work.piedmont(drop=areacode exchange); set cert.piedmont; Areacode=substr(phone,1,3); Exchange=substr(phone,5,3); if areacode='919' and exchange='555' then phone=scan('920',1,3); run;

B : data work.piedmont(drop=areacode exchange); set cert.piedmont; Areacode=substr(phone,1,3); Exchange=substr(phone,5,3); if areacode='919' and exchange='555' then scan(phone,1,3)='920'; run;

C : data work.piedmont(drop=areacode exchange); set cert.piedmont; Areacode=substr(phone,1,3); Exchange=substr(phone,5,3); if areacode='919' and exchange='555' then phone=substr('920',1,3); run;

D : data work.piedmont(drop=areacode exchange); set cert.piedmont; Areacode=substr(phone,1,3); Exchange=substr(phone,5,3); if areacode='919' and exchange='555' then substr(phone,1,3)='920'; run;

Answer: D

Page: 1 / 38

Total 186 Questions | Updated On: Apr 12, 2025

Add To Cart