Premium

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



Question : The observations in the SAS data set EMPLOYEE.TEST are ordered by the values of the variable SALARY.
The following SAS program is submitted:
proc sort data = employee.test out = employee.testsorted;
by name;
run;
Which one of the following is the result of the SAS program?
: The observations in the SAS data set EMPLOYEE.TEST are ordered by the values of the variable SALARY.
1. The data set EMPLOYEE.TEST is stored in ascending order by values of the NAME variable.
2. The data set EMPLOYEE.TEST is stored in descending order by values of the NAME variable.
 3. Access Mostly Uused Products by 50000+ Subscribers
4. The data set EMPLOYEE.TESTSORTED is stored in descending order by values of the NAME variable.

Correct Answer : Get Lastest Questions and Answer :





Question : Which one of the following statements is true regarding the name of a SAS array?

: Which one of the following statements is true regarding the name of a SAS array?
1. It is saved with the data set.
2. It can be used in procedures.
 3. Access Mostly Uused Products by 50000+ Subscribers
4. It can be the same as the name of a variable in the data set.

Correct Answer : Get Lastest Questions and Answer :
What is a SAS array?

a set of variables grouped together for the duration of a data step by being given a name in an ARRAY statement.
It a dummy variable exist just for the calculation purposes.






Question : The following SAS program is submitted:
data stats;
set revenue;
array weekly{5} mon tue wed thu fri;

total = weekly{i} * .25;
output;
end;
run;
Which one of the following DO statements completes the program and processes the elements of the WEEKLY array?
: The following SAS program is submitted:
1. do i = 1 to 5;
2. do weekly{i} = 1 to 5;
 3. Access Mostly Uused Products by 50000+ Subscribers
4. A DO loop cannot be used because the variables referenced do not end in a digit.

Correct Answer : Get Lastest Questions and Answer :
It is because you need a do loop to go through it 5 times for the 5 days and call the do lpool 'i'. This can then be referenced later on in 'total = weekly{i} * .25;'



Related Questions

Question : The following SAS program is submitted:
data work.retail;
cost = `20000';
total= .10* cost
run;
What is the result?
 : The following SAS program is submitted:
1. The value of the variable TOTAL in the output data set is 2000. No messages are written to the SAS log.
2. The value of the variable TOTAL in the output data set is 2000. A note that conversion has taken place is written to the SAS log.
3. Access Mostly Uused Products by 50000+ Subscribers
4. The variable TOTAL in the output data set has no value. The program fails to execute due to a syntax error.


Question : Which program can be used to create the
output similar to shown in left?
 : Which program can be used to create the
1. proc means data=clinic.diabetes;
var age height weight;
class sex;
output out=work.sum_gender
mean=AvgAge AvgHeight AvgWeight;
run;
2. proc summary data=clinic.diabetes print;
var age height weight; class sex;
output out=work.sum_gender
mean=AvgAge AvgHeight AvgWeight;
run;
 3. Access Mostly Uused Products by 50000+ Subscribers
var age height weight;
class sex;
output out=work.sum_gender
mean=AvgAge AvgHeight AvgWeight;
run;
4. Both a and b.


Question : You have been given a dataset named hetrain.helr , you have been using the PROC PRINT statement to print the dataset, with the labels.
However, labels are not stored in the dataset than which of the following is a correct statement PORC PRINT statement >

 : You have been given a dataset named hetrain.helr , you have been using the PROC PRINT statement to print the dataset, with the labels.
1. proc print data=hetrain.helr1 label;
label welcome='Welcome to HadoopExam Learning Resources';
run;


2. proc print data=hetrain.helr1;
label welcome='Welcome to HadoopExam Learning Resources';
run;


 3. Access Mostly Uused Products by 50000+ Subscribers
run;


4. proc print hetrain.helr1 label;
run;



Question : You have been given a data set, which contains all the training courses provided by the HadoopExam.com, now you need to select particular
data which has only three courses in output which are Hadoop, SAS, and Spark. Which of the following is correct statement to select these specific
courses?

 : You have been given a data set, which contains all the training courses provided by the HadoopExam.com, now you need to select particular
1. where courses='Hadoop' or 'SAS' or 'Spark';

2. where courses in 'Hadoop' or 'SAS' or 'Spark';

 3. Access Mostly Uused Products by 50000+ Subscribers

4. where courses in ('Hadoop','SAS','Spark');



Question : You have been given some dataset HETRAIN.HELR, now you need to sort this dataset and sorted data needs to be copied in new dataset named
NEWCOURSES. Which of the following is correct syntax?

 : You have been given some dataset HETRAIN.HELR, now you need to sort this dataset and sorted data needs to be copied in new dataset named
1. proc sort data=work.newcourses out=hetrain.helr1;
run;


2. proc sort helr1 out=newcourses;
by name;
run;


 3. Access Mostly Uused Products by 50000+ Subscribers
by name;
run;


4. proc sort from hetrain.helr1 to newcourses;
by name;
run;



Question : Which of the following statement is correct when you want Date to appear on top of the page and output should not have page number defined?

 : Which of the following statement is correct when you want Date to appear on top of the page and output should not have page number defined?
1. When you want DATE without page number in output use system option date and withoutnumber

2. When you want DATE without page number in output use system option date and withoutpagenumber

 3. Access Mostly Uused Products by 50000+ Subscribers

4. When you want DATE without page number in output use system option date and NONNUMBER