Base SAS Certified Associate: Programming Fundamentals Using SAS Questions and Answers (Dumps and Practice Questions)

Question : The following SAS program is submitted:
libname company 'SAS-data-library';
proc sort data = employee.payroll;
by EmployeeIDNumber;
run;
Write access has been granted to the EMPLOYEE library.
Which one of the following represents how the observations are sorted?

1. EMPLOYEE.PAYROLL is recreated in sorted order by EmployeeIDNumber.
2. EMPLOYEE.PAYROLL is stored in original order, and a new data set PAYROLL is created in sorted order by
EmployeeIDNumber.
3. EMPLOYEE.PAYROLL is stored in original order, and a new data set COMPANY.PAYROLLSORTED is created in sorted order
by EmployeeIDNumber.
4. EMPLOYEE.PAYROLL is recreated in sorted order by EmployeeIDNumber, and a new data set PAYROLL is created in sorted
order by EmployeeIDNumber.

Correct Answer : Get Lastest Questions and Answer :
IF we do not create a new data set then it stores on original data in sorted form. It was the easiest question.
no OUT so no new data. but the EMPLOYEE.PAYROLL is sorted order by EmployeeIDNumber.





Question : The SAS data set EMPLOYEE_INFO is listed below:
IDNumber Expenses
2542 100.00
3612 133.15
2198 234.34
2198 111.12
The following SAS program is submitted:
proc sort data = employee_info;

run;
Which one of the following BY statements completes the program and sorts the data sequentially by ascending expense values within
each ascending IDNUMBER value?

1. by Expenses IDNumber;
2. by IDNumber Expenses;
3. Access Mostly Uused Products by 50000+ Subscribers
4. by ascending IDNumber ascending Expenses;

Correct Answer : Get Lastest Questions and Answer :
By default SAS will sort in ascending order, if you want descending then you specify descending keyword before the variable name. Now here we want ascending expense values within
each ascending IDNUMBER value in our by statement we should have IDNUMBER first and then expenses.





Question : The SAS data set WORK.AWARDS is listed below:
fname points
Amy 2
Amy 1
Gerard 3
Wang 3
Wang 1
Wang 2
The following SAS program is submitted:
proc sort data = work.awards;
by descending fname points;
run;
Which one of the option from left image represents how the observations are sorted?

1.
2.
3. Access Mostly Uused Products by 50000+ Subscribers
4.

Correct Answer : Get Lastest Questions and Answer :

it displays descending order for the first variable
Name is sorted in Desceding order and it can by any Wang but points is by default sorted in ascendign order therefore
name: points
wang 1
wang 2
wang 3 and so on.

Reason is SAS only applies the descending order to the immediate variable next to it, the descending term wont affect the second variable points

Related Questions

---

Question : You have been using SAS program since quite long time and you are always using the SAS PUTLOG statements, in which case it is very helpful?


1. Syntax Error

2. Semantic Errors

3. Access Mostly Uused Products by 50000+ Subscribers

4. Any of the above



Question : Which of the following code can generate below results?


1. proc print data=hetrain.helr1 noobs;
var ID DATE date8. LOCATION$ FEE;
label DATE='Start On' LOCATION='Training Venue';
where FEE>=4000;
run;


2. proc print data=hetrain.helr1;
var ID DATE date8. LOCATION$ FEE;
where FEE>=4000;
label DATE='Start On' LOCATION='Training Venue';
run;


3. Access Mostly Uused Products by 50000+ Subscribers
id date;
var ID DATE LOCATION FEE;
label DATE='Start On' LOCATION='Training Venue';
where FEE>=4000;
format DATE date10.;
run;


4. proc print hetrain.helr1 noobs;
id date;
var ID DATE date8. LOCATION FEE;
where FEE>=4000;
run;



Question : Which group processing statement produced the PROC MEANS output shown in left ?


1. class sex survive;
2. class survive sex;
3. Access Mostly Uused Products by 50000+ Subscribers
4. by survive sex;





Question : What is the purpose or the MISSOVER option on the INFILE statement?

1. It prevents SAS from loading a new record when the end of the current record is reached.
2. It enables SAS to scan the input data records until the character string that is specified in the
@`character-string' expression is round.
3. Access Mostly Uused Products by 50000+ Subscribers
input tine for all the variables in the statement.
4. It causes the DATA step to stop processing if an INPUT statement reaches the end of the current
record without finding values for all variables in the statement.


Question : A user-defined format has been created using the FORMAT procedure. Where is it stored?


1. in a SAS catalog
2. in an external binary file
3. Access Mostly Uused Products by 50000+ Subscribers
4. in a SAS dataset in a permanent SAS data library



Question :The following SAS program is submitted, creating the SAS data set ONE:
data one;
infile `file specification';
input num chars$;
run;
ONE
NUMCHAR
----------------
The following SAS program is submitted:
proc print data = one;
where char = 23;
run;
What is output?

1. NUM CHAR
1 77
2. NUM CHAR
1 23
3 23
3. Access Mostly Uused Products by 50000+ Subscribers
1 23
3 23
1 77
4. No output is generated.